eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_REVENUECOGSMATCH_PVT dependencies on DBMS_SQL

Line 1653: l_per_num_tab DBMS_SQL.NUMBER_TABLE;

1649: AND crrl.potentially_unmatched_flag = 'Y'
1650: ORDER BY crrl.acct_period_num ASC;
1651:
1652:
1653: l_per_num_tab DBMS_SQL.NUMBER_TABLE;
1654:
1655:
1656:
1657:

Line 1695: l_upd_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

1691: l_adj_mmt_txn_id_tbl number_table;
1692: l_adj_event_id_tbl number_table;
1693: l_adj_prior_event_id_tbl number_table;
1694:
1695: l_upd_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
1696:
1697: --BUG5726230
1698: l_ledger_id_tab number_table;
1699:

Line 6875: l_mmtt_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

6871: --BUG#6873037
6872: -- No need to verify inventory period status
6873: --OR oap.open_flag = 'N');
6874: --
6875: l_mmtt_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6876: l_transaction_id_tab DBMS_SQL.NUMBER_TABLE;
6877: l_transaction_date_tab DBMS_SQL.DATE_TABLE;
6878: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6879: l_open_flag DBMS_SQL.VARCHAR2_TABLE;

Line 6876: l_transaction_id_tab DBMS_SQL.NUMBER_TABLE;

6872: -- No need to verify inventory period status
6873: --OR oap.open_flag = 'N');
6874: --
6875: l_mmtt_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6876: l_transaction_id_tab DBMS_SQL.NUMBER_TABLE;
6877: l_transaction_date_tab DBMS_SQL.DATE_TABLE;
6878: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6879: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6880: l_period_start_date_tab DBMS_SQL.DATE_TABLE;

Line 6877: l_transaction_date_tab DBMS_SQL.DATE_TABLE;

6873: --OR oap.open_flag = 'N');
6874: --
6875: l_mmtt_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6876: l_transaction_id_tab DBMS_SQL.NUMBER_TABLE;
6877: l_transaction_date_tab DBMS_SQL.DATE_TABLE;
6878: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6879: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6880: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6881: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;

Line 6878: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;

6874: --
6875: l_mmtt_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6876: l_transaction_id_tab DBMS_SQL.NUMBER_TABLE;
6877: l_transaction_date_tab DBMS_SQL.DATE_TABLE;
6878: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6879: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6880: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6881: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;
6882: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;

Line 6879: l_open_flag DBMS_SQL.VARCHAR2_TABLE;

6875: l_mmtt_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6876: l_transaction_id_tab DBMS_SQL.NUMBER_TABLE;
6877: l_transaction_date_tab DBMS_SQL.DATE_TABLE;
6878: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6879: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6880: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6881: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;
6882: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6883: l_good_open_flag_tab DBMS_SQL.VARCHAR2_TABLE;

Line 6880: l_period_start_date_tab DBMS_SQL.DATE_TABLE;

6876: l_transaction_id_tab DBMS_SQL.NUMBER_TABLE;
6877: l_transaction_date_tab DBMS_SQL.DATE_TABLE;
6878: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6879: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6880: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6881: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;
6882: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6883: l_good_open_flag_tab DBMS_SQL.VARCHAR2_TABLE;
6884: l_organization_id_tab DBMS_SQL.VARCHAR2_TABLE;

Line 6881: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;

6877: l_transaction_date_tab DBMS_SQL.DATE_TABLE;
6878: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6879: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6880: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6881: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;
6882: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6883: l_good_open_flag_tab DBMS_SQL.VARCHAR2_TABLE;
6884: l_organization_id_tab DBMS_SQL.VARCHAR2_TABLE;
6885:

Line 6882: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;

6878: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6879: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6880: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6881: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;
6882: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6883: l_good_open_flag_tab DBMS_SQL.VARCHAR2_TABLE;
6884: l_organization_id_tab DBMS_SQL.VARCHAR2_TABLE;
6885:
6886:

