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.GMS_MULTI_FUNDING dependencies on PA_PROJECT_CONTACTS

Line 2365: PA_PROJECT_CONTACTS

2361: contact_id
2362: INTO
2363: St_Bill_To_Contact_Id
2364: FROM
2365: PA_PROJECT_CONTACTS
2366: WHERE project_id = X_Award_Project_Id
2367: and customer_id = X_Customer_Id
2368: and project_contact_type_code = 'BILLING';
2369: X_Err_Code := 'S';

Line 2388: PA_PROJECT_CONTACTS

2384: contact_id
2385: INTO
2386: St_Ship_To_Contact_Id
2387: FROM
2388: PA_PROJECT_CONTACTS
2389: WHERE project_id = X_Award_Project_Id
2390: and customer_id = X_Customer_Id
2391: and project_contact_type_code = 'SHIPPING';
2392: X_Err_Code := 'S';

Line 2427: /* Overriding the Ship_To_Contact_Id obtained FROM PA_PROJECT_CONTACTS with the one obtained FROM Award Template */

2423: /* Inserting Bill_To_Contact */
2424: BEGIN
2425:
2426: --------------------------------------------------------------------------------
2427: /* Overriding the Ship_To_Contact_Id obtained FROM PA_PROJECT_CONTACTS with the one obtained FROM Award Template */
2428:
2429: IF X_Awd_Templ_Bill_Cont_Id IS NOT NULL THEN
2430: ST_Bill_To_Contact_Id := X_Awd_Templ_Bill_Cont_Id;
2431: END IF;

Line 2491: /* Overriding the Ship_To_Contact_Id obtained FROM PA_PROJECT_CONTACTS with the one obtained FROM Award Template */

2487: END IF;
2488: X_Err_Code := 'S';
2489:
2490: --------------------------------------------------------------------------------
2491: /* Overriding the Ship_To_Contact_Id obtained FROM PA_PROJECT_CONTACTS with the one obtained FROM Award Template */
2492:
2493: IF X_Awd_Templ_Ship_Cont_Id IS NOT NULL THEN
2494: St_Ship_To_Contact_Id := X_Awd_Templ_Ship_Cont_Id;
2495: END IF;

Line 2752: G_Stage := '(160:Updating pa_project_contacts)';

2748: END IF;
2749: ---------------------------------------------------------------------------
2750:
2751: ---------------------------------------------------------------------------
2752: G_Stage := '(160:Updating pa_project_contacts)';
2753: /* Updating PA_PROJECT_CONTACTS with the contacts got FROM Award Template */
2754: IF X_Bill_To_Contact_Id_IN IS NOT NULL THEN
2755:
2756: UPDATE PA_PROJECT_CONTACTS

Line 2753: /* Updating PA_PROJECT_CONTACTS with the contacts got FROM Award Template */

2749: ---------------------------------------------------------------------------
2750:
2751: ---------------------------------------------------------------------------
2752: G_Stage := '(160:Updating pa_project_contacts)';
2753: /* Updating PA_PROJECT_CONTACTS with the contacts got FROM Award Template */
2754: IF X_Bill_To_Contact_Id_IN IS NOT NULL THEN
2755:
2756: UPDATE PA_PROJECT_CONTACTS
2757: set contact_id = X_Bill_To_Contact_Id_IN

Line 2756: UPDATE PA_PROJECT_CONTACTS

2752: G_Stage := '(160:Updating pa_project_contacts)';
2753: /* Updating PA_PROJECT_CONTACTS with the contacts got FROM Award Template */
2754: IF X_Bill_To_Contact_Id_IN IS NOT NULL THEN
2755:
2756: UPDATE PA_PROJECT_CONTACTS
2757: set contact_id = X_Bill_To_Contact_Id_IN
2758: ,LAST_UPDATE_DATE = SYSDATE
2759: ,LAST_UPDATED_BY = fnd_global.user_id
2760: ,LAST_UPDATE_LOGIN = fnd_global.login_id

Line 2767: G_Stage := '(170:Updating pa_project_contacts)';

2763: and project_contact_type_code = 'BILLING';
2764:
2765: END IF;
2766:
2767: G_Stage := '(170:Updating pa_project_contacts)';
2768: IF X_Ship_To_Contact_Id_IN IS NOT NULL THEN
2769:
2770: UPDATE PA_PROJECT_CONTACTS
2771: set contact_id = X_Ship_To_Contact_Id_IN

Line 2770: UPDATE PA_PROJECT_CONTACTS

2766:
2767: G_Stage := '(170:Updating pa_project_contacts)';
2768: IF X_Ship_To_Contact_Id_IN IS NOT NULL THEN
2769:
2770: UPDATE PA_PROJECT_CONTACTS
2771: set contact_id = X_Ship_To_Contact_Id_IN
2772: ,LAST_UPDATE_DATE = SYSDATE
2773: ,LAST_UPDATED_BY = fnd_global.user_id
2774: ,LAST_UPDATE_LOGIN = fnd_global.login_id

Line 3506: -- Create contacts in the pa_project_contacts by calling pa_customer_info.create_customer_contacts

3502: RETCODE := X_Err_Code;
3503: END IF;
3504: */
3505: -- Bug Fix 2994625
3506: -- Create contacts in the pa_project_contacts by calling pa_customer_info.create_customer_contacts
3507: -- instead of inserting directly INTO the tables
3508: G_Stage := '(380:select from pa_project_contacts)';
3509: BEGIN
3510: Select

Line 3508: G_Stage := '(380:select from pa_project_contacts)';

3504: */
3505: -- Bug Fix 2994625
3506: -- Create contacts in the pa_project_contacts by calling pa_customer_info.create_customer_contacts
3507: -- instead of inserting directly INTO the tables
3508: G_Stage := '(380:select from pa_project_contacts)';
3509: BEGIN
3510: Select
3511: contact_id
3512: INTO

Line 3515: PA_PROJECT_CONTACTS

3511: contact_id
3512: INTO
3513: Bill_To_Contact_exists
3514: FROM
3515: PA_PROJECT_CONTACTS
3516: WHERE project_id = X_Award_Project_Id
3517: and customer_id = X_Customer_Id
3518: and project_contact_type_code = 'BILLING';
3519: EXCEPTION

Line 3549: G_Stage := '(400:Select from pa_project_contacts)';

3545: ,x_msg_data => x_msg_data);
3546: END IF;
3547:
3548: BEGIN
3549: G_Stage := '(400:Select from pa_project_contacts)';
3550: Select contact_id
3551: INTO Ship_To_Contact_exists
3552: FROM PA_PROJECT_CONTACTS
3553: WHERE project_id = X_Award_Project_Id

Line 3552: FROM PA_PROJECT_CONTACTS

3548: BEGIN
3549: G_Stage := '(400:Select from pa_project_contacts)';
3550: Select contact_id
3551: INTO Ship_To_Contact_exists
3552: FROM PA_PROJECT_CONTACTS
3553: WHERE project_id = X_Award_Project_Id
3554: and customer_id = X_Customer_Id
3555: and project_contact_type_code = 'SHIPPING';
3556: EXCEPTION