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,
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,
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
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: );
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;
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
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 )
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
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
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: );
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;
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,
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
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;
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
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: );
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;
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,
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
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:
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,
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
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