DBA Data[Home] [Help]

APPS.CSI_PARTY_MERGE_PKG dependencies on STANDARD

Line 182: ,arp_standard.profile.user_id

178: ,sysdate
179: ,sysdate
180: ,v_transaction_type_id
181: ,p_batch_id
182: ,arp_standard.profile.user_id
183: ,sysdate
184: ,arp_standard.profile.user_id
185: ,sysdate
186: ,arp_standard.profile.user_id

Line 184: ,arp_standard.profile.user_id

180: ,v_transaction_type_id
181: ,p_batch_id
182: ,arp_standard.profile.user_id
183: ,sysdate
184: ,arp_standard.profile.user_id
185: ,sysdate
186: ,arp_standard.profile.user_id
187: ,1
188: );

Line 186: ,arp_standard.profile.user_id

182: ,arp_standard.profile.user_id
183: ,sysdate
184: ,arp_standard.profile.user_id
185: ,sysdate
186: ,arp_standard.profile.user_id
187: ,1
188: );
189:
190: End;

Line 220: ,arp_standard.profile.user_id

216: ,v_transaction_id
217: ,decode( cii.location_id, p_from_fk_id, cii.location_id, null )
218: ,decode( cii.location_id, p_from_fk_id, p_to_fk_id, null )
219: ,'N'
220: ,arp_standard.profile.user_id
221: ,sysdate
222: ,arp_standard.profile.user_id
223: ,sysdate
224: ,arp_standard.profile.user_id

Line 222: ,arp_standard.profile.user_id

218: ,decode( cii.location_id, p_from_fk_id, p_to_fk_id, null )
219: ,'N'
220: ,arp_standard.profile.user_id
221: ,sysdate
222: ,arp_standard.profile.user_id
223: ,sysdate
224: ,arp_standard.profile.user_id
225: ,1
226: ,decode( cii.install_location_id, p_from_fk_id, cii.install_location_id, null )

Line 224: ,arp_standard.profile.user_id

220: ,arp_standard.profile.user_id
221: ,sysdate
222: ,arp_standard.profile.user_id
223: ,sysdate
224: ,arp_standard.profile.user_id
225: ,1
226: ,decode( cii.install_location_id, p_from_fk_id, cii.install_location_id, null )
227: ,decode( cii.install_location_id, p_from_fk_id, p_to_fk_id, null )
228: FROM csi_item_instances cii

Line 430: ,arp_standard.profile.user_id

426: ,sysdate
427: ,sysdate
428: ,v_transaction_type_id
429: ,p_batch_id
430: ,arp_standard.profile.user_id
431: ,sysdate
432: ,arp_standard.profile.user_id
433: ,sysdate
434: ,arp_standard.profile.user_id

Line 432: ,arp_standard.profile.user_id

428: ,v_transaction_type_id
429: ,p_batch_id
430: ,arp_standard.profile.user_id
431: ,sysdate
432: ,arp_standard.profile.user_id
433: ,sysdate
434: ,arp_standard.profile.user_id
435: ,1
436: );

Line 434: ,arp_standard.profile.user_id

430: ,arp_standard.profile.user_id
431: ,sysdate
432: ,arp_standard.profile.user_id
433: ,sysdate
434: ,arp_standard.profile.user_id
435: ,1
436: );
437: End;
438: End;

Line 467: arp_standard.profile.user_id,

463: v_party_source_table,
464: p_from_fk_id,
465: p_to_fk_id,
466: 'N',
467: arp_standard.profile.user_id,
468: sysdate,
469: arp_standard.profile.user_id,
470: sysdate,
471: arp_standard.profile.user_id,

Line 469: arp_standard.profile.user_id,

465: p_to_fk_id,
466: 'N',
467: arp_standard.profile.user_id,
468: sysdate,
469: arp_standard.profile.user_id,
470: sysdate,
471: arp_standard.profile.user_id,
472: 1
473: FROM csi_i_parties cip

Line 471: arp_standard.profile.user_id,

467: arp_standard.profile.user_id,
468: sysdate,
469: arp_standard.profile.user_id,
470: sysdate,
471: arp_standard.profile.user_id,
472: 1
473: FROM csi_i_parties cip
474: WHERE cip.party_source_table = v_party_source_table
475: AND cip.party_id = p_from_fk_id;

Line 669: ,arp_standard.profile.user_id

665: ,sysdate
666: ,sysdate
667: ,v_transaction_type_id
668: ,p_batch_id
669: ,arp_standard.profile.user_id
670: ,sysdate
671: ,arp_standard.profile.user_id
672: ,sysdate
673: ,arp_standard.profile.user_id

Line 671: ,arp_standard.profile.user_id

667: ,v_transaction_type_id
668: ,p_batch_id
669: ,arp_standard.profile.user_id
670: ,sysdate
671: ,arp_standard.profile.user_id
672: ,sysdate
673: ,arp_standard.profile.user_id
674: ,1
675: );

Line 673: ,arp_standard.profile.user_id

669: ,arp_standard.profile.user_id
670: ,sysdate
671: ,arp_standard.profile.user_id
672: ,sysdate
673: ,arp_standard.profile.user_id
674: ,1
675: );
676: End;
677: END;

Line 702: arp_standard.profile.user_id,

698: v_transaction_id,
699: p_from_fk_id,
700: p_to_fk_id,
701: 'N',
702: arp_standard.profile.user_id,
703: sysdate,
704: arp_standard.profile.user_id,
705: sysdate,
706: arp_standard.profile.user_id,

Line 704: arp_standard.profile.user_id,

700: p_to_fk_id,
701: 'N',
702: arp_standard.profile.user_id,
703: sysdate,
704: arp_standard.profile.user_id,
705: sysdate,
706: arp_standard.profile.user_id,
707: 1
708: FROM csi_systems_b csb

Line 706: arp_standard.profile.user_id,

702: arp_standard.profile.user_id,
703: sysdate,
704: arp_standard.profile.user_id,
705: sysdate,
706: arp_standard.profile.user_id,
707: 1
708: FROM csi_systems_b csb
709: WHERE csb.install_site_use_id = p_from_fk_id;
710:

Line 775: arp_standard.profile.user_id,

771: decode( csb.technical_contact_id, p_from_fk_id, p_to_fk_id, null ),
772: decode( csb.service_admin_contact_id, p_from_fk_id, p_from_fk_id, null ),
773: decode( csb.service_admin_contact_id, p_from_fk_id, p_to_fk_id, null ),
774: 'N',
775: arp_standard.profile.user_id,
776: sysdate,
777: arp_standard.profile.user_id,
778: sysdate,
779: arp_standard.profile.user_id,

Line 777: arp_standard.profile.user_id,

773: decode( csb.service_admin_contact_id, p_from_fk_id, p_to_fk_id, null ),
774: 'N',
775: arp_standard.profile.user_id,
776: sysdate,
777: arp_standard.profile.user_id,
778: sysdate,
779: arp_standard.profile.user_id,
780: 1
781: FROM csi_systems_b csb

Line 779: arp_standard.profile.user_id,

775: arp_standard.profile.user_id,
776: sysdate,
777: arp_standard.profile.user_id,
778: sysdate,
779: arp_standard.profile.user_id,
780: 1
781: FROM csi_systems_b csb
782: WHERE ship_to_contact_id = p_from_fk_id
783: OR bill_to_contact_id = p_from_fk_id