APPS.FII_AR_ACCOUNT_MERGE_PKG dependencies on FII_AR_PMT_SCHEDULES_F

Line 27: TYPE PAYMENT_SCHEDULE_ID_LIST_TYPE IS TABLE OF FII_AR_PMT_SCHEDULES_F.PAYMENT_SCHEDULE_ID%TYPE

23: RA_CUSTOMER_MERGE_HEADERS.CUSTOMER_MERGE_HEADER_ID%TYPE
24: INDEX BY BINARY_INTEGER;
25: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
26:
27: TYPE PAYMENT_SCHEDULE_ID_LIST_TYPE IS TABLE OF FII_AR_PMT_SCHEDULES_F.PAYMENT_SCHEDULE_ID%TYPE
28: INDEX BY BINARY_INTEGER;
29: PRIMARY_KEY_ID_LIST PAYMENT_SCHEDULE_ID_LIST_TYPE;
30:
31: TYPE BILL_TO_CUSTOMER_ID_LIST_TYPE IS TABLE OF FII_AR_PMT_SCHEDULES_F.BILL_TO_CUSTOMER_ID%TYPE

Line 31: TYPE BILL_TO_CUSTOMER_ID_LIST_TYPE IS TABLE OF FII_AR_PMT_SCHEDULES_F.BILL_TO_CUSTOMER_ID%TYPE

27: TYPE PAYMENT_SCHEDULE_ID_LIST_TYPE IS TABLE OF FII_AR_PMT_SCHEDULES_F.PAYMENT_SCHEDULE_ID%TYPE
28: INDEX BY BINARY_INTEGER;
29: PRIMARY_KEY_ID_LIST PAYMENT_SCHEDULE_ID_LIST_TYPE;
30:
31: TYPE BILL_TO_CUSTOMER_ID_LIST_TYPE IS TABLE OF FII_AR_PMT_SCHEDULES_F.BILL_TO_CUSTOMER_ID%TYPE
32: INDEX BY BINARY_INTEGER;
33: NUM_COL1_ORIG_LIST BILL_TO_CUSTOMER_ID_LIST_TYPE;
34: NUM_COL1_NEW_LIST BILL_TO_CUSTOMER_ID_LIST_TYPE;
35:

Line 36: TYPE BILL_TO_SITE_USE_ID_LIST_TYPE IS TABLE OF FII_AR_PMT_SCHEDULES_F.BILL_TO_SITE_USE_ID%TYPE

32: INDEX BY BINARY_INTEGER;
33: NUM_COL1_ORIG_LIST BILL_TO_CUSTOMER_ID_LIST_TYPE;
34: NUM_COL1_NEW_LIST BILL_TO_CUSTOMER_ID_LIST_TYPE;
35:
36: TYPE BILL_TO_SITE_USE_ID_LIST_TYPE IS TABLE OF FII_AR_PMT_SCHEDULES_F.BILL_TO_SITE_USE_ID%TYPE
37: INDEX BY BINARY_INTEGER;
38: NUM_COL2_ORIG_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;
39: NUM_COL2_NEW_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;
40:

Line 49: FROM FII_AR_PMT_SCHEDULES_F yt,

45: yt.BILL_TO_CUSTOMER_ID,
46: yt.BILL_TO_SITE_USE_ID,
47: m.CUSTOMER_ID,
48: m.customer_site_id
49: FROM FII_AR_PMT_SCHEDULES_F yt,
50: ra_customer_merges m
51: WHERE (yt.BILL_TO_CUSTOMER_ID = m.duplicate_id
52: AND yt.BILL_TO_SITE_USE_ID = m.duplicate_site_id)
53: AND m.process_flag = 'N'

Line 65: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FII_AR_PMT_SCHEDULES_F',FALSE);

61: IF process_mode='LOCK' THEN
62: NULL;
63: ELSE
64: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
65: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FII_AR_PMT_SCHEDULES_F',FALSE);
66: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
67: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
68:
69: open merged_records;

Line 106: 'FII_AR_PMT_SCHEDULES_F',

102: LAST_UPDATE_LOGIN,
103: LAST_UPDATE_DATE,
104: LAST_UPDATED_BY
105: ) VALUES (HZ_CUSTOMER_MERGE_LOG_s.nextval,
106: 'FII_AR_PMT_SCHEDULES_F',
107: MERGE_HEADER_ID_LIST(I),
108: PRIMARY_KEY_ID_LIST(I),
109: NUM_COL1_ORIG_LIST(I), NUM_COL1_NEW_LIST(I),
110: NUM_COL2_ORIG_LIST(I), NUM_COL2_NEW_LIST(I),

Line 124: UPDATE FII_AR_PMT_SCHEDULES_F yt

120: END IF;
121:
122: --FII_AR_PAYMENT_SCHEDULES_F
123: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
124: UPDATE FII_AR_PMT_SCHEDULES_F yt
125: SET BILL_TO_CUSTOMER_ID=NUM_COL1_NEW_LIST(I),
126: BILL_TO_SITE_USE_ID=NUM_COL2_NEW_LIST(I)
127: WHERE PAYMENT_SCHEDULE_ID=PRIMARY_KEY_ID_LIST(I);
128: