APPS.IEX_MERGE_PVT dependencies on IEX_PROMISE_DETAILS

Line 1020: IEX_PROMISE_DETAILS.PROMISE_DETAIL_ID%TYPE

1016: INDEX BY BINARY_INTEGER;
1017: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1018:
1019: TYPE PROMISE_DETAIL_ID_LIST_TYPE IS TABLE OF
1020: IEX_PROMISE_DETAILS.PROMISE_DETAIL_ID%TYPE
1021: INDEX BY BINARY_INTEGER;
1022: PRIMARY_KEY_ID_LIST PROMISE_DETAIL_ID_LIST_TYPE;
1023:
1024: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 1025: IEX_PROMISE_DETAILS.CUST_ACCOUNT_ID%TYPE

1021: INDEX BY BINARY_INTEGER;
1022: PRIMARY_KEY_ID_LIST PROMISE_DETAIL_ID_LIST_TYPE;
1023:
1024: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
1025: IEX_PROMISE_DETAILS.CUST_ACCOUNT_ID%TYPE
1026: INDEX BY BINARY_INTEGER;
1027: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1028: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1029:

Line 1035: FROM IEX_PROMISE_DETAILS yt, ra_customer_merges m

1031: CURSOR merged_records IS
1032: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1033: ,PROMISE_DETAIL_ID
1034: ,CUST_ACCOUNT_ID
1035: FROM IEX_PROMISE_DETAILS yt, ra_customer_merges m
1036: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
1037: m.process_flag = 'N' AND
1038: m.request_id = req_id AND
1039: m.set_number = set_num;

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

1043: IF process_mode='LOCK' THEN
1044: NULL;
1045: ELSE
1046: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1047: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_PROMISE_DETAILS',FALSE);
1048: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1049: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1050:
1051: open merged_records;

Line 1089: 'IEX_PROMISE_DETAILS',

1085: LAST_UPDATE_DATE,
1086: LAST_UPDATED_BY)
1087: VALUES
1088: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
1089: 'IEX_PROMISE_DETAILS',
1090: MERGE_HEADER_ID_LIST(I),
1091: PRIMARY_KEY_ID_LIST(I),
1092: NUM_COL1_ORIG_LIST(I),
1093: NUM_COL1_NEW_LIST(I),

Line 1104: UPDATE IEX_PROMISE_DETAILS yt SET

1100: hz_utility_pub.LAST_UPDATED_BY);
1101:
1102: END IF;
1103: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1104: UPDATE IEX_PROMISE_DETAILS yt SET
1105: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
1106: , LAST_UPDATE_DATE = SYSDATE
1107: , last_updated_by = arp_standard.profile.user_id
1108: , last_update_login = arp_standard.profile.last_update_login

Line 1558: UPDATE IEX_PROMISE_DETAILS

1554: program_update_date = sysdate
1555: WHERE party_cust_id = p_from_fk_id;
1556:
1557: -- begin raverma 10232001 -- add this to update promise table
1558: UPDATE IEX_PROMISE_DETAILS
1559: SET Promise_Made_By = p_To_FK_ID,
1560: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1561: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1562: last_update_login = HZ_UTILITY_V2PUB.last_update_login,