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_ITEM_INSTANCE_PVT dependencies on CSI_ITEM_INSTANCES_H

Line 615: FROM CSI_ITEM_INSTANCES_H

611: ,NEW_SALES_UNIT_PRICE
612: ,NEW_SALES_CURRENCY_CODE
613: ,NEW_OPERATIONAL_STATUS_CODE
614: -- End addition of columns for FA Integration
615: FROM CSI_ITEM_INSTANCES_H
616: WHERE instance_history_id = p_instance_hist_id
617: AND full_dump_flag = 'Y' ;
618:
619: BEGIN

Line 834: FROM CSI_ITEM_INSTANCES_H

830: ,NEW_SALES_UNIT_PRICE
831: ,NEW_SALES_CURRENCY_CODE
832: ,NEW_OPERATIONAL_STATUS_CODE
833: -- End addition of columns for FA Integration
834: FROM CSI_ITEM_INSTANCES_H
835: WHERE instance_id = p_instance_id
836: --and creation_date <= x_first_no_dump
837: --and full_dump_flag = 'N'
838: ORDER BY creation_date;

Line 969: FROM CSI_ITEM_INSTANCES_H

965:
966: CURSOR get_nearest_full_dump(p_instance_id IN NUMBER ,p_time IN DATE) IS
967: SELECT
968: MAX(instance_history_id)
969: FROM CSI_ITEM_INSTANCES_H
970: WHERE creation_date <= p_time
971: and instance_id = p_instance_id
972: and full_dump_flag = 'Y' ;
973:

Line 1181: FROM CSI_ITEM_INSTANCES_H

1177: ,NEW_SALES_CURRENCY_CODE
1178: ,OLD_OPERATIONAL_STATUS_CODE
1179: ,NEW_OPERATIONAL_STATUS_CODE
1180: -- End addition of columns for FA Integration
1181: FROM CSI_ITEM_INSTANCES_H
1182: WHERE creation_date <= p_time
1183: and creation_date >= p_nearest_full_dump
1184: and instance_id = p_instance_id
1185: ORDER BY creation_date;

Line 3268: l_union_stmt VARCHAR2(2000) := ' select instance_id from csi_item_instances_h '||

3264: l_covered_level_code OKC_LINE_STYLES_B.LTY_CODE%TYPE;
3265: l_coverage_level_id NUMBER;
3266: --End Addition
3267:
3268: l_union_stmt VARCHAR2(2000) := ' select instance_id from csi_item_instances_h '||
3269: ' where transaction_id = :p_transaction_id UNION select a.instance_id '||
3270: ' from csi_i_parties a, csi_i_parties_h b where a.instance_party_id = b.instance_party_id '||
3271: ' and b.transaction_id = :p_transaction_id UNION select a.instance_id '||
3272: ' from csi_i_assets a, csi_i_assets_h b where a.instance_asset_id = b.instance_asset_id '||

Line 6354: -- Create a row in csi_item_instances_history table

6350: -- Get a unique history item instance id from the sequence
6351: l_csi_item_instance_h_id :=
6352: csi_item_instance_vld_pvt.get_csi_item_instance_h_id;
6353:
6354: -- Create a row in csi_item_instances_history table
6355: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
6356: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
6357: ,p_INSTANCE_ID => p_instance_rec.INSTANCE_ID
6358: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID

Line 6355: CSI_ITEM_INSTANCES_H_PKG.Insert_Row

6351: l_csi_item_instance_h_id :=
6352: csi_item_instance_vld_pvt.get_csi_item_instance_h_id;
6353:
6354: -- Create a row in csi_item_instances_history table
6355: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
6356: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
6357: ,p_INSTANCE_ID => p_instance_rec.INSTANCE_ID
6358: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
6359: ,p_OLD_INSTANCE_NUMBER => NULL

Line 7457: FROM csi_item_instances_h

7453: -- Begin Add Code for Siebel Genesis Project
7454: ,OLD_SOURCE_CODE
7455: ,NEW_SOURCE_CODE
7456: -- End Add Code for Siebel Genesis Project
7457: FROM csi_item_instances_h
7458: WHERE instance_history_id = p_instance_history_id
7459: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
7460:
7461: l_ins_hist_id NUMBER;

Line 7759: FROM csi_item_instances_h

7755: --Added for bug 7708851, base bug 7239642
7756: BEGIN
7757: SELECT 'Y'
7758: INTO l_create_event_called
7759: FROM csi_item_instances_h
7760: WHERE instance_id = l_rel_tbl(j).subject_id
7761: AND new_accounting_class_code = 'CUST_PROD'
7762: AND ROWNUM = 1;
7763: EXCEPTION

Line 8021: FROM csi_item_instances_h h

8017: -- Start of modifications for Bug#2547034 on 09/20/02 - rtalluri
8018: BEGIN
8019: SELECT instance_history_id
8020: INTO l_ins_hist_id
8021: FROM csi_item_instances_h h
8022: WHERE h.transaction_id = p_txn_rec.transaction_id
8023: AND h.instance_id = l_rel_tbl(j).subject_id;
8024:
8025: OPEN ins_hist_csr(l_ins_hist_id);

