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 12718: select CSI_I_PARTIES_S.nextval

12714: Raise;
12715: End;
12716: --
12717: Begin
12718: select CSI_I_PARTIES_S.nextval
12719: into v_ins_party_id
12720: from DUAL;
12721: End;
12722: Begin

Line 12723: INSERT INTO CSI_I_PARTIES(

12719: into v_ins_party_id
12720: from DUAL;
12721: End;
12722: Begin
12723: INSERT INTO CSI_I_PARTIES(
12724: INSTANCE_PARTY_ID
12725: ,INSTANCE_ID
12726: ,PARTY_SOURCE_TABLE
12727: ,PARTY_ID

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

12758: );
12759: Exception
12760: when others then
12761: v_err_msg := 'Unable to Insert Item ID '||to_char(inventory_item_id_mig(i))
12762: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);
12763: raise_application_error(-20000, v_err_msg );
12764: Raise;
12765: End;
12766: -- Insert into CSI_I_PARTIES_H

Line 12766: -- Insert into CSI_I_PARTIES_H

12762: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);
12763: raise_application_error(-20000, v_err_msg );
12764: Raise;
12765: End;
12766: -- Insert into CSI_I_PARTIES_H
12767: Begin
12768: select CSI_I_PARTIES_H_S.nextval
12769: into v_ins_party_history_id
12770: from DUAL;

Line 12768: select CSI_I_PARTIES_H_S.nextval

12764: Raise;
12765: End;
12766: -- Insert into CSI_I_PARTIES_H
12767: Begin
12768: select CSI_I_PARTIES_H_S.nextval
12769: into v_ins_party_history_id
12770: from DUAL;
12771: End;
12772: -- Insert into CSI_I_PARTIES_H

Line 12772: -- Insert into CSI_I_PARTIES_H

