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 (
60: yt.invoice_to_org_id = m.DUPLICATE_SITE_ID
61: OR yt.sold_to_org_id = m.DUPLICATE_ID
62: ) AND m.process_flag = 'N'

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

68: IF process_mode='LOCK' THEN
69: NULL;
70: ELSE
71: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
72: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OE_AGREEMENTS_B',FALSE);
73: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
74: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
75:
76: open merged_records;

Line 113: 'OE_AGREEMENTS_B',

109: LAST_UPDATE_LOGIN,
110: LAST_UPDATE_DATE,
111: LAST_UPDATED_BY
112: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
113: 'OE_AGREEMENTS_B',
114: MERGE_HEADER_ID_LIST(I),
115: PRIMARY_KEY_ID_LIST(I),
116: NUM_COL1_ORIG_LIST(I),
117: NUM_COL1_NEW_LIST(I),

Line 130: UPDATE OE_AGREEMENTS_B yt SET

126: hz_utility_pub.LAST_UPDATED_BY
127: );
128:
129: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
130: UPDATE OE_AGREEMENTS_B yt SET
131: invoice_to_org_id=NUM_COL1_NEW_LIST(I)
132: ,sold_to_org_id=NUM_COL2_NEW_LIST(I)
133: , LAST_UPDATE_DATE=SYSDATE
134: , last_updated_by=arp_standard.profile.user_id