APPS.QP_CUST_MERGE dependencies on OE_AGREEMENTS_B

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

6: |
7: | PROCEDURE
8: | Agreement_Merge
9: | DESCRIPTION :
10: | Account merge procedure for the table, OE_AGREEMENTS_B
11: |
12: | NOTES:
13: | ******* Please delete these lines after modifications *******
14: | This account merge procedure was generated using a perl script.

Line 36: OE_AGREEMENTS_B.agreement_id%TYPE

32: INDEX BY BINARY_INTEGER;
33: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
34:
35: TYPE agreement_id_LIST_TYPE IS TABLE OF
36: OE_AGREEMENTS_B.agreement_id%TYPE
37: INDEX BY BINARY_INTEGER;
38: PRIMARY_KEY_ID_LIST agreement_id_LIST_TYPE;
39:
40: TYPE invoice_to_org_id_LIST_TYPE IS TABLE OF

Line 41: OE_AGREEMENTS_B.invoice_to_org_id%TYPE

37: INDEX BY BINARY_INTEGER;
38: PRIMARY_KEY_ID_LIST agreement_id_LIST_TYPE;
39:
40: TYPE invoice_to_org_id_LIST_TYPE IS TABLE OF
41: OE_AGREEMENTS_B.invoice_to_org_id%TYPE
42: INDEX BY BINARY_INTEGER;
43: NUM_COL1_ORIG_LIST invoice_to_org_id_LIST_TYPE;
44: NUM_COL1_NEW_LIST invoice_to_org_id_LIST_TYPE;
45:

Line 47: OE_AGREEMENTS_B.sold_to_org_id%TYPE

43: NUM_COL1_ORIG_LIST invoice_to_org_id_LIST_TYPE;
44: NUM_COL1_NEW_LIST invoice_to_org_id_LIST_TYPE;
45:
46: TYPE sold_to_org_id_LIST_TYPE IS TABLE OF
47: OE_AGREEMENTS_B.sold_to_org_id%TYPE
48: INDEX BY BINARY_INTEGER;
49: NUM_COL2_ORIG_LIST sold_to_org_id_LIST_TYPE;
50: NUM_COL2_NEW_LIST sold_to_org_id_LIST_TYPE;
51:

Line 58: FROM OE_AGREEMENTS_B yt, ra_customer_merges m

54: SELECT distinct CUSTOMER_MERGE_HEADER_ID
55: ,agreement_id
56: ,invoice_to_org_id
57: ,sold_to_org_id
58: FROM OE_AGREEMENTS_B yt, ra_customer_merges m
59: WHERE yt.invoice_to_org_id = m.DUPLICATE_SITE_ID
60: AND m.process_flag = 'N'
61: AND m.request_id = req_id
62: AND m.set_number = set_num

Line 68: FROM OE_AGREEMENTS_B yt, ra_customer_merges m

64: SELECT distinct CUSTOMER_MERGE_HEADER_ID
65: ,agreement_id
66: ,invoice_to_org_id
67: ,sold_to_org_id
68: FROM OE_AGREEMENTS_B yt, ra_customer_merges m
69: WHERE yt.sold_to_org_id = m.DUPLICATE_ID
70: AND m.process_flag = 'N'
71: AND m.request_id = req_id
72: AND m.set_number = set_num;

Line 80: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OE_AGREEMENTS_B',FALSE);

76: IF process_mode='LOCK' THEN
77: NULL;
78: ELSE
79: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
80: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OE_AGREEMENTS_B',FALSE);
81: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
82: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
83:
84: open merged_records;

Line 121: 'OE_AGREEMENTS_B',

117: LAST_UPDATE_LOGIN,
118: LAST_UPDATE_DATE,
119: LAST_UPDATED_BY
120: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
121: 'OE_AGREEMENTS_B',
122: MERGE_HEADER_ID_LIST(I),
123: PRIMARY_KEY_ID_LIST(I),
124: NUM_COL1_ORIG_LIST(I),
125: NUM_COL1_NEW_LIST(I),

Line 138: UPDATE OE_AGREEMENTS_B yt SET

134: hz_utility_pub.LAST_UPDATED_BY
135: );
136:
137: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
138: UPDATE OE_AGREEMENTS_B yt SET
139: invoice_to_org_id=NUM_COL1_NEW_LIST(I)
140: ,sold_to_org_id=NUM_COL2_NEW_LIST(I)
141: , LAST_UPDATE_DATE=SYSDATE
142: , last_updated_by=arp_standard.profile.user_id