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_H

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 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 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 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 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 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 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 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 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 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 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: