DBA Data[Home] [Help]

APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on IGC_TBL_DATE

Line 1022: start_date igc_tbl_date,

1018: -- bug 2804025 ssmales 19-Feb-2003 added quarter num to period_dtls_rec_type
1019: TYPE period_dtls_rec_type IS RECORD
1020: (period_num igc_tbl_number,
1021: period_name igc_tbl_varchar30,
1022: start_date igc_tbl_date,
1023: end_date igc_tbl_date,
1024: gl_period_status igc_tbl_varchar5,
1025: po_period_status igc_tbl_varchar5,
1026: quarter_num igc_tbl_number );

Line 1023: end_date igc_tbl_date,

1019: TYPE period_dtls_rec_type IS RECORD
1020: (period_num igc_tbl_number,
1021: period_name igc_tbl_varchar30,
1022: start_date igc_tbl_date,
1023: end_date igc_tbl_date,
1024: gl_period_status igc_tbl_varchar5,
1025: po_period_status igc_tbl_varchar5,
1026: quarter_num igc_tbl_number );
1027:

Line 3189: l_gl_enc_date_tbl igc_tbl_date := igc_tbl_date(sysdate);

3185: ) AS
3186:
3187: -- need to initialize following tables, values are irrelevant
3188: l_distribution_id_tbl igc_tbl_number := igc_tbl_number(0);
3189: l_gl_enc_date_tbl igc_tbl_date := igc_tbl_date(sysdate);
3190: l_gl_enc_prd_tbl igc_tbl_varchar30 := igc_tbl_varchar30(null);
3191:
3192: TYPE c_prev_val_type IS REF CURSOR ;
3193: