DBA Data[Home] [Help]

APPS.PSP_SUM_TRANS dependencies on GMS_INSTALL

Line 3744: l_gms_install BOOLEAN DEFAULT gms_install.enabled;

3740: l_gms_transaction_source VARCHAR2(20);
3741: l_txn_source VARCHAR2(30);
3742: -- l_org_id NUMBER(15); -- Commented for R12 MOAC uptake
3743: l_txn_interface_id NUMBER(15);
3744: l_gms_install BOOLEAN DEFAULT gms_install.enabled;
3745:
3746: -- R12 MOAC Uptake
3747: TYPE ORG_ID_TYPE IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
3748: ORG_ID_TAB ORG_ID_TYPE;

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

3786: fnd_msg_pub.add;
3787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3788: END;
3789:
3790: if (l_gms_install) then -- Changed site_enabled check to l_gms_install check for bug fix 2908859
3791: BEGIN
3792: SELECT transaction_source
3793: INTO l_gms_transaction_source
3794: FROM pa_transaction_sources

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

4004:
4005: -- dbms_output.put_line('Inserting into pa interface.............');
4006:
4007: -- if gms_interface_rec.award_id is not null then Commented for bug fix 2908859
4008: if (l_gms_install) then -- Introduced for bug fix 2908859
4009: l_txn_source := l_gms_transaction_source;
4010: else
4011: l_txn_source := l_transaction_source;
4012: end if;

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

4150: and org_id = org_id_tab(i)
4151: and project_id is not null
4152: and rownum = 1;
4153: end loop;
4154: if (l_gms_install) then --- fix for 5090047
4155: l_txn_source := l_gms_transaction_source;
4156: else
4157: l_txn_source := l_transaction_source;
4158: end if;