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 6530: l_mmtt_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

6526: --BUG#6873037
6527: -- No need to verify inventory period status
6528: --OR oap.open_flag = 'N');
6529: --
6530: l_mmtt_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6531: l_transaction_id_tab DBMS_SQL.NUMBER_TABLE;
6532: l_transaction_date_tab DBMS_SQL.DATE_TABLE;
6533: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6534: l_open_flag DBMS_SQL.VARCHAR2_TABLE;

Line 6531: l_transaction_id_tab DBMS_SQL.NUMBER_TABLE;

6527: -- No need to verify inventory period status
6528: --OR oap.open_flag = 'N');
6529: --
6530: l_mmtt_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6531: l_transaction_id_tab DBMS_SQL.NUMBER_TABLE;
6532: l_transaction_date_tab DBMS_SQL.DATE_TABLE;
6533: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6534: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6535: l_period_start_date_tab DBMS_SQL.DATE_TABLE;

Line 6532: l_transaction_date_tab DBMS_SQL.DATE_TABLE;

6528: --OR oap.open_flag = 'N');
6529: --
6530: l_mmtt_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6531: l_transaction_id_tab DBMS_SQL.NUMBER_TABLE;
6532: l_transaction_date_tab DBMS_SQL.DATE_TABLE;
6533: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6534: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6535: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6536: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;

Line 6533: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;

6529: --
6530: l_mmtt_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6531: l_transaction_id_tab DBMS_SQL.NUMBER_TABLE;
6532: l_transaction_date_tab DBMS_SQL.DATE_TABLE;
6533: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6534: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6535: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6536: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;
6537: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;

Line 6534: l_open_flag DBMS_SQL.VARCHAR2_TABLE;

6530: l_mmtt_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6531: l_transaction_id_tab DBMS_SQL.NUMBER_TABLE;
6532: l_transaction_date_tab DBMS_SQL.DATE_TABLE;
6533: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6534: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6535: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6536: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;
6537: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6538: l_good_open_flag_tab DBMS_SQL.VARCHAR2_TABLE;

Line 6535: l_period_start_date_tab DBMS_SQL.DATE_TABLE;

6531: l_transaction_id_tab DBMS_SQL.NUMBER_TABLE;
6532: l_transaction_date_tab DBMS_SQL.DATE_TABLE;
6533: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6534: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6535: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6536: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;
6537: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6538: l_good_open_flag_tab DBMS_SQL.VARCHAR2_TABLE;
6539: l_organization_id_tab DBMS_SQL.VARCHAR2_TABLE;

Line 6536: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;

6532: l_transaction_date_tab DBMS_SQL.DATE_TABLE;
6533: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6534: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6535: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6536: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;
6537: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6538: l_good_open_flag_tab DBMS_SQL.VARCHAR2_TABLE;
6539: l_organization_id_tab DBMS_SQL.VARCHAR2_TABLE;
6540:

Line 6537: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;

6533: l_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6534: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6535: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6536: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;
6537: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6538: l_good_open_flag_tab DBMS_SQL.VARCHAR2_TABLE;
6539: l_organization_id_tab DBMS_SQL.VARCHAR2_TABLE;
6540:
6541:

Line 6538: l_good_open_flag_tab DBMS_SQL.VARCHAR2_TABLE;

