eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_I_PARTIES

Line 455: select CSI_I_PARTIES_H_S.nextval

451: ,p_party_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
452: ) IS
453: BEGIN
454: FOR i in p_party_tbl.FIRST .. p_party_tbl.LAST LOOP
455: select CSI_I_PARTIES_H_S.nextval
456: into p_party_hist_tbl(i) from dual;
457: --
458: p_party_rec_tab.instance_party_id(i) := p_party_tbl(i).instance_party_id;
459: p_party_rec_tab.instance_id(i) := p_party_tbl(i).instance_id;

Line 894: FROM csi_i_parties

890: x_pty_tbl(l_ind).primary_flag := p_pty_h_tbl(l_ind).primary_flag;
891: x_pty_tbl(l_ind).preferred_flag := p_pty_h_tbl(l_ind).preferred_flag;
892: SELECT object_version_number
893: INTO x_pty_tbl(l_ind).object_version_number
894: FROM csi_i_parties
895: WHERE instance_party_id = p_pty_h_tbl(l_ind).instance_party_id;
896: END LOOP;
897: END IF;
898:

Line 2067: INSERT INTO CSI_I_PARTIES_H(

2063: --
2064: -- Insert into History
2065: log('Before inserting into Parties history..');
2066: FORALL i in 1 .. l_party_rec_tab.instance_party_id.count
2067: INSERT INTO CSI_I_PARTIES_H(
2068: INSTANCE_PARTY_HISTORY_ID,
2069: INSTANCE_PARTY_ID,
2070: TRANSACTION_ID,
2071: NEW_PARTY_SOURCE_TABLE,

Line 4191: FROM csi_i_parties

4187:
4188: BEGIN
4189: SELECT instance_party_id
4190: INTO l_owner_ip_id
4191: FROM csi_i_parties
4192: WHERE instance_id = l_inst_id
4193: AND relationship_type_code = 'OWNER'
4194: AND rownum = 1;
4195:

Line 6288: FROM csi_i_parties

6284: SELECT instance_party_id,
6285: object_version_number
6286: INTO l_parties_tbl(lp_ind).instance_party_id,
6287: l_parties_tbl(lp_ind).object_version_number
6288: FROM csi_i_parties
6289: WHERE instance_id = l_instance_rec.instance_id
6290: AND relationship_type_code = l_parties_tbl(lp_ind).relationship_type_code
6291: AND rownum = 1;
6292: END LOOP;

Line 9185: FROM csi_i_parties

9181: SELECT instance_party_id,
9182: object_version_number
9183: INTO l_parties_tbl(1).instance_party_id,
9184: l_parties_tbl(1).object_version_number
9185: FROM csi_i_parties
9186: WHERE instance_id = l_instance_rec.instance_id
9187: AND relationship_type_code = 'OWNER';
9188:
9189: log(' csi_process_txn_pvt.check_and_break_relation');

Line 9601: DELETE FROM CSI_I_PARTIES WHERE instance_id = l_instance_tbl(j);

9597: BEGIN
9598: FORALL j in l_instance_tbl.FIRST .. l_instance_tbl.LAST
9599: DELETE FROM CSI_ITEM_INSTANCES WHERE instance_id = l_instance_tbl(j);
9600: FORALL j in l_instance_tbl.FIRST .. l_instance_tbl.LAST
9601: DELETE FROM CSI_I_PARTIES WHERE instance_id = l_instance_tbl(j);
9602: FORALL j in l_instance_tbl.FIRST .. l_instance_tbl.LAST
9603: DELETE FROM CSI_I_VERSION_LABELS WHERE instance_id = l_instance_tbl(j);
9604: FORALL j in l_txn_tbl.FIRST .. l_txn_tbl.LAST
9605: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_txn_tbl(j);

Line 9607: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_txn_tbl(j);

9603: DELETE FROM CSI_I_VERSION_LABELS WHERE instance_id = l_instance_tbl(j);
9604: FORALL j in l_txn_tbl.FIRST .. l_txn_tbl.LAST
9605: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_txn_tbl(j);
9606: FORALL j in l_txn_tbl.FIRST .. l_txn_tbl.LAST
9607: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_txn_tbl(j);
9608: FORALL j in l_txn_tbl.FIRST .. l_txn_tbl.LAST
9609: DELETE FROM CSI_I_VERSION_LABELS_H WHERE transaction_id = l_txn_tbl(j);
9610: FORALL j in l_txn_tbl.FIRST .. l_txn_tbl.LAST
9611: DELETE FROM CSI_TRANSACTIONS WHERE transaction_id = l_txn_tbl(j);

Line 10228: DELETE FROM CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j);

10224: BEGIN
10225: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
10226: DELETE FROM CSI_ITEM_INSTANCES WHERE instance_id = l_del_inst_tbl(j);
10227: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
10228: DELETE FROM CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j);
10229: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
10230: DELETE FROM CSI_I_VERSION_LABELS WHERE instance_id = l_del_inst_tbl(j);
10231: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
10232: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);

