APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on IGC_TBL_NUMBER

Line 1019: (period_num igc_tbl_number,

1015:
1016:
1017: -- bug 2804025 ssmales 19-Feb-2003 added quarter num to period_dtls_rec_type
1018: TYPE period_dtls_rec_type IS RECORD
1019: (period_num igc_tbl_number,
1020: period_name igc_tbl_varchar30,
1021: start_date igc_tbl_date,
1022: end_date igc_tbl_date,
1023: gl_period_status igc_tbl_varchar5,

Line 1025: quarter_num igc_tbl_number );

1021: start_date igc_tbl_date,
1022: end_date igc_tbl_date,
1023: gl_period_status igc_tbl_varchar5,
1024: po_period_status igc_tbl_varchar5,
1025: quarter_num igc_tbl_number );
1026:
1027:
1028: l_prd_dtls_rec period_dtls_rec_type ;
1029: l_curr_period_rec period_dtls_rec_type ;

Line 1578: (line_id igc_tbl_number,

1574: p_document_id IN NUMBER
1575: ) RETURN VARCHAR2 AS
1576:
1577: TYPE valid_dist_rec_type IS RECORD
1578: (line_id igc_tbl_number,
1579: line_location_id igc_tbl_number,
1580: distribution_id igc_tbl_number,
1581: invoice_number igc_tbl_varchar100,
1582: result_error_code igc_tbl_varchar40);

Line 1579: line_location_id igc_tbl_number,

1575: ) RETURN VARCHAR2 AS
1576:
1577: TYPE valid_dist_rec_type IS RECORD
1578: (line_id igc_tbl_number,
1579: line_location_id igc_tbl_number,
1580: distribution_id igc_tbl_number,
1581: invoice_number igc_tbl_varchar100,
1582: result_error_code igc_tbl_varchar40);
1583:

Line 1580: distribution_id igc_tbl_number,

1576:
1577: TYPE valid_dist_rec_type IS RECORD
1578: (line_id igc_tbl_number,
1579: line_location_id igc_tbl_number,
1580: distribution_id igc_tbl_number,
1581: invoice_number igc_tbl_varchar100,
1582: result_error_code igc_tbl_varchar40);
1583:
1584: l_valid_dist_rec valid_dist_rec_type ;

Line 1773: p_distribution_id_tbl IN igc_tbl_number,

1769: PROCEDURE Create_Journal_Adjustments(p_sobid IN NUMBER,
1770: p_year IN NUMBER,
1771: p_document_type IN VARCHAR2,
1772: p_document_subtype IN VARCHAR2,
1773: p_distribution_id_tbl IN igc_tbl_number,
1774: p_prev_year_end_period IN VARCHAR2,
1775: p_prev_year_end_num IN NUMBER,
1776: p_prev_year_end_quarter IN NUMBER,
1777: p_curr_year_start_period IN VARCHAR2,

Line 3187: l_distribution_id_tbl igc_tbl_number := igc_tbl_number(0);

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

Line 4814: (po_release_id igc_tbl_number,

4810:
4811:
4812:
4813: TYPE document_rec_type IS RECORD
4814: (po_release_id igc_tbl_number,
4815: po_header_id igc_tbl_number,
4816: req_header_id igc_tbl_number);
4817:
4818: l_document_id_rec document_rec_type;

Line 4815: po_header_id igc_tbl_number,

4811:
4812:
4813: TYPE document_rec_type IS RECORD
4814: (po_release_id igc_tbl_number,
4815: po_header_id igc_tbl_number,
4816: req_header_id igc_tbl_number);
4817:
4818: l_document_id_rec document_rec_type;
4819: l_return_code NUMBER := -99 ;

Line 4816: req_header_id igc_tbl_number);

4812:
4813: TYPE document_rec_type IS RECORD
4814: (po_release_id igc_tbl_number,
4815: po_header_id igc_tbl_number,
4816: req_header_id igc_tbl_number);
4817:
4818: l_document_id_rec document_rec_type;
4819: l_return_code NUMBER := -99 ;
4820: l_msg_buf VARCHAR2(2000) := null ;