APPS.CSI_ASSET_PVT dependencies on CSI_I_ASSETS_H

Line 37: FROM CSI_I_ASSETS_H

33: NEW_ACTIVE_START_DATE,
34: NEW_ACTIVE_END_DATE,
35: FULL_DUMP_FLAG,
36: OBJECT_VERSION_NUMBER
37: FROM CSI_I_ASSETS_H
38: WHERE instance_asset_id = p_inst_ass_id
39: ORDER by creation_date;
40:
41: BEGIN

Line 85: FROM CSI_I_ASSETS_H

81: NEW_ACTIVE_START_DATE ,
82: NEW_ACTIVE_END_DATE ,
83: FULL_DUMP_FLAG ,
84: OBJECT_VERSION_NUMBER
85: FROM CSI_I_ASSETS_H
86: WHERE instance_asset_history_id = p_inst_ass_hist_id
87: and full_dump_flag = 'Y' ;
88:
89: BEGIN

Line 287: FROM CSI_I_ASSETS_H

283:
284: CURSOR get_nearest_full_dump(p_asset_id IN NUMBER ,p_time IN DATE) IS
285: SELECT
286: MAX(instance_asset_history_id)
287: FROM CSI_I_ASSETS_H
288: WHERE creation_date <= p_time
289: and instance_asset_id = p_asset_id
290: and full_dump_flag = 'Y';
291:

Line 316: FROM CSI_I_ASSETS_H

312: NEW_ACTIVE_START_DATE ,
313: OLD_ACTIVE_END_DATE ,
314: NEW_ACTIVE_END_DATE ,
315: OBJECT_VERSION_NUMBER
316: FROM CSI_I_ASSETS_H
317: WHERE creation_date <= p_time
318: and creation_date >= p_nearest_full_dump
319: and instance_asset_id = p_asset_id
320: ORDER BY creation_date;

Line 1439: CSI_I_ASSETS_H_PKG.Insert_Row (

1435:
1436: -- Generate the instance asset history id from the sequence
1437: l_instance_asset_hist_id := CSI_Asset_vld_pvt.gen_inst_asset_hist_id;
1438: -- Call table handlers to insert into history table
1439: CSI_I_ASSETS_H_PKG.Insert_Row (
1440: px_INSTANCE_ASSET_HISTORY_ID => l_instance_asset_hist_id,
1441: p_INSTANCE_ASSET_ID => p_instance_asset_rec.INSTANCE_ASSET_ID,
1442: p_TRANSACTION_ID => p_txn_rec.transaction_id,
1443: p_OLD_INSTANCE_ID => NULL,

Line 1589: FROM csi_i_assets_h

1585: l_temp_inst_asset_rec get_curr_asset_rec%ROWTYPE;
1586:
1587: CURSOR asset_hist_csr (p_asset_hist_id NUMBER) IS
1588: SELECT *
1589: FROM csi_i_assets_h
1590: WHERE csi_i_assets_h.instance_asset_history_id = p_asset_hist_id
1591: FOR UPDATE NOWAIT;
1592:
1593: l_asset_hist_csr asset_hist_csr%ROWTYPE;

Line 1590: WHERE csi_i_assets_h.instance_asset_history_id = p_asset_hist_id

1586:
1587: CURSOR asset_hist_csr (p_asset_hist_id NUMBER) IS
1588: SELECT *
1589: FROM csi_i_assets_h
1590: WHERE csi_i_assets_h.instance_asset_history_id = p_asset_hist_id
1591: FOR UPDATE NOWAIT;
1592:
1593: l_asset_hist_csr asset_hist_csr%ROWTYPE;
1594: l_asset_hist_id NUMBER;

Line 1984: FROM csi_i_assets_h h

1980: -- Start of modification for Bug#2547034 on 09/20/02 - rtalluri
1981: BEGIN
1982: SELECT instance_asset_history_id
1983: INTO l_asset_hist_id
1984: FROM csi_i_assets_h h
1985: WHERE h.transaction_id = p_txn_rec.transaction_id
1986: AND h.instance_asset_id = p_instance_asset_rec.instance_asset_id;
1987:
1988: OPEN asset_hist_csr(l_asset_hist_id);

Line 1993: CSI_I_ASSETS_H_PKG.Update_Row (

1989: FETCH asset_hist_csr INTO l_asset_hist_csr ;
1990: CLOSE asset_hist_csr;
1991:
1992: IF l_asset_hist_csr.full_dump_flag = 'Y' THEN
1993: CSI_I_ASSETS_H_PKG.Update_Row (
1994: p_INSTANCE_ASSET_HISTORY_ID => l_asset_hist_id,
1995: p_INSTANCE_ASSET_ID => fnd_api.g_miss_num,
1996: p_TRANSACTION_ID => fnd_api.g_miss_num,
1997: p_OLD_INSTANCE_ID => fnd_api.g_miss_num,

Line 2150: csi_i_assets_h_pkg.update_row (

2146: l_asset_hist_csr.new_active_end_date := l_temp_inst_asset_rec.active_end_date;
2147: END IF;
2148:
2149:
2150: csi_i_assets_h_pkg.update_row (
2151: p_instance_asset_history_id => l_asset_hist_id ,
2152: p_instance_asset_id => fnd_api.g_miss_num ,
2153: p_transaction_id => fnd_api.g_miss_num ,
2154: p_old_instance_id => l_asset_hist_csr.old_instance_id ,

Line 2221: CSI_I_ASSETS_H_PKG.Insert_Row

2217: l_temp_inst_asset_rec.UPDATE_STATUS := l_curr_asset_rec.UPDATE_STATUS ;
2218: END IF;
2219:
2220: -- Call table handlers to insert into history table
2221: CSI_I_ASSETS_H_PKG.Insert_Row
2222: (
2223: px_INSTANCE_ASSET_HISTORY_ID => l_instance_asset_hist_id ,
2224: p_INSTANCE_ASSET_ID => p_instance_asset_rec.INSTANCE_ASSET_ID ,
2225: p_TRANSACTION_ID => p_txn_rec.transaction_id ,

Line 2335: CSI_I_ASSETS_H_PKG.Insert_Row (

2331: END IF;
2332: --
2333:
2334: -- Call table handlers to insert into history table
2335: CSI_I_ASSETS_H_PKG.Insert_Row (
2336: px_INSTANCE_ASSET_HISTORY_ID => l_instance_asset_hist_id ,
2337: p_INSTANCE_ASSET_ID => p_instance_asset_rec.INSTANCE_ASSET_ID ,
2338: p_TRANSACTION_ID => p_txn_rec.transaction_id ,
2339: p_OLD_INSTANCE_ID => l_ins_asset_hist_rec.old_INSTANCE_ID ,

Line 2484: FROM csi_i_assets_h ah,

2480: ah.NEW_ACTIVE_START_DATE ,
2481: ah.OLD_ACTIVE_END_DATE ,
2482: ah.NEW_ACTIVE_END_DATE ,
2483: a.INSTANCE_ID
2484: FROM csi_i_assets_h ah,
2485: csi_i_assets a
2486: WHERE ah.transaction_id = p_txn_id
2487: AND ah.instance_asset_id = a.instance_asset_id;
2488: