APPS.IEX_MERGE_PVT dependencies on IEX_PROMISE_DETAILS

Line 1132: IEX_PROMISE_DETAILS.PROMISE_DETAIL_ID%TYPE

1128: INDEX BY BINARY_INTEGER;
1129: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1130:
1131: TYPE PROMISE_DETAIL_ID_LIST_TYPE IS TABLE OF
1132: IEX_PROMISE_DETAILS.PROMISE_DETAIL_ID%TYPE
1133: INDEX BY BINARY_INTEGER;
1134: PRIMARY_KEY_ID_LIST PROMISE_DETAIL_ID_LIST_TYPE;
1135:
1136: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 1137: IEX_PROMISE_DETAILS.CUST_ACCOUNT_ID%TYPE

1133: INDEX BY BINARY_INTEGER;
1134: PRIMARY_KEY_ID_LIST PROMISE_DETAIL_ID_LIST_TYPE;
1135:
1136: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
1137: IEX_PROMISE_DETAILS.CUST_ACCOUNT_ID%TYPE
1138: INDEX BY BINARY_INTEGER;
1139: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1140: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1141:

Line 1148: FROM IEX_PROMISE_DETAILS yt, ra_customer_merges m,ar_payment_schedules_all ps,iex_delinquencies_all del

1144: CURSOR merged_records IS
1145: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1146: ,yt.PROMISE_DETAIL_ID
1147: ,yt.CUST_ACCOUNT_ID
1148: FROM IEX_PROMISE_DETAILS yt, ra_customer_merges m,ar_payment_schedules_all ps,iex_delinquencies_all del
1149: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
1150: m.process_flag = 'N' AND
1151: m.request_id = req_id AND
1152: m.set_number = set_num AND

Line 1164: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_PROMISE_DETAILS',FALSE);

1160: IF process_mode='LOCK' THEN
1161: NULL;
1162: ELSE
1163: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1164: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_PROMISE_DETAILS',FALSE);
1165: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1166: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1167:
1168: open merged_records;

Line 1206: 'IEX_PROMISE_DETAILS',

1202: LAST_UPDATE_DATE,
1203: LAST_UPDATED_BY)
1204: VALUES
1205: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
1206: 'IEX_PROMISE_DETAILS',
1207: MERGE_HEADER_ID_LIST(I),
1208: PRIMARY_KEY_ID_LIST(I),
1209: NUM_COL1_ORIG_LIST(I),
1210: NUM_COL1_NEW_LIST(I),

Line 1221: UPDATE IEX_PROMISE_DETAILS yt SET

1217: hz_utility_pub.LAST_UPDATED_BY);
1218:
1219: END IF;
1220: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1221: UPDATE IEX_PROMISE_DETAILS yt SET
1222: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
1223: , LAST_UPDATE_DATE = SYSDATE
1224: , last_updated_by = arp_standard.profile.user_id
1225: , last_update_login = arp_standard.profile.last_update_login

Line 1680: UPDATE IEX_PROMISE_DETAILS

1676: program_update_date = sysdate
1677: WHERE party_cust_id = p_from_fk_id;
1678:
1679: -- begin raverma 10232001 -- add this to update promise table
1680: UPDATE IEX_PROMISE_DETAILS
1681: SET Promise_Made_By = p_To_FK_ID,
1682: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1683: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1684: last_update_login = HZ_UTILITY_V2PUB.last_update_login,