DBA Data[Home] [Help]

APPS.CSI_PARTY_MERGE_PKG dependencies on FND_GLOBAL

Line 5: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;

1: PACKAGE BODY CSI_PARTY_MERGE_PKG AS
2: /* $Header: csipymgb.pls 120.3 2010/05/27 18:14:50 devijay ship $ */
3:
4: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CSI_PARTY_MERGE_PKG';
5: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;
6: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.LOGIN_ID;
7:
8: PROCEDURE CSI_ITEM_INSTANCES_MERGE(
9: p_entity_name IN VARCHAR2,

Line 6: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.LOGIN_ID;

2: /* $Header: csipymgb.pls 120.3 2010/05/27 18:14:50 devijay ship $ */
3:
4: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CSI_PARTY_MERGE_PKG';
5: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;
6: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.LOGIN_ID;
7:
8: PROCEDURE CSI_ITEM_INSTANCES_MERGE(
9: p_entity_name IN VARCHAR2,
10: p_from_id IN NUMBER,

Line 210: ,fnd_global.user_id

206: ,sysdate
207: ,sysdate
208: ,v_transaction_type_id
209: ,p_batch_id
210: ,fnd_global.user_id
211: ,sysdate
212: ,fnd_global.user_id
213: ,sysdate
214: ,fnd_global.user_id

Line 212: ,fnd_global.user_id

208: ,v_transaction_type_id
209: ,p_batch_id
210: ,fnd_global.user_id
211: ,sysdate
212: ,fnd_global.user_id
213: ,sysdate
214: ,fnd_global.user_id
215: ,1
216: );

Line 214: ,fnd_global.user_id

210: ,fnd_global.user_id
211: ,sysdate
212: ,fnd_global.user_id
213: ,sysdate
214: ,fnd_global.user_id
215: ,1
216: );
217:
218: End;

Line 251: ,fnd_global.user_id

247: ,v_transaction_id
248: ,decode( cii.location_id, p_from_fk_id, cii.location_id, null )
249: ,decode( cii.location_id, p_from_fk_id, p_to_fk_id, null )
250: ,'N'
251: ,fnd_global.user_id
252: ,sysdate
253: ,fnd_global.user_id
254: ,sysdate
255: ,fnd_global.user_id

Line 253: ,fnd_global.user_id

249: ,decode( cii.location_id, p_from_fk_id, p_to_fk_id, null )
250: ,'N'
251: ,fnd_global.user_id
252: ,sysdate
253: ,fnd_global.user_id
254: ,sysdate
255: ,fnd_global.user_id
256: ,1
257: ,decode( cii.install_location_id, p_from_fk_id, cii.install_location_id, null )

Line 255: ,fnd_global.user_id

251: ,fnd_global.user_id
252: ,sysdate
253: ,fnd_global.user_id
254: ,sysdate
255: ,fnd_global.user_id
256: ,1
257: ,decode( cii.install_location_id, p_from_fk_id, cii.install_location_id, null )
258: ,decode( cii.install_location_id, p_from_fk_id, p_to_fk_id, null )
259: FROM csi_item_instances cii

Line 500: ,fnd_global.user_id

496: ,sysdate
497: ,sysdate
498: ,v_transaction_type_id
499: ,p_batch_id
500: ,fnd_global.user_id
501: ,sysdate
502: ,fnd_global.user_id
503: ,sysdate
504: ,fnd_global.user_id

Line 502: ,fnd_global.user_id

498: ,v_transaction_type_id
499: ,p_batch_id
500: ,fnd_global.user_id
501: ,sysdate
502: ,fnd_global.user_id
503: ,sysdate
504: ,fnd_global.user_id
505: ,1
506: );

Line 504: ,fnd_global.user_id

500: ,fnd_global.user_id
501: ,sysdate
502: ,fnd_global.user_id
503: ,sysdate
504: ,fnd_global.user_id
505: ,1
506: );
507: End;
508: End;

Line 537: fnd_global.user_id,

533: v_party_source_table,
534: p_from_fk_id,
535: p_to_fk_id,
536: 'N',
537: fnd_global.user_id,
538: sysdate,
539: fnd_global.user_id,
540: sysdate,
541: fnd_global.user_id,

Line 539: fnd_global.user_id,

535: p_to_fk_id,
536: 'N',
537: fnd_global.user_id,
538: sysdate,
539: fnd_global.user_id,
540: sysdate,
541: fnd_global.user_id,
542: 1
543: FROM csi_i_parties cip

Line 541: fnd_global.user_id,

537: fnd_global.user_id,
538: sysdate,
539: fnd_global.user_id,
540: sysdate,
541: fnd_global.user_id,
542: 1
543: FROM csi_i_parties cip
544: WHERE cip.party_source_table = v_party_source_table
545: AND cip.party_id = p_from_fk_id;

Line 743: ,fnd_global.user_id

739: ,sysdate
740: ,sysdate
741: ,v_transaction_type_id
742: ,p_batch_id
743: ,fnd_global.user_id
744: ,sysdate
745: ,fnd_global.user_id
746: ,sysdate
747: ,fnd_global.user_id

Line 745: ,fnd_global.user_id

741: ,v_transaction_type_id
742: ,p_batch_id
743: ,fnd_global.user_id
744: ,sysdate
745: ,fnd_global.user_id
746: ,sysdate
747: ,fnd_global.user_id
748: ,1
749: );

Line 747: ,fnd_global.user_id

743: ,fnd_global.user_id
744: ,sysdate
745: ,fnd_global.user_id
746: ,sysdate
747: ,fnd_global.user_id
748: ,1
749: );
750: End;
751: END;

Line 776: fnd_global.user_id,

772: v_transaction_id,
773: p_from_fk_id,
774: p_to_fk_id,
775: 'N',
776: fnd_global.user_id,
777: sysdate,
778: fnd_global.user_id,
779: sysdate,
780: fnd_global.user_id,

Line 778: fnd_global.user_id,

774: p_to_fk_id,
775: 'N',
776: fnd_global.user_id,
777: sysdate,
778: fnd_global.user_id,
779: sysdate,
780: fnd_global.user_id,
781: 1
782: FROM csi_systems_b csb

Line 780: fnd_global.user_id,

776: fnd_global.user_id,
777: sysdate,
778: fnd_global.user_id,
779: sysdate,
780: fnd_global.user_id,
781: 1
782: FROM csi_systems_b csb
783: WHERE csb.install_site_use_id = p_from_fk_id;
784:

Line 849: fnd_global.user_id,

845: decode( csb.technical_contact_id, p_from_fk_id, p_to_fk_id, null ),
846: decode( csb.service_admin_contact_id, p_from_fk_id, p_from_fk_id, null ),
847: decode( csb.service_admin_contact_id, p_from_fk_id, p_to_fk_id, null ),
848: 'N',
849: fnd_global.user_id,
850: sysdate,
851: fnd_global.user_id,
852: sysdate,
853: fnd_global.user_id,

Line 851: fnd_global.user_id,

847: decode( csb.service_admin_contact_id, p_from_fk_id, p_to_fk_id, null ),
848: 'N',
849: fnd_global.user_id,
850: sysdate,
851: fnd_global.user_id,
852: sysdate,
853: fnd_global.user_id,
854: 1
855: FROM csi_systems_b csb

Line 853: fnd_global.user_id,

849: fnd_global.user_id,
850: sysdate,
851: fnd_global.user_id,
852: sysdate,
853: fnd_global.user_id,
854: 1
855: FROM csi_systems_b csb
856: WHERE ship_to_contact_id = p_from_fk_id
857: OR bill_to_contact_id = p_from_fk_id