Line 8031: CSI_ITEM_INSTANCES_H_PKG.Update_Row

8027: CLOSE ins_hist_csr;
8028:
8029: IF l_ins_hist_csr.full_dump_flag = 'Y'
8030: THEN
8031: CSI_ITEM_INSTANCES_H_PKG.Update_Row
8032: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
8033: ,p_INSTANCE_ID => fnd_api.g_miss_num
8034: ,p_TRANSACTION_ID => fnd_api.g_miss_num
8035: ,p_OLD_INSTANCE_NUMBER => fnd_api.g_miss_char

Line 8659: CSI_ITEM_INSTANCES_H_PKG.Update_Row

8655: l_ins_hist_csr.new_operational_status_code := p_instance_rec.operational_status_code;
8656: END IF;
8657:
8658:
8659: CSI_ITEM_INSTANCES_H_PKG.Update_Row
8660: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
8661: ,p_INSTANCE_ID => fnd_api.g_miss_num
8662: ,p_TRANSACTION_ID => fnd_api.g_miss_num
8663: ,p_OLD_INSTANCE_NUMBER => fnd_api.g_miss_char

Line 9056: CSI_ITEM_INSTANCES_H_PKG.Insert_Row

9052: -- p_instance_rec.OPERATIONAL_STATUS_CODE := l_curr_instance_rec.OPERATIONAL_STATUS_CODE;
9053: -- End addition of columns for FA Integration
9054:
9055: /* Commented out to implement bulk processing.... Bug:5615169
9056: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
9057: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
9058: ,p_INSTANCE_ID => l_rel_tbl(j).subject_id
9059: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
9060: ,p_OLD_INSTANCE_NUMBER => l_curr_instance_rec.INSTANCE_NUMBER

Line 9770: CSI_ITEM_INSTANCES_H_PKG.Insert_Row

9766: l_instance_hist_rec.new_operational_status_code := p_instance_rec.operational_status_code ;
9767: END IF;
9768:
9769: /* Commented to implement bulk operations...Bug:;
9770: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
9771: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
9772: ,p_INSTANCE_ID => l_rel_tbl(j).SUBJECT_ID
9773: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
9774: ,p_OLD_INSTANCE_NUMBER => FND_API.G_MISS_CHAR

Line 10457: INTO CSI_ITEM_INSTANCES_H

10453: l_ciih_blk_ins_cnt := l_inst_hist_rec_tab.instance_history_id.count;
10454: --
10455: FORALL i in 1 .. l_ciih_blk_ins_cnt
10456: INSERT
10457: INTO CSI_ITEM_INSTANCES_H
10458: ( INSTANCE_HISTORY_ID,
10459: INSTANCE_ID,
10460: TRANSACTION_ID,
10461: OLD_INSTANCE_NUMBER,

Line 10988: FROM CSI_ITEM_INSTANCES_H CIIH

10984: CURSOR instance_txn_chk_csr(p_ins_id IN NUMBER,p_txn_id in NUMBER, p_src_txn_date in DATE) IS
10985: SELECT 'X' FROM CSI_TRANSACTIONS CST,
10986: (
10987: SELECT CIIH.TRANSACTION_ID TRANSACTION_ID, CIIH.INSTANCE_ID INSTANCE_ID
10988: FROM CSI_ITEM_INSTANCES_H CIIH
10989: WHERE INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10990: UNION ALL
10991:
10992: SELECT CIVH.TRANSACTION_ID TRANSACTION_ID, CIV.INSTANCE_ID INSTANCE_ID

Line 12140: FROM csi_item_instances_h

12136: -- Begin Add Code for Siebel Genesis Project
12137: ,OLD_SOURCE_CODE
12138: ,NEW_SOURCE_CODE
12139: -- End Add Code for Siebel Genesis Project
12140: FROM csi_item_instances_h
12141: WHERE instance_history_id = p_instance_history_id
12142: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
12143:
12144:

Line 15121: FROM csi_item_instances_h h

15117: -- Start of modification for Bug#2547034 on 09/20/02 - rtalluri
15118: BEGIN
15119: SELECT instance_history_id
15120: INTO l_ins_hist_id
15121: FROM csi_item_instances_h h
15122: WHERE h.transaction_id = p_txn_rec.transaction_id
15123: AND h.instance_id = p_instance_rec.instance_id;
15124:
15125: OPEN ins_hist_csr(l_ins_hist_id);

Line 15131: CSI_ITEM_INSTANCES_H_PKG.Update_Row

15127: CLOSE ins_hist_csr;
15128:
15129: IF l_ins_hist_csr.full_dump_flag = 'Y'
15130: THEN
15131: CSI_ITEM_INSTANCES_H_PKG.Update_Row
15132: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
15133: ,p_INSTANCE_ID => fnd_api.g_miss_num
15134: ,p_TRANSACTION_ID => fnd_api.g_miss_num
15135: ,p_OLD_INSTANCE_NUMBER => fnd_api.g_miss_char

Line 16862: CSI_ITEM_INSTANCES_H_PKG.Update_Row

16858:
16859:
16860:
16861: -- End addition for bug 2671179
16862: CSI_ITEM_INSTANCES_H_PKG.Update_Row
16863: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
16864: ,p_INSTANCE_ID => fnd_api.g_miss_num
16865: ,p_TRANSACTION_ID => fnd_api.g_miss_num
16866: ,p_OLD_INSTANCE_NUMBER => l_ins_hist_csr.OLD_INSTANCE_NUMBER

Line 17412: CSI_ITEM_INSTANCES_H_PKG.Insert_Row

17408: p_instance_rec.OPERATIONAL_STATUS_CODE := l_curr_instance_rec.OPERATIONAL_STATUS_CODE;
17409: END IF;
17410: -- End addition of columns for FA Integration
17411:
17412: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
17413: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
17414: ,p_INSTANCE_ID => p_instance_rec.instance_id
17415: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
17416: ,p_OLD_INSTANCE_NUMBER => l_curr_instance_rec.INSTANCE_NUMBER

Line 18723: CSI_ITEM_INSTANCES_H_PKG.Insert_Row

18719: l_instance_hist_rec.new_operational_status_code := p_instance_rec.operational_status_code ;
18720: END IF;
18721: -- End addition of columns for FA Integration
18722:
18723: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
18724: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
18725: ,p_INSTANCE_ID => p_instance_rec.instance_id
18726: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
18727: ,p_OLD_INSTANCE_NUMBER => l_instance_hist_rec.OLD_INSTANCE_NUMBER

Line 19861: CSI_ITEM_INSTANCES_H_PKG.Insert_Row

19857: -- If the mod value is 0 then dump all the columns both changed and unchanged
19858: -- changed columns have old and new values while the unchanged values have old and new values
19859: -- exactly same
19860:
19861: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
19862: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
19863: ,p_INSTANCE_ID => l_rel_tbl(j).subject_id
19864: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
19865: ,p_OLD_INSTANCE_NUMBER => l_curr_instance_rec.INSTANCE_NUMBER

Line 20082: CSI_ITEM_INSTANCES_H_PKG.Insert_Row

20078: ELSE
20079: -- If the mod value is not equal to zero then dump only the changed columns
20080: -- while the unchanged values have old and new values as null
20081:
20082: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
20083: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
20084: ,p_INSTANCE_ID => l_rel_tbl(j).subject_id
20085: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
20086: ,p_OLD_INSTANCE_NUMBER => FND_API.G_MISS_CHAR

Line 21152: FROM csi_item_instances_h h

21148: -- Added for the bug 6788183
21149: BEGIN
21150: SELECT instance_history_id
21151: INTO l_ins_hist_id
21152: FROM csi_item_instances_h h
21153: WHERE h.transaction_id = p_txn_rec.transaction_id
21154: AND h.instance_id = p_instance_rec.instance_id;
21155:
21156: CSI_ITEM_INSTANCES_H_PKG.Update_Row

Line 21156: CSI_ITEM_INSTANCES_H_PKG.Update_Row

21152: FROM csi_item_instances_h h
21153: WHERE h.transaction_id = p_txn_rec.transaction_id
21154: AND h.instance_id = p_instance_rec.instance_id;
21155:
21156: CSI_ITEM_INSTANCES_H_PKG.Update_Row
21157: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
21158: ,p_INSTANCE_ID => fnd_api.g_miss_num
21159: ,p_TRANSACTION_ID => fnd_api.g_miss_num
21160: ,p_OLD_INSTANCE_NUMBER => fnd_api.g_miss_char

Line 21383: CSI_ITEM_INSTANCES_H_PKG.Insert_Row

21379: IF (l_mod_value = 0) THEN
21380: -- If the mod value is 0 then dump all the columns both changed and unchanged
21381: -- changed columns have old and new values while the unchanged values have old and new values
21382: -- exactly same
21383: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
21384: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
21385: ,p_INSTANCE_ID => p_instance_rec.instance_id
21386: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
21387: ,p_OLD_INSTANCE_NUMBER => l_curr_instance_rec.INSTANCE_NUMBER

Line 21605: CSI_ITEM_INSTANCES_H_PKG.Insert_Row

21601:
21602: ELSE
21603: -- If the mod value is not equal to zero then dump only the changed columns
21604: -- while the unchanged values have old and new values as null
21605: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
21606: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
21607: ,p_INSTANCE_ID => p_instance_rec.instance_id
21608: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
21609: ,p_OLD_INSTANCE_NUMBER => l_instance_rec.INSTANCE_NUMBER

Line 30389: FROM csi_item_instances_h

30385: ,x_msg_data OUT NOCOPY VARCHAR2
30386: ) IS
30387: CURSOR txn_hist_csr (p_txn_id IN NUMBER) IS
30388: SELECT *
30389: FROM csi_item_instances_h
30390: WHERE transaction_id = p_txn_id;
30391:
30392: l_old_ins_header_rec csi_datastructures_pub.instance_header_rec;
30393: l_new_ins_header_rec csi_datastructures_pub.instance_header_rec;