Line 6883: l_good_open_flag_tab DBMS_SQL.VARCHAR2_TABLE;

6879: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6880: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6881: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;
6882: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6883: l_good_open_flag_tab DBMS_SQL.VARCHAR2_TABLE;
6884: l_organization_id_tab DBMS_SQL.VARCHAR2_TABLE;
6885:
6886:
6887: CURSOR next_inv_period(p_organization_id IN NUMBER

Line 6884: l_organization_id_tab DBMS_SQL.VARCHAR2_TABLE;

6880: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6881: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;
6882: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6883: l_good_open_flag_tab DBMS_SQL.VARCHAR2_TABLE;
6884: l_organization_id_tab DBMS_SQL.VARCHAR2_TABLE;
6885:
6886:
6887: CURSOR next_inv_period(p_organization_id IN NUMBER
6888: ,p_transaction_date IN DATE)

Line 6899: l_upd_transaction_date_tab DBMS_SQL.DATE_TABLE;

6895: AND period_start_date >= p_transaction_date;
6896: l_next_acct_period_id NUMBER;
6897: l_next_transaction_date DATE;
6898:
6899: l_upd_transaction_date_tab DBMS_SQL.DATE_TABLE;
6900: l_upd_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6901: g_bulk_fetch_size NUMBER := 9999;
6902: l_last_fetch BOOLEAN := FALSE;
6903: l_msg_count NUMBER := 0;

Line 6900: l_upd_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;

6896: l_next_acct_period_id NUMBER;
6897: l_next_transaction_date DATE;
6898:
6899: l_upd_transaction_date_tab DBMS_SQL.DATE_TABLE;
6900: l_upd_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6901: g_bulk_fetch_size NUMBER := 9999;
6902: l_last_fetch BOOLEAN := FALSE;
6903: l_msg_count NUMBER := 0;
6904: l_msg_data VARCHAR2(8000) := '';

Line 7019: l_cnt_tab DBMS_SQL.NUMBER_TABLE;

7015: WHERE potentially_unmatched_flag = 'Y'
7016: GROUP BY ledger_id
7017: HAVING COUNT(*) > 0;
7018:
7019: l_cnt_tab DBMS_SQL.NUMBER_TABLE;
7020: l_lgr_tab DBMS_SQL.NUMBER_TABLE;
7021: lafin EXCEPTION;
7022: BEGIN
7023: debug('crrl_preparation +');

Line 7020: l_lgr_tab DBMS_SQL.NUMBER_TABLE;

7016: GROUP BY ledger_id
7017: HAVING COUNT(*) > 0;
7018:
7019: l_cnt_tab DBMS_SQL.NUMBER_TABLE;
7020: l_lgr_tab DBMS_SQL.NUMBER_TABLE;
7021: lafin EXCEPTION;
7022: BEGIN
7023: debug('crrl_preparation +');
7024: debug(' p_batch_size :'||p_batch_size);

Line 7077: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

7073: WHERE potentially_unmatched_flag = 'Y'
7074: AND ledger_id = p_ledger_id
7075: ORDER BY revenue_om_line_id ASC;
7076:
7077: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
7078: l_upd_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
7079: clear_tab DBMS_SQL.VARCHAR2_TABLE;
7080: l_romlid_tab DBMS_SQL.NUMBER_TABLE;
7081: l_oml_upd_tab DBMS_SQL.NUMBER_TABLE;

Line 7078: l_upd_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

7074: AND ledger_id = p_ledger_id
7075: ORDER BY revenue_om_line_id ASC;
7076:
7077: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
7078: l_upd_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
7079: clear_tab DBMS_SQL.VARCHAR2_TABLE;
7080: l_romlid_tab DBMS_SQL.NUMBER_TABLE;
7081: l_oml_upd_tab DBMS_SQL.NUMBER_TABLE;
7082: l_last_fetch BOOLEAN := FALSE;

Line 7079: clear_tab DBMS_SQL.VARCHAR2_TABLE;

7075: ORDER BY revenue_om_line_id ASC;
7076:
7077: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
7078: l_upd_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
7079: clear_tab DBMS_SQL.VARCHAR2_TABLE;
7080: l_romlid_tab DBMS_SQL.NUMBER_TABLE;
7081: l_oml_upd_tab DBMS_SQL.NUMBER_TABLE;
7082: l_last_fetch BOOLEAN := FALSE;
7083: l_last_om_id NUMBER := -9999;

Line 7080: l_romlid_tab DBMS_SQL.NUMBER_TABLE;

7076:
7077: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
7078: l_upd_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
7079: clear_tab DBMS_SQL.VARCHAR2_TABLE;
7080: l_romlid_tab DBMS_SQL.NUMBER_TABLE;
7081: l_oml_upd_tab DBMS_SQL.NUMBER_TABLE;
7082: l_last_fetch BOOLEAN := FALSE;
7083: l_last_om_id NUMBER := -9999;
7084: cnt NUMBER := 0;

Line 7081: l_oml_upd_tab DBMS_SQL.NUMBER_TABLE;

7077: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
7078: l_upd_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
7079: clear_tab DBMS_SQL.VARCHAR2_TABLE;
7080: l_romlid_tab DBMS_SQL.NUMBER_TABLE;
7081: l_oml_upd_tab DBMS_SQL.NUMBER_TABLE;
7082: l_last_fetch BOOLEAN := FALSE;
7083: l_last_om_id NUMBER := -9999;
7084: cnt NUMBER := 0;
7085: l_bulk_size NUMBER := 9999;

Line 7088: (p_rowid_tab IN DBMS_SQL.VARCHAR2_TABLE) IS

7084: cnt NUMBER := 0;
7085: l_bulk_size NUMBER := 9999;
7086:
7087: PROCEDURE update_one_set_crrl
7088: (p_rowid_tab IN DBMS_SQL.VARCHAR2_TABLE) IS
7089: l_gp_id NUMBER;
7090: BEGIN
7091: SELECT cst_cogs_events_s.nextval
7092: INTO l_gp_id

Line 7116: ,x_rowid_tab IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE)

7112: END update_one_set_crrl;
7113:
7114: PROCEDURE add_rowid
7115: ( p_rowid IN VARCHAR2
7116: ,x_rowid_tab IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE)
7117: IS
7118: BEGIN
7119: x_rowid_tab(x_rowid_tab.COUNT+1) := p_rowid;
7120: END add_rowid;

Line 7291: l_req_id_tab DBMS_SQL.NUMBER_TABLE;

7287: ,rowid
7288: FROM cst_lists_temp
7289: WHERE varchar_1 = 'SUBMITTED';
7290:
7291: l_req_id_tab DBMS_SQL.NUMBER_TABLE;
7292: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
7293: l_res BOOLEAN;
7294: l_phase VARCHAR2(30);
7295: l_status VARCHAR2(30);

Line 7292: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

7288: FROM cst_lists_temp
7289: WHERE varchar_1 = 'SUBMITTED';
7290:
7291: l_req_id_tab DBMS_SQL.NUMBER_TABLE;
7292: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
7293: l_res BOOLEAN;
7294: l_phase VARCHAR2(30);
7295: l_status VARCHAR2(30);
7296: l_dev_phase VARCHAR2(30);

Line 7591: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

7587: AND glp.ledger_id = p_ledger_id
7588: AND cce.event_date BETWEEN glp.start_date AND glp.end_date + EndDateNum
7589: AND crrl.acct_period_num < glp.effective_period_num;
7590:
7591: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
7592: l_flag_tab DBMS_SQL.VARCHAR2_TABLE;
7593: BEGIN
7594: debug ('check_eligible_lines +');
7595: debug (' p_ledger_id : '||p_ledger_id);

Line 7592: l_flag_tab DBMS_SQL.VARCHAR2_TABLE;