Line 10234: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);

10230: DELETE FROM CSI_I_VERSION_LABELS WHERE instance_id = l_del_inst_tbl(j);
10231: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
10232: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
10233: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
10234: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);
10235: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
10236: DELETE FROM CSI_I_VERSION_LABELS_H WHERE transaction_id = l_del_txn_tbl(j);
10237: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
10238: DELETE FROM CSI_TRANSACTIONS WHERE transaction_id = l_del_txn_tbl(j);

Line 10556: FROM csi_i_parties

10552: FOR i IN 1 .. instance_id_mig.count LOOP
10553: BEGIN
10554: SELECT party_source_table
10555: INTO party_src_table_mig(i)
10556: FROM csi_i_parties
10557: WHERE relationship_type_code = 'OWNER'
10558: AND instance_id = instance_id_mig(i);
10559: EXCEPTION
10560: WHEN no_data_found THEN

Line 10583: from CSI_I_PARTIES

10579: PROCEDURE Update_Contact_Party_Record IS
10580: CURSOR CSI_PARTY_CUR IS
10581: select instance_id,instance_party_id,contact_ip_id,
10582: contact_flag,relationship_type_code
10583: from CSI_I_PARTIES
10584: where contact_ip_id IS NOT NULL;
10585: --
10586: l_ins_party_id NUMBER;
10587: TYPE NUMLIST IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 10631: from CSI_I_PARTIES

10627: ELSE
10628: Begin
10629: select 'x'
10630: into l_exists
10631: from CSI_I_PARTIES
10632: where instance_party_id = contact_ip_id_mig(i)
10633: and instance_id = instance_id_mig(i);
10634: Exception
10635: when no_data_found then

Line 10643: UPDATE CSI_I_PARTIES

10639: END IF;
10640: END LOOP;
10641: IF l_upd_pty_tbl.count > 0 THEN
10642: FORALL j in l_upd_pty_tbl.FIRST .. l_upd_pty_tbl.LAST
10643: UPDATE CSI_I_PARTIES
10644: set contact_ip_id = null
10645: where instance_party_id = l_upd_pty_tbl(j);
10646: --
10647: commit;

Line 10652: UPDATE CSI_I_PARTIES

10648: END IF;
10649: --
10650: IF l_exp_pty_tbl.count > 0 THEN
10651: FORALL j in l_exp_pty_tbl.FIRST .. l_exp_pty_tbl.LAST
10652: UPDATE CSI_I_PARTIES
10653: set contact_ip_id = null,
10654: active_end_date = sysdate
10655: where instance_party_id = l_exp_pty_tbl(j);
10656: --

Line 10668: from CSI_I_PARTIES

10664: --
10665: PROCEDURE Revert_Party_Rel_Type_Update IS
10666: CURSOR INS_CUR IS
10667: select instance_id,relationship_type_code,count(*)
10668: from CSI_I_PARTIES
10669: where relationship_type_code = 'OWNER'
10670: group by instance_id,relationship_type_code
10671: having count(*) > 1;
10672: --

Line 10677: from CSI_I_PARTIES_H a

