insert values in a table using procedures

I have 3 tables i.e.

SQL> desc sales;

 Name                                      Null?    Type


 ----------------------------------------- -------- ----------------


 PROD_ID                                   NOT NULL NUMBER(6)
 CUST_ID                                   NOT NULL NUMBER
 TIME_ID                                   NOT NULL DATE
 CHANNEL_ID                                NOT NULL CHAR(1)
 PROMO_ID                                  NOT NULL NUMBER(6)
 QUANTITY_SOLD                             NOT NULL NUMBER(3)
 AMOUNT_SOLD                               NOT NULL NUMBER(10,2)

SQL> desc promotions
 Name                                      Null?    Type


 ----------------------------------------- -------- ----------------


 PROMO_ID                                  NOT NULL NUMBER(6)
 PROMO_NAME                                NOT NULL VARCHAR2(20)
 PROMO_SUBCATEGORY                         NOT NULL VARCHAR2(30)
 PROMO_CATEGORY                            NOT NULL VARCHAR2(30)
 PROMO_COST                                NOT NULL NUMBER(10,2)
 PROMO_BEGIN_DATE                          NOT NULL DATE
 PROMO_END_DATE                            NOT NULL DATE
 PROMO_TOTAL                                        VARCHAR2(15)

SQL> desc times
 Name                                      Null?    Type


 ----------------------------------------- -------- ----------------


 TIME_ID                                   NOT NULL DATE
 DAY_NAME                                  NOT NULL VARCHAR2(9)
 DAY_NUMBER_IN_WEEK                        NOT NULL NUMBER(1)
 DAY_NUMBER_IN_MONTH                       NOT NULL NUMBER(2)
 CALENDAR_WEEK_NUMBER                      NOT NULL NUMBER(2)
 FISCAL_WEEK_NUMBER                        NOT NULL NUMBER(2)
 WEEK_ENDING_DAY                           NOT NULL DATE
 CALENDAR_MONTH_NUMBER                     NOT NULL NUMBER(2)
 FISCAL_MONTH_NUMBER                       NOT NULL NUMBER(2)
 CALENDAR_MONTH_DESC                       NOT NULL VARCHAR2(8)
 FISCAL_MONTH_DESC                         NOT NULL VARCHAR2(8)
 DAYS_IN_CAL_MONTH                         NOT NULL NUMBER
 DAYS_IN_FIS_MONTH                         NOT NULL NUMBER
 END_OF_CAL_MONTH                          NOT NULL DATE
 END_OF_FIS_MONTH                          NOT NULL DATE
 CALENDAR_MONTH_NAME                       NOT NULL VARCHAR2(9)
 FISCAL_MONTH_NAME                         NOT NULL VARCHAR2(9)
 CALENDAR_QUARTER_DESC                     NOT NULL CHAR(7)
 FISCAL_QUARTER_DESC                       NOT NULL CHAR(7)
 DAYS_IN_CAL_QUARTER                       NOT NULL NUMBER
 DAYS_IN_FIS_QUARTER                       NOT NULL NUMBER
 END_OF_CAL_QUARTER                        NOT NULL DATE
 END_OF_FIS_QUARTER                        NOT NULL DATE
 CALENDAR_QUARTER_NUMBER                   NOT NULL NUMBER(1)
 FISCAL_QUARTER_NUMBER                     NOT NULL NUMBER(1)
 CALENDAR_YEAR                             NOT NULL NUMBER(4)
 FISCAL_YEAR                               NOT NULL NUMBER(4)
 DAYS_IN_CAL_YEAR                          NOT NULL NUMBER
 DAYS_IN_FIS_YEAR                          NOT NULL NUMBER
 END_OF_CAL_YEAR                           NOT NULL DATE
 END_OF_FIS_YEAR                           NOT NULL DATE

and I have create one table t1

desc t1

Promo_name        varchar2(20)
promo_subcategory    varchar2(30)
promo_category         varchar2(30)
calendar_month_desc   varchar2(8)
total_quantity_sold       number(8)
total_amount_sold       number(10,2)

how insert the values in t1 table using procedure Received on Sat Oct 18 2008 - 01:27:27 CDT