APPS.OZF_ACCOUNT_MERGE_PKG dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 1143: | Account merge procedure for the table, ozf_funds_utilized_all_b

1139: |
1140: | PROCEDURE
1141: | merge_fund_utilization
1142: | DESCRIPTION :
1143: | Account merge procedure for the table, ozf_funds_utilized_all_b
1144: |
1145: | NOTES:
1146: |
1147: |--------------------------------------------------------------*/

Line 1160: ozf_funds_utilized_all_b.utilization_id%TYPE

1156: INDEX BY BINARY_INTEGER;
1157: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1158:
1159: TYPE utilization_id_LIST_TYPE IS TABLE OF
1160: ozf_funds_utilized_all_b.utilization_id%TYPE
1161: INDEX BY BINARY_INTEGER;
1162: PRIMARY_KEY_ID1_LIST utilization_id_LIST_TYPE;
1163:
1164: TYPE cust_account_id_LIST_TYPE IS TABLE OF

Line 1165: ozf_funds_utilized_all_b.cust_account_id%TYPE

1161: INDEX BY BINARY_INTEGER;
1162: PRIMARY_KEY_ID1_LIST utilization_id_LIST_TYPE;
1163:
1164: TYPE cust_account_id_LIST_TYPE IS TABLE OF
1165: ozf_funds_utilized_all_b.cust_account_id%TYPE
1166: INDEX BY BINARY_INTEGER;
1167: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
1168: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
1169:

Line 1171: ozf_funds_utilized_all_b.billto_cust_account_id%TYPE

1167: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
1168: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
1169:
1170: TYPE bc_account_id_LIST_TYPE IS TABLE OF
1171: ozf_funds_utilized_all_b.billto_cust_account_id%TYPE
1172: INDEX BY BINARY_INTEGER;
1173: NUM_COL2_ORIG_LIST bc_account_id_LIST_TYPE;
1174: NUM_COL2_NEW_LIST bc_account_id_LIST_TYPE;
1175:

Line 1182: FROM ozf_funds_utilized_all_b yt, ra_customer_merges m

1178: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1179: ,utilization_id
1180: ,cust_account_id
1181: ,billto_cust_account_id
1182: FROM ozf_funds_utilized_all_b yt, ra_customer_merges m
1183: WHERE (
1184: yt.cust_account_id = m.DUPLICATE_ID
1185: OR yt.billto_cust_account_id = m.DUPLICATE_ID
1186: ) AND m.process_flag = 'N'

Line 1196: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_funds_utilized_all_b',FALSE);

1192: IF process_mode='LOCK' THEN
1193: NULL;
1194: ELSE
1195: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1196: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_funds_utilized_all_b',FALSE);
1197: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1198: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1199:
1200: open merged_records;

Line 1237: 'ozf_funds_utilized_all_b',

1233: LAST_UPDATE_LOGIN,
1234: LAST_UPDATE_DATE,
1235: LAST_UPDATED_BY
1236: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1237: 'ozf_funds_utilized_all_b',
1238: MERGE_HEADER_ID_LIST(I),
1239: PRIMARY_KEY_ID1_LIST(I),
1240: NUM_COL1_ORIG_LIST(I),
1241: NUM_COL1_NEW_LIST(I),

Line 1254: UPDATE ozf_funds_utilized_all_b yt SET

1250: hz_utility_pub.LAST_UPDATED_BY
1251: );
1252:
1253: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1254: UPDATE ozf_funds_utilized_all_b yt SET
1255: cust_account_id=NUM_COL1_NEW_LIST(I)
1256: ,billto_cust_account_id=NUM_COL2_NEW_LIST(I)
1257: , LAST_UPDATE_DATE=SYSDATE
1258: , last_updated_by=arp_standard.profile.user_id