DBA Data[Home] [Help]

APPS.FII_AR_ACCOUNT_MERGE_PKG dependencies on HZ_UTILITY_PUB

Line 113: hz_utility_pub.CREATED_BY,

109: NUM_COL1_ORIG_LIST(I), NUM_COL1_NEW_LIST(I),
110: NUM_COL2_ORIG_LIST(I), NUM_COL2_NEW_LIST(I),
111: 'U',
112: req_id,
113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY

Line 114: hz_utility_pub.CREATION_DATE,

110: NUM_COL2_ORIG_LIST(I), NUM_COL2_NEW_LIST(I),
111: 'U',
112: req_id,
113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY
118: );

Line 115: hz_utility_pub.LAST_UPDATE_LOGIN,

111: 'U',
112: req_id,
113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY
118: );
119:

Line 116: hz_utility_pub.LAST_UPDATE_DATE,

112: req_id,
113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY
118: );
119:
120: END IF;

Line 117: hz_utility_pub.LAST_UPDATED_BY

113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY
118: );
119:
120: END IF;
121:

Line 342: hz_utility_pub.CREATED_BY,

338: NUM_COL1_ORIG_LIST(I), NUM_COL1_NEW_LIST(I),
339: NUM_COL2_ORIG_LIST(I), NUM_COL2_NEW_LIST(I),
340: 'U',
341: req_id,
342: hz_utility_pub.CREATED_BY,
343: hz_utility_pub.CREATION_DATE,
344: hz_utility_pub.LAST_UPDATE_LOGIN,
345: hz_utility_pub.LAST_UPDATE_DATE,
346: hz_utility_pub.LAST_UPDATED_BY

Line 343: hz_utility_pub.CREATION_DATE,

339: NUM_COL2_ORIG_LIST(I), NUM_COL2_NEW_LIST(I),
340: 'U',
341: req_id,
342: hz_utility_pub.CREATED_BY,
343: hz_utility_pub.CREATION_DATE,
344: hz_utility_pub.LAST_UPDATE_LOGIN,
345: hz_utility_pub.LAST_UPDATE_DATE,
346: hz_utility_pub.LAST_UPDATED_BY
347: );

Line 344: hz_utility_pub.LAST_UPDATE_LOGIN,

340: 'U',
341: req_id,
342: hz_utility_pub.CREATED_BY,
343: hz_utility_pub.CREATION_DATE,
344: hz_utility_pub.LAST_UPDATE_LOGIN,
345: hz_utility_pub.LAST_UPDATE_DATE,
346: hz_utility_pub.LAST_UPDATED_BY
347: );
348:

Line 345: hz_utility_pub.LAST_UPDATE_DATE,

341: req_id,
342: hz_utility_pub.CREATED_BY,
343: hz_utility_pub.CREATION_DATE,
344: hz_utility_pub.LAST_UPDATE_LOGIN,
345: hz_utility_pub.LAST_UPDATE_DATE,
346: hz_utility_pub.LAST_UPDATED_BY
347: );
348:
349: END IF;

Line 346: hz_utility_pub.LAST_UPDATED_BY

342: hz_utility_pub.CREATED_BY,
343: hz_utility_pub.CREATION_DATE,
344: hz_utility_pub.LAST_UPDATE_LOGIN,
345: hz_utility_pub.LAST_UPDATE_DATE,
346: hz_utility_pub.LAST_UPDATED_BY
347: );
348:
349: END IF;
350:

Line 419: hz_utility_pub.CREATED_BY,

415: PARTY_ID_LIST(I),
416: COLLECTOR_ID_LIST(I),
417: 'D',
418: req_id,
419: hz_utility_pub.CREATED_BY,
420: hz_utility_pub.CREATION_DATE,
421: hz_utility_pub.LAST_UPDATE_LOGIN,
422: hz_utility_pub.LAST_UPDATE_DATE,
423: hz_utility_pub.LAST_UPDATED_BY

Line 420: hz_utility_pub.CREATION_DATE,