10673: CURSOR PARTY_HIST_CUR IS
10674: select a.instance_party_history_id instance_party_history_id,a.instance_party_id instance_party_id,
10675: a.old_relationship_type_code old_rel_type,
10676: a.old_party_id old_party_id,a.new_party_id new_party_id
10677: from CSI_I_PARTIES_H a
10678: where a.old_relationship_type_code is not null
10679: and a.old_relationship_type_code <> 'OWNER'
10680: and a.new_relationship_type_code is not null
10681: and a.new_relationship_type_code = 'OWNER'

Line 10684: and exists (select 'x' from CSI_I_PARTIES b

10680: and a.new_relationship_type_code is not null
10681: and a.new_relationship_type_code = 'OWNER'
10682: and a.new_party_id is not null
10683: and a.old_party_id is not null
10684: and exists (select 'x' from CSI_I_PARTIES b
10685: where b.instance_id = (select c.instance_id from CSI_I_PARTIES c
10686: where c.instance_party_id = a.instance_party_id)
10687: and b.relationship_type_code = 'OWNER')
10688: and a.instance_party_history_id = (select max(instance_party_history_id)

Line 10685: where b.instance_id = (select c.instance_id from CSI_I_PARTIES c

10681: and a.new_relationship_type_code = 'OWNER'
10682: and a.new_party_id is not null
10683: and a.old_party_id is not null
10684: and exists (select 'x' from CSI_I_PARTIES b
10685: where b.instance_id = (select c.instance_id from CSI_I_PARTIES c
10686: where c.instance_party_id = a.instance_party_id)
10687: and b.relationship_type_code = 'OWNER')
10688: and a.instance_party_history_id = (select max(instance_party_history_id)
10689: from CSI_I_PARTIES_H d

Line 10689: from CSI_I_PARTIES_H d

10685: where b.instance_id = (select c.instance_id from CSI_I_PARTIES c
10686: where c.instance_party_id = a.instance_party_id)
10687: and b.relationship_type_code = 'OWNER')
10688: and a.instance_party_history_id = (select max(instance_party_history_id)
10689: from CSI_I_PARTIES_H d
10690: where d.instance_party_id = a.instance_party_id);
10691: --
10692: TYPE NUMLIST IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10693: l_inst_tbl NUMLIST;

Line 10772: Update CSI_I_PARTIES

10768: --
10769: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
10770: --
10771: FOR party_rec in PARTY_HIST_CUR LOOP
10772: Update CSI_I_PARTIES
10773: set relationship_type_code = party_rec.old_rel_type,
10774: party_id = party_rec.old_party_id
10775: where instance_party_id = party_rec.instance_party_id;
10776: --

Line 10777: Update CSI_I_PARTIES

10773: set relationship_type_code = party_rec.old_rel_type,
10774: party_id = party_rec.old_party_id
10775: where instance_party_id = party_rec.instance_party_id;
10776: --
10777: Update CSI_I_PARTIES
10778: set party_id = party_rec.new_party_id
10779: where instance_id = (select instance_id from CSI_I_PARTIES
10780: where instance_party_id = party_rec.instance_party_id)
10781: and relationship_type_code = 'OWNER';

Line 10779: where instance_id = (select instance_id from CSI_I_PARTIES

10775: where instance_party_id = party_rec.instance_party_id;
10776: --
10777: Update CSI_I_PARTIES
10778: set party_id = party_rec.new_party_id
10779: where instance_id = (select instance_id from CSI_I_PARTIES
10780: where instance_party_id = party_rec.instance_party_id)
10781: and relationship_type_code = 'OWNER';
10782: --
10783: Update CSI_I_PARTIES_H

Line 10783: Update CSI_I_PARTIES_H

10779: where instance_id = (select instance_id from CSI_I_PARTIES
10780: where instance_party_id = party_rec.instance_party_id)
10781: and relationship_type_code = 'OWNER';
10782: --
10783: Update CSI_I_PARTIES_H
10784: set new_relationship_type_code = party_rec.old_rel_type,
10785: new_party_id = party_rec.old_party_id
10786: where instance_party_history_id = party_rec.instance_party_history_id;
10787: --

Line 10796: from CSI_I_PARTIES

10792: Begin
10793: Begin
10794: select instance_party_id
10795: into l_ip_id
10796: from CSI_I_PARTIES
10797: where instance_id = l_inst_tbl(j)
10798: and relationship_type_code = 'OWNER'
10799: and party_id = l_internal_party_id;
10800: Exception

Line 12713: select CSI_I_PARTIES_S.nextval

12709: Raise;
12710: End;
12711: --
12712: Begin
12713: select CSI_I_PARTIES_S.nextval
12714: into v_ins_party_id
12715: from DUAL;
12716: End;
12717: Begin

Line 12718: INSERT INTO CSI_I_PARTIES(

12714: into v_ins_party_id
12715: from DUAL;
12716: End;
12717: Begin
12718: INSERT INTO CSI_I_PARTIES(
12719: INSTANCE_PARTY_ID
12720: ,INSTANCE_ID
12721: ,PARTY_SOURCE_TABLE
12722: ,PARTY_ID

Line 12757: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);

12753: );
12754: Exception
12755: when others then
12756: v_err_msg := 'Unable to Insert Item ID '||to_char(inventory_item_id_mig(i))
12757: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);
12758: raise_application_error(-20000, v_err_msg );
12759: Raise;
12760: End;
12761: -- Insert into CSI_I_PARTIES_H

Line 12761: -- Insert into CSI_I_PARTIES_H

12757: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);
12758: raise_application_error(-20000, v_err_msg );
12759: Raise;
12760: End;
12761: -- Insert into CSI_I_PARTIES_H
12762: Begin
12763: select CSI_I_PARTIES_H_S.nextval
12764: into v_ins_party_history_id
12765: from DUAL;

Line 12763: select CSI_I_PARTIES_H_S.nextval

12759: Raise;
12760: End;
12761: -- Insert into CSI_I_PARTIES_H
12762: Begin
12763: select CSI_I_PARTIES_H_S.nextval
12764: into v_ins_party_history_id
12765: from DUAL;
12766: End;
12767: -- Insert into CSI_I_PARTIES_H

Line 12767: -- Insert into CSI_I_PARTIES_H

12763: select CSI_I_PARTIES_H_S.nextval
12764: into v_ins_party_history_id
12765: from DUAL;
12766: End;
12767: -- Insert into CSI_I_PARTIES_H
12768: Begin
12769: INSERT INTO CSI_I_PARTIES_H(
12770: INSTANCE_PARTY_HISTORY_ID
12771: ,INSTANCE_PARTY_ID

Line 12769: INSERT INTO CSI_I_PARTIES_H(

12765: from DUAL;
12766: End;
12767: -- Insert into CSI_I_PARTIES_H
12768: Begin
12769: INSERT INTO CSI_I_PARTIES_H(
12770: INSTANCE_PARTY_HISTORY_ID
12771: ,INSTANCE_PARTY_ID
12772: ,TRANSACTION_ID
12773: ,OLD_PARTY_SOURCE_TABLE

Line 12826: ||' into CSI_I_PARTIES_H using the same Instance '||SUBSTR(sqlerrm,1,1000);

12822: );
12823: Exception
12824: when others then
12825: v_err_msg := 'Unable to Insert Item ID '||to_char(inventory_item_id_mig(i))
12826: ||' into CSI_I_PARTIES_H using the same Instance '||SUBSTR(sqlerrm,1,1000);
12827: raise_application_error(-20000, v_err_msg );
12828: Raise;
12829: End;
12830: ELSE -- Lot controlled item

Line 13207: select CSI_I_PARTIES_S.nextval

13203: Raise;
13204: End;
13205: --
13206: Begin
13207: select CSI_I_PARTIES_S.nextval
13208: into v_ins_party_id
13209: from DUAL;
13210: End;
13211: Begin

Line 13212: INSERT INTO CSI_I_PARTIES(

13208: into v_ins_party_id
13209: from DUAL;
13210: End;
13211: Begin
13212: INSERT INTO CSI_I_PARTIES(
13213: INSTANCE_PARTY_ID
13214: ,INSTANCE_ID
13215: ,PARTY_SOURCE_TABLE
13216: ,PARTY_ID

Line 13251: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);

13247: );
13248: Exception
13249: when others then
13250: v_err_msg := 'Unable to Insert Item ID '||to_char(inventory_item_id_mig(i))
13251: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);
13252: raise_application_error(-20000, v_err_msg );
13253: Raise;
13254: End;
13255: -- Insert into CSI_I_PARTIES_H

Line 13255: -- Insert into CSI_I_PARTIES_H

13251: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);
13252: raise_application_error(-20000, v_err_msg );
13253: Raise;
13254: End;
13255: -- Insert into CSI_I_PARTIES_H
13256: Begin
13257: select CSI_I_PARTIES_H_S.nextval
13258: into v_ins_party_history_id
13259: from DUAL;

Line 13257: select CSI_I_PARTIES_H_S.nextval

13253: Raise;
13254: End;
13255: -- Insert into CSI_I_PARTIES_H
13256: Begin
13257: select CSI_I_PARTIES_H_S.nextval
13258: into v_ins_party_history_id
13259: from DUAL;
13260: End;
13261: -- Insert into CSI_I_PARTIES_H

Line 13261: -- Insert into CSI_I_PARTIES_H

13257: select CSI_I_PARTIES_H_S.nextval
13258: into v_ins_party_history_id
13259: from DUAL;
13260: End;
13261: -- Insert into CSI_I_PARTIES_H
13262: Begin
13263: INSERT INTO CSI_I_PARTIES_H(
13264: INSTANCE_PARTY_HISTORY_ID
13265: ,INSTANCE_PARTY_ID

Line 13263: INSERT INTO CSI_I_PARTIES_H(

13259: from DUAL;
13260: End;
13261: -- Insert into CSI_I_PARTIES_H
13262: Begin
13263: INSERT INTO CSI_I_PARTIES_H(
13264: INSTANCE_PARTY_HISTORY_ID
13265: ,INSTANCE_PARTY_ID
13266: ,TRANSACTION_ID
13267: ,OLD_PARTY_SOURCE_TABLE

Line 13320: ||' into CSI_I_PARTIES_H using the same Instance '||SUBSTR(sqlerrm,1,1000);

13316: );
13317: Exception
13318: when others then
13319: v_err_msg := 'Unable to Insert Item ID '||to_char(inventory_item_id_mig(i))
13320: ||' into CSI_I_PARTIES_H using the same Instance '||SUBSTR(sqlerrm,1,1000);
13321: raise_application_error(-20000, v_err_msg );
13322: Raise;
13323: End;
13324: END LOOP;

Line 14256: select CSI_I_PARTIES_S.nextval

14252: Raise;
14253: End;
14254: --
14255: Begin
14256: select CSI_I_PARTIES_S.nextval
14257: into v_ins_party_id
14258: from DUAL;
14259: End;
14260: Begin

Line 14261: INSERT INTO CSI_I_PARTIES(

14257: into v_ins_party_id
14258: from DUAL;
14259: End;
14260: Begin
14261: INSERT INTO CSI_I_PARTIES(
14262: INSTANCE_PARTY_ID
14263: ,INSTANCE_ID
14264: ,PARTY_SOURCE_TABLE
14265: ,PARTY_ID

Line 14300: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);

14296: );
14297: Exception
14298: when others then
14299: v_err_msg := 'Unable to Insert Item ID '||to_char(inventory_item_id_mig(i))
14300: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);
14301: raise_application_error(-20000, v_err_msg );
14302: Raise;
14303: End;
14304: -- Insert into CSI_I_PARTIES_H

Line 14304: -- Insert into CSI_I_PARTIES_H

14300: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);
14301: raise_application_error(-20000, v_err_msg );
14302: Raise;
14303: End;
14304: -- Insert into CSI_I_PARTIES_H
14305: Begin
14306: select CSI_I_PARTIES_H_S.nextval
14307: into v_ins_party_history_id
14308: from DUAL;

Line 14306: select CSI_I_PARTIES_H_S.nextval

14302: Raise;
14303: End;
14304: -- Insert into CSI_I_PARTIES_H
14305: Begin
14306: select CSI_I_PARTIES_H_S.nextval
14307: into v_ins_party_history_id
14308: from DUAL;
14309: End;
14310: -- Insert into CSI_I_PARTIES_H

Line 14310: -- Insert into CSI_I_PARTIES_H

14306: select CSI_I_PARTIES_H_S.nextval
14307: into v_ins_party_history_id
14308: from DUAL;
14309: End;
14310: -- Insert into CSI_I_PARTIES_H
14311: Begin
14312: INSERT INTO CSI_I_PARTIES_H(
14313: INSTANCE_PARTY_HISTORY_ID
14314: ,INSTANCE_PARTY_ID

Line 14312: INSERT INTO CSI_I_PARTIES_H(

14308: from DUAL;
14309: End;
14310: -- Insert into CSI_I_PARTIES_H
14311: Begin
14312: INSERT INTO CSI_I_PARTIES_H(
14313: INSTANCE_PARTY_HISTORY_ID
14314: ,INSTANCE_PARTY_ID
14315: ,TRANSACTION_ID
14316: ,OLD_PARTY_SOURCE_TABLE

Line 14369: ||' into CSI_I_PARTIES_H using the same Instance '||SUBSTR(sqlerrm,1,1000);

14365: );
14366: Exception
14367: when others then
14368: v_err_msg := 'Unable to Insert Item ID '||to_char(inventory_item_id_mig(i))
14369: ||' into CSI_I_PARTIES_H using the same Instance '||SUBSTR(sqlerrm,1,1000);
14370: raise_application_error(-20000, v_err_msg );
14371: Raise;
14372: End;
14373: Exception

Line 14915: DELETE FROM csi_i_parties_h

14911:
14912: DELETE FROM csi_item_instances_h
14913: WHERE instance_id=i.instance_id;
14914: --
14915: DELETE FROM csi_i_parties_h
14916: WHERE instance_party_id in (select instance_party_id from csi_i_parties
14917: WHERE instance_id=i.instance_id);
14918: --
14919: DELETE FROM csi_i_parties

Line 14916: WHERE instance_party_id in (select instance_party_id from csi_i_parties

14912: DELETE FROM csi_item_instances_h
14913: WHERE instance_id=i.instance_id;
14914: --
14915: DELETE FROM csi_i_parties_h
14916: WHERE instance_party_id in (select instance_party_id from csi_i_parties
14917: WHERE instance_id=i.instance_id);
14918: --
14919: DELETE FROM csi_i_parties
14920: WHERE instance_id=i.instance_id;

Line 14919: DELETE FROM csi_i_parties

14915: DELETE FROM csi_i_parties_h
14916: WHERE instance_party_id in (select instance_party_id from csi_i_parties
14917: WHERE instance_id=i.instance_id);
14918: --
14919: DELETE FROM csi_i_parties
14920: WHERE instance_id=i.instance_id;
14921: --
14922: DELETE FROM csi_item_instances
14923: WHERE instance_id=i.instance_id;

Line 15536: FROM csi_i_parties

15532:
15533: BEGIN
15534: SELECT instance_party_id
15535: INTO l_pty_dtl_tbl(1).instance_party_id
15536: FROM csi_i_parties
15537: WHERE instance_id = l_instance_tbl(j).instance_id
15538: AND relationship_type_code = 'OWNER';
15539: EXCEPTION
15540: WHEN no_data_found THEN

Line 15824: FROM csi_i_parties

15820: AND cii.wip_job_id = p_wip_job_id;
15821:
15822: CURSOR ip_cur(p_instance_id IN number) IS
15823: SELECT instance_party_id
15824: FROM csi_i_parties
15825: WHERE instance_id = p_instance_id;
15826:
15827: BEGIN
15828:

Line 15868: DELETE FROM csi_i_parties_h

15864: -- there may not be an account, but just in case
15865: DELETE FROM csi_ip_accounts
15866: WHERE instance_party_id = ip_rec.instance_party_id;
15867:
15868: DELETE FROM csi_i_parties_h
15869: WHERE instance_party_id = ip_rec.instance_party_id;
15870:
15871: END LOOP;
15872:

Line 15873: DELETE FROM csi_i_parties

15869: WHERE instance_party_id = ip_rec.instance_party_id;
15870:
15871: END LOOP;
15872:
15873: DELETE FROM csi_i_parties
15874: WHERE instance_id = dup_inst_rec.instance_id;
15875:
15876: DELETE FROM csi_item_instances
15877: WHERE instance_id = dup_inst_rec.instance_id;