APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on IGC_TBL_NUMBER

Line 1020: (period_num igc_tbl_number,

1016:
1017:
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,

Line 1026: quarter_num igc_tbl_number );

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:
1028:
1029: l_prd_dtls_rec period_dtls_rec_type ;
1030: l_curr_period_rec period_dtls_rec_type ;

Line 1579: (line_id igc_tbl_number,

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

Line 1580: line_location_id igc_tbl_number,

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

Line 1581: distribution_id igc_tbl_number,

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

Line 1774: p_distribution_id_tbl IN igc_tbl_number,

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

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

3184: x_msg_buf OUT NOCOPY VARCHAR2
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 ;

Line 4815: (po_release_id igc_tbl_number,

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

Line 4816: po_header_id igc_tbl_number,

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

Line 4817: req_header_id igc_tbl_number);

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