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 GMS_AWARDS

Line 17: FROM gms_awards b,

13: BEGIN
14: BEGIN
15: SELECT a.project_id --Award_Project_Id
16: INTO Award_Id_Check
17: FROM gms_awards b,
18: pa_projects a
19: WHERE b.award_id = X_Award_Id
20: AND a.project_id = b.award_project_id;
21:

Line 137: PROCEDURE UPDATE_GMS_AWARDS(X_Award_Id IN NUMBER

133: END;
134:
135: END PROJ_NAME_NUM_UNIQUE;
136:
137: PROCEDURE UPDATE_GMS_AWARDS(X_Award_Id IN NUMBER
138: ,X_Agreement_Id IN NUMBER
139: ,X_Award_Project_Id IN NUMBER) IS
140: BEGIN
141: UPDATE GMS_AWARDS

Line 141: UPDATE GMS_AWARDS

137: PROCEDURE UPDATE_GMS_AWARDS(X_Award_Id IN NUMBER
138: ,X_Agreement_Id IN NUMBER
139: ,X_Award_Project_Id IN NUMBER) IS
140: BEGIN
141: UPDATE GMS_AWARDS
142: SET (AWARD_PROJECT_ID,
143: AGREEMENT_ID,
144: LAST_UPDATE_DATE,
145: LAST_UPDATED_BY,

Line 155: END UPDATE_GMS_AWARDS;

151: fnd_global.login_id
152: FROM dual)
153: WHERE AWARD_ID = X_Award_Id;
154:
155: END UPDATE_GMS_AWARDS;
156:
157: PROCEDURE UPDATE_PROJECT_ADD_INFO(X_Project_Id IN NUMBER,
158: X_IDC_Schedule_Id IN NUMBER,
159: X_IDC_Schedule_Fixed_Date IN DATE,

Line 841: GMS_AWARDS b,

837: Store_Award_Id,
838: Store_Agreement_Id
839: FROM
840: PA_PROJECTS a,
841: GMS_AWARDS b,
842: GMS_INSTALLMENTS c
843: WHERE
844: c.installment_id = X_Installment_Id and
845: b.Award_Id = c.Award_Id and

Line 1741: GMS_AWARDS_ALL

1737: St_award_id,
1738: St_revenue_distribution_rule,
1739: St_billing_distribution_rule
1740: FROM
1741: GMS_AWARDS_ALL
1742: WHERE
1743: AGREEMENT_ID = X_Agreement_Id
1744: and award_template_flag = 'DEFERRED';
1745:

Line 1827: FROM pa_events a,gms_awards_all b

1823: (St_revenue_distribution_rule = 'EVENT' and St_billing_distribution_rule = 'EVENT') THEN
1824: SELECT sum(bill_amount),
1825: sum(revenue_amount)
1826: INTO x_bill_amount, x_revenue_amount
1827: FROM pa_events a,gms_awards_all b
1828: WHERE a.project_id = b.award_project_id
1829: and b.award_id = St_award_id;
1830: if ((x_revenue_amount > x_total_funding_amount)/* or (x_bill_amount > x_total_funding_amount)*/) THEN
1831: X_Err_Code := 'E';

Line 2406: delete FROM GMS_AWARDS_CONTACTS

2402: --setting the Primary Flag = 'N'. Changed it to actually delete the primary BILLTO
2403: --SHIP TO contacts
2404: BEGIN
2405:
2406: delete FROM GMS_AWARDS_CONTACTS
2407: WHERE
2408: award_id = X_Award_Id
2409: and usage_code in ('BILL_TO','SHIP_TO')
2410: and primary_flag = 'Y';

Line 2412: /* UPDATE GMS_AWARDS_CONTACTS

2408: award_id = X_Award_Id
2409: and usage_code in ('BILL_TO','SHIP_TO')
2410: and primary_flag = 'Y';
2411:
2412: /* UPDATE GMS_AWARDS_CONTACTS
2413: set primary_flag = 'N'
2414: WHERE
2415: award_id = X_Award_Id
2416: and usage_code in ('BILL_TO','SHIP_TO')

Line 2442: GMS_AWARDS_CONTACTS

2438: SELECT 1
2439: INTO
2440: X_Cust_Bill_Cont_Exists
2441: FROM
2442: GMS_AWARDS_CONTACTS
2443: WHERE
2444: award_id = X_Award_id
2445: and customer_id = X_Customer_Id
2446: and contact_id = St_Bill_To_Contact_Id

Line 2455: INSERT INTO GMS_AWARDS_CONTACTS(AWARD_ID

2451: END;
2452:
2453:
2454: IF X_Cust_Bill_Cont_Exists = -99 THEN
2455: INSERT INTO GMS_AWARDS_CONTACTS(AWARD_ID
2456: ,CONTACT_ID
2457: ,CUSTOMER_ID
2458: ,USAGE_CODE
2459: ,PRIMARY_FLAG

Line 2477: UPDATE GMS_AWARDS_CONTACTS

2473: ,fnd_global.user_id
2474: ,fnd_global.login_id);
2475:
2476: Elsif X_Cust_Bill_Cont_Exists = 1 THEN
2477: UPDATE GMS_AWARDS_CONTACTS
2478: set
2479: PRIMARY_FLAG = 'Y'
2480: WHERE
2481: award_id = X_Award_Id

Line 2505: GMS_AWARDS_CONTACTS

2501: SELECT 1
2502: INTO
2503: X_Cust_Ship_Cont_Exists
2504: FROM
2505: GMS_AWARDS_CONTACTS
2506: WHERE
2507: award_id = X_Award_id
2508: and customer_id = X_Customer_Id
2509: and contact_id = St_Ship_To_Contact_Id

Line 2517: INSERT INTO GMS_AWARDS_CONTACTS(AWARD_ID

2513: NULL;
2514: END;
2515:
2516: IF X_Cust_Ship_Cont_Exists = -99 THEN
2517: INSERT INTO GMS_AWARDS_CONTACTS(AWARD_ID
2518: ,CONTACT_ID
2519: ,CUSTOMER_ID
2520: ,USAGE_CODE
2521: ,PRIMARY_FLAG

Line 2539: UPDATE GMS_AWARDS_CONTACTS

2535: ,fnd_global.user_id
2536: ,fnd_global.login_id);
2537: Elsif X_Cust_Bill_Cont_Exists = 1 THEN
2538:
2539: UPDATE GMS_AWARDS_CONTACTS
2540: set
2541: PRIMARY_FLAG = 'Y'
2542: WHERE
2543: award_id = X_Award_Id

Line 2848: G_Stage := '(200:Calling update_gms_awards)';

2844: X_Agreement_Id := Store_Agreement_Id;
2845: END IF;
2846:
2847:
2848: G_Stage := '(200:Calling update_gms_awards)';
2849: /* UPDATE GMS_AWARDS with the Agreement_Id and Award_Project_Id */
2850: UPDATE_GMS_AWARDS(X_Award_Id,
2851: Store_Agreement_Id,
2852: Store_Project_Id);

Line 2849: /* UPDATE GMS_AWARDS with the Agreement_Id and Award_Project_Id */

2845: END IF;
2846:
2847:
2848: G_Stage := '(200:Calling update_gms_awards)';
2849: /* UPDATE GMS_AWARDS with the Agreement_Id and Award_Project_Id */
2850: UPDATE_GMS_AWARDS(X_Award_Id,
2851: Store_Agreement_Id,
2852: Store_Project_Id);
2853:

Line 2850: UPDATE_GMS_AWARDS(X_Award_Id,

2846:
2847:
2848: G_Stage := '(200:Calling update_gms_awards)';
2849: /* UPDATE GMS_AWARDS with the Agreement_Id and Award_Project_Id */
2850: UPDATE_GMS_AWARDS(X_Award_Id,
2851: Store_Agreement_Id,
2852: Store_Project_Id);
2853:
2854: EXCEPTION

Line 3111: FROM gms_awards_all

3107: --Get the org_id from award_project_id being passed
3108: --Set the ORg context
3109: SELECT org_id
3110: INTO l_org_id
3111: FROM gms_awards_all
3112: WHERE award_id = X_award_id;
3113:
3114: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);
3115: --End of Shared Service enhancement

Line 3837: G_Stage := '(650:SELECT FROM GMS_AWARDS)';

3833: --Added these variables to track when an API fails
3834: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AWARD_PROJECT_BUDGET';
3835:
3836: BEGIN
3837: G_Stage := '(650:SELECT FROM GMS_AWARDS)';
3838: --Get Award Id (PM_PROJECT_REFERENCE) of the Award Project //
3839: BEGIN
3840: SELECT Award_Id
3841: INTO X_Award_Id

Line 3842: FROM gms_awards

3838: --Get Award Id (PM_PROJECT_REFERENCE) of the Award Project //
3839: BEGIN
3840: SELECT Award_Id
3841: INTO X_Award_Id
3842: FROM gms_awards
3843: WHERE award_project_id = X_Award_Project_Id;
3844:
3845: G_Stage := '(660:SELECT FROM RESOURCE_LIST)';
3846: --Get Resource List Id, Resource_List_Member_Id for Resource = 'Uncategorized' //