APPS.GMS_MULTI_FUNDING dependencies on GMS_AWARDS_CONTACTS

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