7588: AND cce.event_date BETWEEN glp.start_date AND glp.end_date + EndDateNum
7589: AND crrl.acct_period_num < glp.effective_period_num;
7590:
7591: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
7592: l_flag_tab DBMS_SQL.VARCHAR2_TABLE;
7593: BEGIN
7594: debug ('check_eligible_lines +');
7595: debug (' p_ledger_id : '||p_ledger_id);
7596:

Line 7751: l_number_1_t DBMS_SQL.NUMBER_TABLE;

7747: WHERE ledger_id = p_ledger_id
7748: AND application_id = 101
7749: AND EFFECTIVE_PERIOD_NUM >= p_low_per_num
7750: AND EFFECTIVE_PERIOD_NUM <= p_hig_per_num;
7751: l_number_1_t DBMS_SQL.NUMBER_TABLE;
7752: l_number_2_t DBMS_SQL.NUMBER_TABLE;
7753: l_varchar_1_t DBMS_SQL.VARCHAR2_TABLE;
7754: l_list_id_t DBMS_SQL.NUMBER_TABLE;
7755: l_number_3_t DBMS_SQL.NUMBER_TABLE;

Line 7752: l_number_2_t DBMS_SQL.NUMBER_TABLE;

7748: AND application_id = 101
7749: AND EFFECTIVE_PERIOD_NUM >= p_low_per_num
7750: AND EFFECTIVE_PERIOD_NUM <= p_hig_per_num;
7751: l_number_1_t DBMS_SQL.NUMBER_TABLE;
7752: l_number_2_t DBMS_SQL.NUMBER_TABLE;
7753: l_varchar_1_t DBMS_SQL.VARCHAR2_TABLE;
7754: l_list_id_t DBMS_SQL.NUMBER_TABLE;
7755: l_number_3_t DBMS_SQL.NUMBER_TABLE;
7756: BEGIN

Line 7753: l_varchar_1_t DBMS_SQL.VARCHAR2_TABLE;

7749: AND EFFECTIVE_PERIOD_NUM >= p_low_per_num
7750: AND EFFECTIVE_PERIOD_NUM <= p_hig_per_num;
7751: l_number_1_t DBMS_SQL.NUMBER_TABLE;
7752: l_number_2_t DBMS_SQL.NUMBER_TABLE;
7753: l_varchar_1_t DBMS_SQL.VARCHAR2_TABLE;
7754: l_list_id_t DBMS_SQL.NUMBER_TABLE;
7755: l_number_3_t DBMS_SQL.NUMBER_TABLE;
7756: BEGIN
7757: debug('prepare_acct_dates +');

Line 7754: l_list_id_t DBMS_SQL.NUMBER_TABLE;

7750: AND EFFECTIVE_PERIOD_NUM <= p_hig_per_num;
7751: l_number_1_t DBMS_SQL.NUMBER_TABLE;
7752: l_number_2_t DBMS_SQL.NUMBER_TABLE;
7753: l_varchar_1_t DBMS_SQL.VARCHAR2_TABLE;
7754: l_list_id_t DBMS_SQL.NUMBER_TABLE;
7755: l_number_3_t DBMS_SQL.NUMBER_TABLE;
7756: BEGIN
7757: debug('prepare_acct_dates +');
7758: debug(' p_ledger_id :'||p_ledger_id);

Line 7755: l_number_3_t DBMS_SQL.NUMBER_TABLE;

7751: l_number_1_t DBMS_SQL.NUMBER_TABLE;
7752: l_number_2_t DBMS_SQL.NUMBER_TABLE;
7753: l_varchar_1_t DBMS_SQL.VARCHAR2_TABLE;
7754: l_list_id_t DBMS_SQL.NUMBER_TABLE;
7755: l_number_3_t DBMS_SQL.NUMBER_TABLE;
7756: BEGIN
7757: debug('prepare_acct_dates +');
7758: debug(' p_ledger_id :'||p_ledger_id);
7759: debug(' p_low_per_num :'||p_low_per_num);