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_CMERGE dependencies on GMS_AWARDS

Line 10: | Account merge procedure for the table, GMS_AWARDS

Line 25: GMS_AWARDS.AWARD_ID%TYPE

21: INDEX BY BINARY_INTEGER;
22: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
23:
24: TYPE AWARD_ID_LIST_TYPE IS TABLE OF
25: GMS_AWARDS.AWARD_ID%TYPE
26: INDEX BY BINARY_INTEGER;
27: PRIMARY_KEY_ID_LIST AWARD_ID_LIST_TYPE;
28:
29: TYPE BILL_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF

Line 30: GMS_AWARDS.BILL_TO_ADDRESS_ID%TYPE

26: INDEX BY BINARY_INTEGER;
27: PRIMARY_KEY_ID_LIST AWARD_ID_LIST_TYPE;
28:
29: TYPE BILL_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
30: GMS_AWARDS.BILL_TO_ADDRESS_ID%TYPE
31: INDEX BY BINARY_INTEGER;
32: NUM_COL1_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
33: NUM_COL1_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
34:

Line 36: GMS_AWARDS.SHIP_TO_ADDRESS_ID%TYPE

32: NUM_COL1_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
33: NUM_COL1_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
34:
35: TYPE SHIP_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
36: GMS_AWARDS.SHIP_TO_ADDRESS_ID%TYPE
37: INDEX BY BINARY_INTEGER;
38: NUM_COL2_ORIG_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
39: NUM_COL2_NEW_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
40:

Line 42: GMS_AWARDS.LOC_BILL_TO_ADDRESS_ID%TYPE

38: NUM_COL2_ORIG_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
39: NUM_COL2_NEW_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
40:
41: TYPE LOC_BILL_TO_ADD_ID_LIST_TYPE IS TABLE OF
42: GMS_AWARDS.LOC_BILL_TO_ADDRESS_ID%TYPE
43: INDEX BY BINARY_INTEGER;
44: NUM_COL3_ORIG_LIST LOC_BILL_TO_ADD_ID_LIST_TYPE;
45: NUM_COL3_NEW_LIST LOC_BILL_TO_ADD_ID_LIST_TYPE;
46:

Line 48: GMS_AWARDS.LOC_SHIP_TO_ADDRESS_ID%TYPE

44: NUM_COL3_ORIG_LIST LOC_BILL_TO_ADD_ID_LIST_TYPE;
45: NUM_COL3_NEW_LIST LOC_BILL_TO_ADD_ID_LIST_TYPE;
46:
47: TYPE LOC_SHIP_TO_ADD_ID_LIST_TYPE IS TABLE OF
48: GMS_AWARDS.LOC_SHIP_TO_ADDRESS_ID%TYPE
49: INDEX BY BINARY_INTEGER;
50: NUM_COL4_ORIG_LIST LOC_SHIP_TO_ADD_ID_LIST_TYPE;
51: NUM_COL4_NEW_LIST LOC_SHIP_TO_ADD_ID_LIST_TYPE;
52:

Line 54: GMS_AWARDS.BILL_TO_CUSTOMER_ID%TYPE

50: NUM_COL4_ORIG_LIST LOC_SHIP_TO_ADD_ID_LIST_TYPE;
51: NUM_COL4_NEW_LIST LOC_SHIP_TO_ADD_ID_LIST_TYPE;
52:
53: TYPE BILL_TO_CUSTOMER_ID_LIST_TYPE IS TABLE OF
54: GMS_AWARDS.BILL_TO_CUSTOMER_ID%TYPE
55: INDEX BY BINARY_INTEGER;
56: NUM_COL5_ORIG_LIST BILL_TO_CUSTOMER_ID_LIST_TYPE;
57: NUM_COL5_NEW_LIST BILL_TO_CUSTOMER_ID_LIST_TYPE;
58:

Line 60: GMS_AWARDS.FUNDING_SOURCE_ID%TYPE

56: NUM_COL5_ORIG_LIST BILL_TO_CUSTOMER_ID_LIST_TYPE;
57: NUM_COL5_NEW_LIST BILL_TO_CUSTOMER_ID_LIST_TYPE;
58:
59: TYPE FUNDING_SOURCE_ID_LIST_TYPE IS TABLE OF
60: GMS_AWARDS.FUNDING_SOURCE_ID%TYPE
61: INDEX BY BINARY_INTEGER;
62: NUM_COL6_ORIG_LIST FUNDING_SOURCE_ID_LIST_TYPE;
63: NUM_COL6_NEW_LIST FUNDING_SOURCE_ID_LIST_TYPE;
64:

Line 75: FROM GMS_AWARDS yt, ra_customer_merges m

71: ,LOC_BILL_TO_ADDRESS_ID
72: ,LOC_SHIP_TO_ADDRESS_ID
73: ,BILL_TO_CUSTOMER_ID
74: ,FUNDING_SOURCE_ID
75: FROM GMS_AWARDS yt, ra_customer_merges m
76: WHERE (
77: yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
78: OR yt.SHIP_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
79: OR yt.LOC_BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID

Line 93: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','GMS_AWARDS',FALSE);

89: IF process_mode='LOCK' THEN
90: NULL;
91: ELSE
92: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
93: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','GMS_AWARDS',FALSE);
94: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
95: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
96:
97: open merged_records;

Line 155: 'GMS_AWARDS',

151: LAST_UPDATE_LOGIN,
152: LAST_UPDATE_DATE,
153: LAST_UPDATED_BY
154: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
155: 'GMS_AWARDS',
156: MERGE_HEADER_ID_LIST(I),
157: PRIMARY_KEY_ID_LIST(I),
158: NUM_COL1_ORIG_LIST(I),
159: NUM_COL1_NEW_LIST(I),

Line 180: UPDATE GMS_AWARDS yt SET

176: hz_utility_pub.LAST_UPDATED_BY
177: );
178:
179: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
180: UPDATE GMS_AWARDS yt SET
181: BILL_TO_ADDRESS_ID=NUM_COL1_NEW_LIST(I)
182: ,SHIP_TO_ADDRESS_ID=NUM_COL2_NEW_LIST(I)
183: ,LOC_BILL_TO_ADDRESS_ID=NUM_COL3_NEW_LIST(I)
184: ,LOC_SHIP_TO_ADDRESS_ID=NUM_COL4_NEW_LIST(I)

Line 213: | Account merge procedure for the table, GMS_AWARDS_CONTACTS

Line 228: GMS_AWARDS_CONTACTS.AWARD_ID%TYPE

224: INDEX BY BINARY_INTEGER;
225: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
226:
227: TYPE AWARD_ID_LIST_TYPE IS TABLE OF
228: GMS_AWARDS_CONTACTS.AWARD_ID%TYPE
229: INDEX BY BINARY_INTEGER;
230: PRIMARY_KEY1_LIST AWARD_ID_LIST_TYPE;
231:
232: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 233: GMS_AWARDS_CONTACTS.CUSTOMER_ID%TYPE

229: INDEX BY BINARY_INTEGER;
230: PRIMARY_KEY1_LIST AWARD_ID_LIST_TYPE;
231:
232: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
233: GMS_AWARDS_CONTACTS.CUSTOMER_ID%TYPE
234: INDEX BY BINARY_INTEGER;
235: PRIMARY_KEY2_LIST CUSTOMER_ID_LIST_TYPE;
236:
237: TYPE CONTACT_ID_LIST_TYPE IS TABLE OF

Line 238: GMS_AWARDS_CONTACTS.CONTACT_ID%TYPE

234: INDEX BY BINARY_INTEGER;
235: PRIMARY_KEY2_LIST CUSTOMER_ID_LIST_TYPE;
236:
237: TYPE CONTACT_ID_LIST_TYPE IS TABLE OF
238: GMS_AWARDS_CONTACTS.CONTACT_ID%TYPE
239: INDEX BY BINARY_INTEGER;
240: PRIMARY_KEY3_LIST CONTACT_ID_LIST_TYPE;
241:
242: TYPE USAGE_CODE_LIST_TYPE IS TABLE OF

Line 243: GMS_AWARDS_CONTACTS.USAGE_CODE%TYPE

239: INDEX BY BINARY_INTEGER;
240: PRIMARY_KEY3_LIST CONTACT_ID_LIST_TYPE;
241:
242: TYPE USAGE_CODE_LIST_TYPE IS TABLE OF
243: GMS_AWARDS_CONTACTS.USAGE_CODE%TYPE
244: INDEX BY BINARY_INTEGER;
245: PRIMARY_KEY4_LIST USAGE_CODE_LIST_TYPE;
246:
247: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;

Line 258: FROM GMS_AWARDS_CONTACTS yt, ra_customer_merges m

254: ,yt.CUSTOMER_ID
255: ,yt.CONTACT_ID
256: ,yt.USAGE_CODE
257: ,yt.CUSTOMER_ID
258: FROM GMS_AWARDS_CONTACTS yt, ra_customer_merges m
259: WHERE (
260: yt.CUSTOMER_ID = m.DUPLICATE_ID
261: ) AND m.process_flag = 'N'
262: AND m.request_id = req_id

Line 271: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','GMS_AWARDS_CONTACTS',FALSE);

267: IF process_mode='LOCK' THEN
268: NULL;
269: ELSE
270: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
271: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','GMS_AWARDS_CONTACTS',FALSE);
272: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
273: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
274:
275: open merged_records;

Line 315: 'GMS_AWARDS_CONTACTS',

311: LAST_UPDATE_LOGIN,
312: LAST_UPDATE_DATE,
313: LAST_UPDATED_BY
314: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
315: 'GMS_AWARDS_CONTACTS',
316: MERGE_HEADER_ID_LIST(I),
317: PRIMARY_KEY1_LIST(I),
318: PRIMARY_KEY2_LIST(I),
319: PRIMARY_KEY3_LIST(I),

Line 333: UPDATE GMS_AWARDS_CONTACTS yt SET

329: hz_utility_pub.LAST_UPDATED_BY
330: );
331:
332: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
333: UPDATE GMS_AWARDS_CONTACTS yt SET
334: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
335: , LAST_UPDATE_DATE=SYSDATE
336: , last_updated_by=arp_standard.profile.user_id
337: , last_update_login=arp_standard.profile.last_update_login