416: COLLECTOR_ID_LIST(I),
417: 'D',
418: req_id,
419: hz_utility_pub.CREATED_BY,
420: hz_utility_pub.CREATION_DATE,
421: hz_utility_pub.LAST_UPDATE_LOGIN,
422: hz_utility_pub.LAST_UPDATE_DATE,
423: hz_utility_pub.LAST_UPDATED_BY
424: );

Line 421: hz_utility_pub.LAST_UPDATE_LOGIN,

417: 'D',
418: req_id,
419: hz_utility_pub.CREATED_BY,
420: hz_utility_pub.CREATION_DATE,
421: hz_utility_pub.LAST_UPDATE_LOGIN,
422: hz_utility_pub.LAST_UPDATE_DATE,
423: hz_utility_pub.LAST_UPDATED_BY
424: );
425:

Line 422: hz_utility_pub.LAST_UPDATE_DATE,

418: req_id,
419: hz_utility_pub.CREATED_BY,
420: hz_utility_pub.CREATION_DATE,
421: hz_utility_pub.LAST_UPDATE_LOGIN,
422: hz_utility_pub.LAST_UPDATE_DATE,
423: hz_utility_pub.LAST_UPDATED_BY
424: );
425:
426: END IF;

Line 423: hz_utility_pub.LAST_UPDATED_BY

419: hz_utility_pub.CREATED_BY,
420: hz_utility_pub.CREATION_DATE,
421: hz_utility_pub.LAST_UPDATE_LOGIN,
422: hz_utility_pub.LAST_UPDATE_DATE,
423: hz_utility_pub.LAST_UPDATED_BY
424: );
425:
426: END IF;
427:

Line 554: HZ_Utility_Pub.CREATED_BY,

550: Account_Owner_Party_ID_List(i),
551: Parent_Party_ID_List(i),
552: 'D',
553: Req_ID,
554: HZ_Utility_Pub.CREATED_BY,
555: HZ_Utility_Pub.CREATION_DATE,
556: HZ_Utility_Pub.LAST_UPDATE_LOGIN,
557: HZ_Utility_Pub.LAST_UPDATE_DATE,
558: HZ_Utility_Pub.LAST_UPDATED_BY);

Line 555: HZ_Utility_Pub.CREATION_DATE,

551: Parent_Party_ID_List(i),
552: 'D',
553: Req_ID,
554: HZ_Utility_Pub.CREATED_BY,
555: HZ_Utility_Pub.CREATION_DATE,
556: HZ_Utility_Pub.LAST_UPDATE_LOGIN,
557: HZ_Utility_Pub.LAST_UPDATE_DATE,
558: HZ_Utility_Pub.LAST_UPDATED_BY);
559: END IF;

Line 556: HZ_Utility_Pub.LAST_UPDATE_LOGIN,

552: 'D',
553: Req_ID,
554: HZ_Utility_Pub.CREATED_BY,
555: HZ_Utility_Pub.CREATION_DATE,
556: HZ_Utility_Pub.LAST_UPDATE_LOGIN,
557: HZ_Utility_Pub.LAST_UPDATE_DATE,
558: HZ_Utility_Pub.LAST_UPDATED_BY);
559: END IF;
560:

Line 557: HZ_Utility_Pub.LAST_UPDATE_DATE,

553: Req_ID,
554: HZ_Utility_Pub.CREATED_BY,
555: HZ_Utility_Pub.CREATION_DATE,
556: HZ_Utility_Pub.LAST_UPDATE_LOGIN,
557: HZ_Utility_Pub.LAST_UPDATE_DATE,
558: HZ_Utility_Pub.LAST_UPDATED_BY);
559: END IF;
560:
561: FORALL i in 1..Merge_Header_ID_List.Count

Line 558: HZ_Utility_Pub.LAST_UPDATED_BY);

554: HZ_Utility_Pub.CREATED_BY,
555: HZ_Utility_Pub.CREATION_DATE,
556: HZ_Utility_Pub.LAST_UPDATE_LOGIN,
557: HZ_Utility_Pub.LAST_UPDATE_DATE,
558: HZ_Utility_Pub.LAST_UPDATED_BY);
559: END IF;
560:
561: FORALL i in 1..Merge_Header_ID_List.Count
562: DELETE FROM FII_Cust_Accounts