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_I_VERSION_LABELS

Line 3285: ' UNION SELECT a.instance_id FROM csi_i_version_labels a, csi_i_version_labels_h b '||

3281: ' UNION SELECT a.instance_id FROM csi_i_org_assignments a, csi_i_org_assignments_h b '||
3282: ' WHERE a.instance_ou_id = b.instance_ou_id and b.transaction_id = :p_transaction_id '||
3283: ' UNION SELECT a.instance_id FROM csi_i_pricing_attribs a , csi_i_pricing_attribs_h b '||
3284: ' WHERE a.pricing_attribute_id = b.pricing_attribute_id and b.transaction_id = :p_transaction_id '||
3285: ' UNION SELECT a.instance_id FROM csi_i_version_labels a, csi_i_version_labels_h b '||
3286: ' WHERE a.version_label_id = b.version_label_id and b.transaction_id = :p_transaction_id '||
3287: ' UNION SELECT a.instance_id FROM csi_item_instances a, csi_systems_b b, csi_systems_h c '||
3288: ' WHERE a.system_id = b.system_id and b.system_id = c.system_id and c.transaction_id = :p_transaction_id ';
3289:

Line 11036: FROM CSI_I_VERSION_LABELS_H CIVLH, CSI_I_VERSION_LABELS CIVL

11032: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11033: UNION ALL
11034:
11035: SELECT CIVLH.TRANSACTION_ID TRANSACTION_ID, CIVL.INSTANCE_ID INSTANCE_ID
11036: FROM CSI_I_VERSION_LABELS_H CIVLH, CSI_I_VERSION_LABELS CIVL
11037: WHERE CIVLH.VERSION_LABEL_ID = CIVL.VERSION_LABEL_ID
11038: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11039: UNION ALL
11040:

Line 23027: FROM CSI_I_VERSION_LABELS_H

23023: NEW_ATTRIBUTE12 ,
23024: NEW_ATTRIBUTE13 ,
23025: NEW_ATTRIBUTE14 ,
23026: NEW_ATTRIBUTE15
23027: FROM CSI_I_VERSION_LABELS_H
23028: WHERE version_label_id = p_ver_label_id
23029: ORDER BY creation_date;
23030:
23031:

Line 23103: FROM CSI_I_VERSION_LABELS_H

23099: NEW_ATTRIBUTE12 ,
23100: NEW_ATTRIBUTE13 ,
23101: NEW_ATTRIBUTE14 ,
23102: NEW_ATTRIBUTE15
23103: FROM CSI_I_VERSION_LABELS_H
23104: WHERE version_label_history_id = p_ver_label_hist_id
23105: and full_dump_flag = 'Y' ;
23106:
23107: BEGIN

Line 23154: FROM CSI_I_VERSION_LABELS_H

23150:
23151: CURSOR get_nearest_full_dump(p_ver_label_id IN NUMBER ,p_time IN DATE) IS
23152: SELECT
23153: MAX(version_label_history_id)
23154: FROM CSI_I_VERSION_LABELS_H
23155: WHERE creation_date <= p_time
23156: and version_label_id = p_ver_label_id
23157: and full_dump_flag = 'Y' ;
23158:

Line 23205: FROM CSI_I_VERSION_LABELS_H

23201: OLD_ATTRIBUTE14 ,
23202: NEW_ATTRIBUTE14 ,
23203: OLD_ATTRIBUTE15 ,
23204: NEW_ATTRIBUTE15
23205: FROM CSI_I_VERSION_LABELS_H
23206: WHERE creation_date <= p_time
23207: and creation_date >= p_nearest_full_dump
23208: and version_label_id = p_ver_label_id
23209: ORDER BY creation_date;