6534: l_open_flag DBMS_SQL.VARCHAR2_TABLE;
6535: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6536: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;
6537: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6538: l_good_open_flag_tab DBMS_SQL.VARCHAR2_TABLE;
6539: l_organization_id_tab DBMS_SQL.VARCHAR2_TABLE;
6540:
6541:
6542: CURSOR next_inv_period(p_organization_id IN NUMBER

Line 6539: l_organization_id_tab DBMS_SQL.VARCHAR2_TABLE;

6535: l_period_start_date_tab DBMS_SQL.DATE_TABLE;
6536: l_schedule_close_date_tab DBMS_SQL.DATE_TABLE;
6537: l_good_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6538: l_good_open_flag_tab DBMS_SQL.VARCHAR2_TABLE;
6539: l_organization_id_tab DBMS_SQL.VARCHAR2_TABLE;
6540:
6541:
6542: CURSOR next_inv_period(p_organization_id IN NUMBER
6543: ,p_transaction_date IN DATE)

Line 6554: l_upd_transaction_date_tab DBMS_SQL.DATE_TABLE;

6550: AND period_start_date >= p_transaction_date;
6551: l_next_acct_period_id NUMBER;
6552: l_next_transaction_date DATE;
6553:
6554: l_upd_transaction_date_tab DBMS_SQL.DATE_TABLE;
6555: l_upd_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6556: g_bulk_fetch_size NUMBER := 9999;
6557: l_last_fetch BOOLEAN := FALSE;
6558: l_msg_count NUMBER := 0;

Line 6555: l_upd_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;

6551: l_next_acct_period_id NUMBER;
6552: l_next_transaction_date DATE;
6553:
6554: l_upd_transaction_date_tab DBMS_SQL.DATE_TABLE;
6555: l_upd_acct_period_id_tab DBMS_SQL.NUMBER_TABLE;
6556: g_bulk_fetch_size NUMBER := 9999;
6557: l_last_fetch BOOLEAN := FALSE;
6558: l_msg_count NUMBER := 0;
6559: l_msg_data VARCHAR2(8000) := '';

Line 6675: l_cnt_tab DBMS_SQL.NUMBER_TABLE;

6671: WHERE potentially_unmatched_flag = 'Y'
6672: GROUP BY ledger_id
6673: HAVING COUNT(*) > 0;
6674:
6675: l_cnt_tab DBMS_SQL.NUMBER_TABLE;
6676: l_lgr_tab DBMS_SQL.NUMBER_TABLE;
6677: lafin EXCEPTION;
6678: BEGIN
6679: debug('crrl_preparation +');

Line 6676: l_lgr_tab DBMS_SQL.NUMBER_TABLE;

6672: GROUP BY ledger_id
6673: HAVING COUNT(*) > 0;
6674:
6675: l_cnt_tab DBMS_SQL.NUMBER_TABLE;
6676: l_lgr_tab DBMS_SQL.NUMBER_TABLE;
6677: lafin EXCEPTION;
6678: BEGIN
6679: debug('crrl_preparation +');
6680: debug(' p_batch_size :'||p_batch_size);

Line 6733: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

6729: WHERE potentially_unmatched_flag = 'Y'
6730: AND ledger_id = p_ledger_id
6731: ORDER BY revenue_om_line_id ASC;
6732:
6733: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6734: l_upd_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6735: clear_tab DBMS_SQL.VARCHAR2_TABLE;
6736: l_romlid_tab DBMS_SQL.NUMBER_TABLE;
6737: l_oml_upd_tab DBMS_SQL.NUMBER_TABLE;

Line 6734: l_upd_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

6730: AND ledger_id = p_ledger_id
6731: ORDER BY revenue_om_line_id ASC;
6732:
6733: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6734: l_upd_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6735: clear_tab DBMS_SQL.VARCHAR2_TABLE;
6736: l_romlid_tab DBMS_SQL.NUMBER_TABLE;
6737: l_oml_upd_tab DBMS_SQL.NUMBER_TABLE;
6738: l_last_fetch BOOLEAN := FALSE;

Line 6735: clear_tab DBMS_SQL.VARCHAR2_TABLE;

6731: ORDER BY revenue_om_line_id ASC;
6732:
6733: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6734: l_upd_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6735: clear_tab DBMS_SQL.VARCHAR2_TABLE;
6736: l_romlid_tab DBMS_SQL.NUMBER_TABLE;
6737: l_oml_upd_tab DBMS_SQL.NUMBER_TABLE;
6738: l_last_fetch BOOLEAN := FALSE;
6739: l_last_om_id NUMBER := -9999;

Line 6736: l_romlid_tab DBMS_SQL.NUMBER_TABLE;

6732:
6733: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6734: l_upd_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6735: clear_tab DBMS_SQL.VARCHAR2_TABLE;
6736: l_romlid_tab DBMS_SQL.NUMBER_TABLE;
6737: l_oml_upd_tab DBMS_SQL.NUMBER_TABLE;
6738: l_last_fetch BOOLEAN := FALSE;
6739: l_last_om_id NUMBER := -9999;
6740: cnt NUMBER := 0;

Line 6737: l_oml_upd_tab DBMS_SQL.NUMBER_TABLE;

6733: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6734: l_upd_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6735: clear_tab DBMS_SQL.VARCHAR2_TABLE;
6736: l_romlid_tab DBMS_SQL.NUMBER_TABLE;
6737: l_oml_upd_tab DBMS_SQL.NUMBER_TABLE;
6738: l_last_fetch BOOLEAN := FALSE;
6739: l_last_om_id NUMBER := -9999;
6740: cnt NUMBER := 0;
6741: l_bulk_size NUMBER := 9999;

Line 6744: (p_rowid_tab IN DBMS_SQL.VARCHAR2_TABLE) IS

6740: cnt NUMBER := 0;
6741: l_bulk_size NUMBER := 9999;
6742:
6743: PROCEDURE update_one_set_crrl
6744: (p_rowid_tab IN DBMS_SQL.VARCHAR2_TABLE) IS
6745: l_gp_id NUMBER;
6746: BEGIN
6747: SELECT cst_cogs_events_s.nextval
6748: INTO l_gp_id

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

6768: END update_one_set_crrl;
6769:
6770: PROCEDURE add_rowid
6771: ( p_rowid IN VARCHAR2
6772: ,x_rowid_tab IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE)
6773: IS
6774: BEGIN
6775: x_rowid_tab(x_rowid_tab.COUNT+1) := p_rowid;
6776: END add_rowid;

Line 6947: l_req_id_tab DBMS_SQL.NUMBER_TABLE;

6943: ,rowid
6944: FROM cst_lists_temp
6945: WHERE varchar_1 = 'SUBMITTED';
6946:
6947: l_req_id_tab DBMS_SQL.NUMBER_TABLE;
6948: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6949: l_res BOOLEAN;
6950: l_phase VARCHAR2(30);
6951: l_status VARCHAR2(30);

Line 6948: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

6944: FROM cst_lists_temp
6945: WHERE varchar_1 = 'SUBMITTED';
6946:
6947: l_req_id_tab DBMS_SQL.NUMBER_TABLE;
6948: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
6949: l_res BOOLEAN;
6950: l_phase VARCHAR2(30);
6951: l_status VARCHAR2(30);
6952: l_dev_phase VARCHAR2(30);