APPS.PSP_SUM_TRANS dependencies on GMS_INSTALL

Line 3553: l_gms_install BOOLEAN DEFAULT gms_install.enabled;

3549: l_gms_transaction_source VARCHAR2(20);
3550: l_txn_source VARCHAR2(30);
3551: -- l_org_id NUMBER(15); -- Commented for R12 MOAC uptake
3552: l_txn_interface_id NUMBER(15);
3553: l_gms_install BOOLEAN DEFAULT gms_install.enabled;
3554:
3555: -- R12 MOAC Uptake
3556: TYPE ORG_ID_TYPE IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
3557: ORG_ID_TAB ORG_ID_TYPE;

Line 3597: if (l_gms_install) then -- Changed site_enabled check to l_gms_install check for bug fix 2908859

3593: fnd_msg_pub.add;
3594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3595: END;
3596:
3597: if (l_gms_install) then -- Changed site_enabled check to l_gms_install check for bug fix 2908859
3598: BEGIN
3599: SELECT transaction_source
3600: INTO l_gms_transaction_source
3601: FROM pa_transaction_sources

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

3804:
3805: -- dbms_output.put_line('Inserting into pa interface.............');
3806:
3807: -- if gms_interface_rec.award_id is not null then Commented for bug fix 2908859
3808: if (l_gms_install) then -- Introduced for bug fix 2908859
3809: l_txn_source := l_gms_transaction_source;
3810: else
3811: l_txn_source := l_transaction_source;
3812: end if;

Line 3918: if (l_gms_install) then --- fix for 5090047

3914: and org_id = org_id_tab(i)
3915: and project_id is not null
3916: and rownum = 1;
3917: end loop;
3918: if (l_gms_install) then --- fix for 5090047
3919: l_txn_source := l_gms_transaction_source;
3920: else
3921: l_txn_source := l_transaction_source;
3922: end if;