Line 23726: CSI_I_VERSION_LABELS_PKG.Insert_Row(

23722: RAISE FND_API.G_EXC_ERROR;
23723: END IF;
23724: END IF;
23725: -- call the Table handlers to insert the record
23726: CSI_I_VERSION_LABELS_PKG.Insert_Row(
23727: p_VERSION_LABEL_ID => p_version_label_rec.VERSION_LABEL_ID,
23728: p_INSTANCE_ID => p_version_label_rec.instance_id ,
23729: p_VERSION_LABEL => p_version_label_rec.version_label,
23730: p_DATE_TIME_STAMP => p_version_label_rec.date_time_stamp,

Line 23789: CSI_I_VERSION_LABELS_H_PKG.Insert_Row

23785: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;
23786:
23787: -- Call the table handlers to insert into history table
23788:
23789: CSI_I_VERSION_LABELS_H_PKG.Insert_Row
23790: (
23791: px_VERSION_LABEL_HISTORY_ID => l_version_label_hist_id ,
23792: p_VERSION_LABEL_ID => p_version_label_rec.VERSION_LABEL_ID ,
23793: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 23955: FROM CSI_I_VERSION_LABELS

23951: object_version_number -- ,
23952: -- null parent_tbl_index ,
23953: -- null processed_flag ,
23954: -- null interface_id
23955: FROM CSI_I_VERSION_LABELS
23956: WHERE VERSION_LABEL_ID = p_ver_label_id
23957: AND (( ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))
23958: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
23959:

Line 23962: FROM csi_i_version_labels_h

23958: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
23959:
23960: CURSOR version_hist_csr (p_version_hist_id NUMBER) IS
23961: SELECT *
23962: FROM csi_i_version_labels_h
23963: WHERE csi_i_version_labels_h.version_label_history_id = p_version_hist_id
23964: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
23965: l_version_hist_csr version_hist_csr%ROWTYPE;
23966: l_version_hist_id NUMBER;

Line 23963: WHERE csi_i_version_labels_h.version_label_history_id = p_version_hist_id

23959:
23960: CURSOR version_hist_csr (p_version_hist_id NUMBER) IS
23961: SELECT *
23962: FROM csi_i_version_labels_h
23963: WHERE csi_i_version_labels_h.version_label_history_id = p_version_hist_id
23964: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
23965: l_version_hist_csr version_hist_csr%ROWTYPE;
23966: l_version_hist_id NUMBER;
23967: BEGIN

Line 24050: CSI_I_VERSION_LABELS_PKG.Update_Row

24046:
24047: -- Increment the object_version_number before updating
24048: l_OBJECT_VERSION_NUMBER := l_curr_ver_label_rec.OBJECT_VERSION_NUMBER + 1 ;
24049:
24050: CSI_I_VERSION_LABELS_PKG.Update_Row
24051: (
24052: p_VERSION_LABEL_ID => p_version_label_rec.version_label_id,
24053: p_INSTANCE_ID => p_version_label_rec.instance_id,
24054: p_VERSION_LABEL => p_version_label_rec.VERSION_LABEL,

Line 24134: FROM csi_i_version_labels_h h

24130: -- Start of modification for Bug#2547034 on 09/20/02 - rtalluri
24131: BEGIN
24132: SELECT version_label_history_id
24133: INTO l_version_hist_id
24134: FROM csi_i_version_labels_h h
24135: WHERE h.transaction_id = p_txn_rec.transaction_id
24136: AND h.version_label_id = p_version_label_rec.version_label_id;
24137:
24138: OPEN version_hist_csr(l_version_hist_id);

Line 24144: CSI_I_VERSION_LABELS_H_PKG.Update_Row

24140: CLOSE version_hist_csr;
24141:
24142: IF l_version_hist_csr.full_dump_flag = 'Y'
24143: THEN
24144: CSI_I_VERSION_LABELS_H_PKG.Update_Row
24145: (
24146: p_VERSION_LABEL_HISTORY_ID => l_version_hist_id ,
24147: p_VERSION_LABEL_ID => fnd_api.g_miss_num ,
24148: p_TRANSACTION_ID => fnd_api.g_miss_num ,

Line 24517: csi_i_version_labels_h_pkg.update_row

24513: l_version_hist_csr.new_attribute15 := p_version_label_rec.attribute15;
24514: END IF;
24515: --
24516:
24517: csi_i_version_labels_h_pkg.update_row
24518: (
24519: p_version_label_history_id => l_version_hist_id ,
24520: p_version_label_id => fnd_api.g_miss_num ,
24521: p_transaction_id => fnd_api.g_miss_num ,

Line 24646: CSI_I_VERSION_LABELS_H_PKG.Insert_Row

24642: END IF;
24643:
24644: -- Call the table handlers to insert into history table
24645:
24646: CSI_I_VERSION_LABELS_H_PKG.Insert_Row
24647: (
24648: px_VERSION_LABEL_HISTORY_ID => l_version_label_hist_id ,
24649: p_VERSION_LABEL_ID => p_version_label_rec.VERSION_LABEL_ID ,
24650: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 24917: CSI_I_VERSION_LABELS_H_PKG.Insert_Row

24913: l_ver_label_hist_rec.new_attribute15 := p_version_label_rec.attribute15 ;
24914: END IF;
24915:
24916: -- Call the table handlers to insert into history table
24917: CSI_I_VERSION_LABELS_H_PKG.Insert_Row
24918: (
24919: px_VERSION_LABEL_HISTORY_ID => l_version_label_hist_id ,
24920: p_VERSION_LABEL_ID => p_version_label_rec.VERSION_LABEL_ID ,
24921: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 25081: FROM CSI_I_VERSION_LABELS

25077: object_version_number --,
25078: -- null parent_tbl_index ,
25079: -- null processed_flag ,
25080: -- null interface_id
25081: FROM CSI_I_VERSION_LABELS
25082: WHERE VERSION_LABEL_ID = p_ver_label_id
25083: AND (( ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))
25084: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
25085:

Line 25169: CSI_I_VERSION_LABELS_PKG.Update_Row(

25165:
25166: -- Increment the object_version_number before updating
25167: l_OBJECT_VERSION_NUMBER := l_curr_ver_label_rec.OBJECT_VERSION_NUMBER + 1 ;
25168:
25169: CSI_I_VERSION_LABELS_PKG.Update_Row(
25170: p_VERSION_LABEL_ID => p_version_label_rec.version_label_id,
25171: p_INSTANCE_ID => l_version_label_rec.instance_id,
25172: p_VERSION_LABEL => l_version_label_rec.VERSION_LABEL,
25173: p_DATE_TIME_STAMP => l_version_label_rec.DATE_TIME_STAMP,

Line 25251: CSI_I_VERSION_LABELS_H_PKG.Insert_Row

25247: -- changed columns have old and new values while the unchanged values have old and new values
25248: -- exactly same
25249:
25250: -- Call the table handlers to insert into history table
25251: CSI_I_VERSION_LABELS_H_PKG.Insert_Row
25252: (
25253: px_VERSION_LABEL_HISTORY_ID => l_version_label_hist_id ,
25254: p_VERSION_LABEL_ID => p_version_label_rec.version_label_id ,
25255: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 25312: CSI_I_VERSION_LABELS_H_PKG.Insert_Row

25308: -- If the mod value is not equal to zero then dump only the changed columns
25309: -- while the unchanged values have old and new values as null
25310:
25311: -- Call the table handlers to insert into history table
25312: CSI_I_VERSION_LABELS_H_PKG.Insert_Row
25313: (
25314: px_VERSION_LABEL_HISTORY_ID => l_version_label_hist_id ,
25315: p_VERSION_LABEL_ID => p_version_label_rec.version_label_id ,
25316: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 34921: FROM csi_i_version_labels_h vlh,

34917: vlh.NEW_ATTRIBUTE15 ,
34918: vlh.FULL_DUMP_FLAG ,
34919: vlh.OBJECT_VERSION_NUMBER,
34920: vl.INSTANCE_ID
34921: FROM csi_i_version_labels_h vlh,
34922: csi_i_version_labels vl
34923: WHERE vlh.transaction_id = i_transaction_id
34924: AND vlh.version_label_id = vl.version_label_id;
34925:

Line 34922: csi_i_version_labels vl

34918: vlh.FULL_DUMP_FLAG ,
34919: vlh.OBJECT_VERSION_NUMBER,
34920: vl.INSTANCE_ID
34921: FROM csi_i_version_labels_h vlh,
34922: csi_i_version_labels vl
34923: WHERE vlh.transaction_id = i_transaction_id
34924: AND vlh.version_label_id = vl.version_label_id;
34925:
34926:

Line 35281: FROM csi_i_version_labels cv,

35277: CURSOR c_ver_csr (p_txn_id NUMBER) IS
35278: SELECT cv.version_label_id version_label_id
35279: ,cv.object_version_number object_version_number
35280: ,cv.instance_id instance_id
35281: FROM csi_i_version_labels cv,
35282: csi_i_version_labels_h ch
35283: WHERE cv.version_label_id=ch.version_label_id
35284: AND ch.transaction_id=p_txn_id;
35285: l_sysdate DATE :=SYSDATE;

Line 35282: csi_i_version_labels_h ch

35278: SELECT cv.version_label_id version_label_id
35279: ,cv.object_version_number object_version_number
35280: ,cv.instance_id instance_id
35281: FROM csi_i_version_labels cv,
35282: csi_i_version_labels_h ch
35283: WHERE cv.version_label_id=ch.version_label_id
35284: AND ch.transaction_id=p_txn_id;
35285: l_sysdate DATE :=SYSDATE;
35286: l_return_status VARCHAR2(1);