DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on GMS_INSTALL

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

5127: l_txn_source varchar2(30);
5128: l_gms_transaction_source VARCHAR2(30);
5129: l_org_id NUMBER(15);
5130: l_txn_interface_id NUMBER;
5131: l_gms_install BOOLEAN DEFAULT gms_install.enabled; -- Introduced for bug fix 2908859
5132:
5133: -- Introduced the following for R12 performance fixes (4507892)
5134: TYPE t_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5135: TYPE t_number_15 IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;

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

5251: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering TR_TO_GMS_INT');
5252:
5253: -- gms_tie_tab.delete; Commented for bug fix 4625734
5254:
5255: -- if (gms_install.site_enabled) then -- Commented for bug fix 2908859
5256: if (l_gms_install) then -- Introduced for bug fix 2908859
5257: /***** Converted the following code as part of bug fix 4625734
5258: BEGIN
5259: SELECT transaction_source

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

5252:
5253: -- gms_tie_tab.delete; Commented for bug fix 4625734
5254:
5255: -- if (gms_install.site_enabled) then -- Commented for bug fix 2908859
5256: if (l_gms_install) then -- Introduced for bug fix 2908859
5257: /***** Converted the following code as part of bug fix 4625734
5258: BEGIN
5259: SELECT transaction_source
5260: INTO l_gms_transaction_source

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

5709: ------Bug 2039196: Swapped the order of PA/GMS population
5710: -- dbms_output.put_line('Inserting into pa interface.............');
5711:
5712: -- if int_rec.award_id is not null then Commented for bug fix 2908859
5713: IF (l_gms_install) THEN -- Introduced for bug fix 2908859
5714: l_txn_source := l_gms_transaction_source;
5715:
5716: insert_into_pa_int(
5717: l_txn_interface_id,

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

5753:
5754: -- insert into gms_interface table if there are awards..
5755:
5756: -- if int_rec.award_id is not null then Commented for bug fix 2908859
5757: IF (l_gms_install) THEN -- Introduced for bug fix 2908859
5758:
5759: GMS_REC.TXN_INTERFACE_ID := l_txn_interface_id;
5760: GMS_REC.BATCH_NAME := g_gms_batch_name; --- replaced with global for 3473294
5761: GMS_REC.TRANSACTION_SOURCE := l_gms_transaction_source;