DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on GMS_INSTALL

Line 5066: l_gms_install BOOLEAN DEFAULT gms_install.enabled; -- Introduced for bug fix 2908859

5062: l_txn_source varchar2(30);
5063: l_gms_transaction_source VARCHAR2(30);
5064: l_org_id NUMBER(15);
5065: l_txn_interface_id NUMBER;
5066: l_gms_install BOOLEAN DEFAULT gms_install.enabled; -- Introduced for bug fix 2908859
5067:
5068: -- Introduced the following for R12 performance fixes (4507892)
5069: TYPE t_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5070: TYPE t_number_15 IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;

Line 5190: -- if (gms_install.site_enabled) then -- Commented for bug fix 2908859

5186: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering TR_TO_GMS_INT');
5187:
5188: -- gms_tie_tab.delete; Commented for bug fix 4625734
5189:
5190: -- if (gms_install.site_enabled) then -- Commented for bug fix 2908859
5191: if (l_gms_install) then -- Introduced for bug fix 2908859
5192: /***** Converted the following code as part of bug fix 4625734
5193: BEGIN
5194: SELECT transaction_source

Line 5191: if (l_gms_install) then -- Introduced for bug fix 2908859

5187:
5188: -- gms_tie_tab.delete; Commented for bug fix 4625734
5189:
5190: -- if (gms_install.site_enabled) then -- Commented for bug fix 2908859
5191: if (l_gms_install) then -- Introduced for bug fix 2908859
5192: /***** Converted the following code as part of bug fix 4625734
5193: BEGIN
5194: SELECT transaction_source
5195: INTO l_gms_transaction_source

Line 5618: IF (l_gms_install) THEN -- Introduced for bug fix 2908859

5614: ------Bug 2039196: Swapped the order of PA/GMS population
5615: -- dbms_output.put_line('Inserting into pa interface.............');
5616:
5617: -- if int_rec.award_id is not null then Commented for bug fix 2908859
5618: IF (l_gms_install) THEN -- Introduced for bug fix 2908859
5619: l_txn_source := l_gms_transaction_source;
5620:
5621: insert_into_pa_int(
5622: l_txn_interface_id,

Line 5662: IF (l_gms_install) THEN -- Introduced for bug fix 2908859

5658:
5659: -- insert into gms_interface table if there are awards..
5660:
5661: -- if int_rec.award_id is not null then Commented for bug fix 2908859
5662: IF (l_gms_install) THEN -- Introduced for bug fix 2908859
5663:
5664: GMS_REC.TXN_INTERFACE_ID := l_txn_interface_id;
5665: GMS_REC.BATCH_NAME := g_gms_batch_name; --- replaced with global for 3473294
5666: GMS_REC.TRANSACTION_SOURCE := l_gms_transaction_source;