12768: select CSI_I_PARTIES_H_S.nextval
12769: into v_ins_party_history_id
12770: from DUAL;
12771: End;
12772: -- Insert into CSI_I_PARTIES_H
12773: Begin
12774: INSERT INTO CSI_I_PARTIES_H(
12775: INSTANCE_PARTY_HISTORY_ID
12776: ,INSTANCE_PARTY_ID

Line 12774: INSERT INTO CSI_I_PARTIES_H(

12770: from DUAL;
12771: End;
12772: -- Insert into CSI_I_PARTIES_H
12773: Begin
12774: INSERT INTO CSI_I_PARTIES_H(
12775: INSTANCE_PARTY_HISTORY_ID
12776: ,INSTANCE_PARTY_ID
12777: ,TRANSACTION_ID
12778: ,OLD_PARTY_SOURCE_TABLE

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

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

Line 13212: select CSI_I_PARTIES_S.nextval

13208: Raise;
13209: End;
13210: --
13211: Begin
13212: select CSI_I_PARTIES_S.nextval
13213: into v_ins_party_id
13214: from DUAL;
13215: End;
13216: Begin

Line 13217: INSERT INTO CSI_I_PARTIES(

13213: into v_ins_party_id
13214: from DUAL;
13215: End;
13216: Begin
13217: INSERT INTO CSI_I_PARTIES(
13218: INSTANCE_PARTY_ID
13219: ,INSTANCE_ID
13220: ,PARTY_SOURCE_TABLE
13221: ,PARTY_ID

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

13252: );
13253: Exception
13254: when others then
13255: v_err_msg := 'Unable to Insert Item ID '||to_char(inventory_item_id_mig(i))
13256: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);
13257: raise_application_error(-20000, v_err_msg );
13258: Raise;
13259: End;
13260: -- Insert into CSI_I_PARTIES_H

Line 13260: -- Insert into CSI_I_PARTIES_H

13256: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);
13257: raise_application_error(-20000, v_err_msg );
13258: Raise;
13259: End;
13260: -- Insert into CSI_I_PARTIES_H
13261: Begin
13262: select CSI_I_PARTIES_H_S.nextval
13263: into v_ins_party_history_id
13264: from DUAL;

Line 13262: select CSI_I_PARTIES_H_S.nextval

13258: Raise;
13259: End;
13260: -- Insert into CSI_I_PARTIES_H
13261: Begin
13262: select CSI_I_PARTIES_H_S.nextval
13263: into v_ins_party_history_id
13264: from DUAL;
13265: End;
13266: -- Insert into CSI_I_PARTIES_H

Line 13266: -- Insert into CSI_I_PARTIES_H

13262: select CSI_I_PARTIES_H_S.nextval
13263: into v_ins_party_history_id
13264: from DUAL;
13265: End;
13266: -- Insert into CSI_I_PARTIES_H
13267: Begin
13268: INSERT INTO CSI_I_PARTIES_H(
13269: INSTANCE_PARTY_HISTORY_ID
13270: ,INSTANCE_PARTY_ID

Line 13268: INSERT INTO CSI_I_PARTIES_H(

13264: from DUAL;
13265: End;
13266: -- Insert into CSI_I_PARTIES_H
13267: Begin
13268: INSERT INTO CSI_I_PARTIES_H(
13269: INSTANCE_PARTY_HISTORY_ID
13270: ,INSTANCE_PARTY_ID
13271: ,TRANSACTION_ID
13272: ,OLD_PARTY_SOURCE_TABLE

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

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

Line 14261: select CSI_I_PARTIES_S.nextval

14257: Raise;
14258: End;
14259: --
14260: Begin
14261: select CSI_I_PARTIES_S.nextval
14262: into v_ins_party_id
14263: from DUAL;
14264: End;
14265: Begin

Line 14266: INSERT INTO CSI_I_PARTIES(

14262: into v_ins_party_id
14263: from DUAL;
14264: End;
14265: Begin
14266: INSERT INTO CSI_I_PARTIES(
14267: INSTANCE_PARTY_ID
14268: ,INSTANCE_ID
14269: ,PARTY_SOURCE_TABLE
14270: ,PARTY_ID

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

14301: );
14302: Exception
14303: when others then
14304: v_err_msg := 'Unable to Insert Item ID '||to_char(inventory_item_id_mig(i))
14305: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);
14306: raise_application_error(-20000, v_err_msg );
14307: Raise;
14308: End;
14309: -- Insert into CSI_I_PARTIES_H

Line 14309: -- Insert into CSI_I_PARTIES_H

14305: ||' into CSI_I_PARTIES '||SUBSTR(sqlerrm,1,1000);
14306: raise_application_error(-20000, v_err_msg );
14307: Raise;
14308: End;
14309: -- Insert into CSI_I_PARTIES_H
14310: Begin
14311: select CSI_I_PARTIES_H_S.nextval
14312: into v_ins_party_history_id
14313: from DUAL;

Line 14311: select CSI_I_PARTIES_H_S.nextval

14307: Raise;
14308: End;
14309: -- Insert into CSI_I_PARTIES_H
14310: Begin
14311: select CSI_I_PARTIES_H_S.nextval
14312: into v_ins_party_history_id
14313: from DUAL;
14314: End;
14315: -- Insert into CSI_I_PARTIES_H

Line 14315: -- Insert into CSI_I_PARTIES_H

14311: select CSI_I_PARTIES_H_S.nextval
14312: into v_ins_party_history_id
14313: from DUAL;
14314: End;
14315: -- Insert into CSI_I_PARTIES_H
14316: Begin
14317: INSERT INTO CSI_I_PARTIES_H(
14318: INSTANCE_PARTY_HISTORY_ID
14319: ,INSTANCE_PARTY_ID

Line 14317: INSERT INTO CSI_I_PARTIES_H(

14313: from DUAL;
14314: End;
14315: -- Insert into CSI_I_PARTIES_H
14316: Begin
14317: INSERT INTO CSI_I_PARTIES_H(
14318: INSTANCE_PARTY_HISTORY_ID
14319: ,INSTANCE_PARTY_ID
14320: ,TRANSACTION_ID
14321: ,OLD_PARTY_SOURCE_TABLE

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

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

Line 14926: DELETE FROM csi_i_parties_h

14922:
14923: DELETE FROM csi_item_instances_h
14924: WHERE instance_id=i.instance_id;
14925: --
14926: DELETE FROM csi_i_parties_h
14927: WHERE instance_party_id in (select instance_party_id from csi_i_parties
14928: WHERE instance_id=i.instance_id);
14929: --
14930: DELETE FROM csi_i_parties

Line 14927: WHERE instance_party_id in (select instance_party_id from csi_i_parties

14923: DELETE FROM csi_item_instances_h
14924: WHERE instance_id=i.instance_id;
14925: --
14926: DELETE FROM csi_i_parties_h
14927: WHERE instance_party_id in (select instance_party_id from csi_i_parties
14928: WHERE instance_id=i.instance_id);
14929: --
14930: DELETE FROM csi_i_parties
14931: WHERE instance_id=i.instance_id;

Line 14930: DELETE FROM csi_i_parties

14926: DELETE FROM csi_i_parties_h
14927: WHERE instance_party_id in (select instance_party_id from csi_i_parties
14928: WHERE instance_id=i.instance_id);
14929: --
14930: DELETE FROM csi_i_parties
14931: WHERE instance_id=i.instance_id;
14932: --
14933: DELETE FROM csi_item_instances
14934: WHERE instance_id=i.instance_id;

Line 15547: FROM csi_i_parties

15543:
15544: BEGIN
15545: SELECT instance_party_id
15546: INTO l_pty_dtl_tbl(1).instance_party_id
15547: FROM csi_i_parties
15548: WHERE instance_id = l_instance_tbl(j).instance_id
15549: AND relationship_type_code = 'OWNER';
15550: EXCEPTION
15551: WHEN no_data_found THEN

Line 15835: FROM csi_i_parties

15831: AND cii.wip_job_id = p_wip_job_id;
15832:
15833: CURSOR ip_cur(p_instance_id IN number) IS
15834: SELECT instance_party_id
15835: FROM csi_i_parties
15836: WHERE instance_id = p_instance_id;
15837:
15838: BEGIN
15839:

Line 15879: DELETE FROM csi_i_parties_h

15875: -- there may not be an account, but just in case
15876: DELETE FROM csi_ip_accounts
15877: WHERE instance_party_id = ip_rec.instance_party_id;
15878:
15879: DELETE FROM csi_i_parties_h
15880: WHERE instance_party_id = ip_rec.instance_party_id;
15881:
15882: END LOOP;
15883:

Line 15884: DELETE FROM csi_i_parties

15880: WHERE instance_party_id = ip_rec.instance_party_id;
15881:
15882: END LOOP;
15883:
15884: DELETE FROM csi_i_parties
15885: WHERE instance_id = dup_inst_rec.instance_id;
15886:
15887: DELETE FROM csi_item_instances
15888: WHERE instance_id = dup_inst_rec.instance_id;