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_ASSET_PVT dependencies on CSI_I_ASSETS

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 145: FROM csi_i_assets cia

141: AND fdh.location_id = px_instance_asset_rec.fa_location_id ;
142:
143: CURSOR synced_fa_loc_units_cur IS
144: SELECT SUM(cia.asset_quantity)
145: FROM csi_i_assets cia
146: WHERE cia.fa_asset_id = px_instance_asset_rec.fa_asset_id
147: AND cia.fa_location_id = px_instance_asset_rec.fa_location_id
148: AND cia.asset_quantity > 0
149: AND sysdate between nvl(cia.active_start_date, sysdate-1) and nvl(cia.active_end_date, sysdate+1)

Line 155: FROM csi_i_assets cia

151: AND cia.fa_sync_flag = 'Y' ;
152:
153: CURSOR inst_sync_over_cur IS
154: SELECT cia.fa_sync_flag
155: FROM csi_i_assets cia
156: WHERE cia.fa_asset_id = px_instance_asset_rec.fa_asset_id
157: AND cia.fa_location_id = px_instance_asset_rec.fa_location_id
158: AND cia.instance_id = px_instance_asset_rec.instance_id
159: AND cia.asset_quantity > 0

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 806: ' OBJECT_VERSION_NUMBER FROM CSI_I_ASSETS ';

802: l_inst_asset_rec csi_datastructures_pub.instance_asset_header_rec ;
803: l_rows_processed NUMBER ;
804: l_select_stmt VARCHAR2(20000):= ' SELECT INSTANCE_ASSET_ID,INSTANCE_ID,FA_ASSET_ID,FA_BOOK_TYPE_CODE '||
805: ' ,FA_LOCATION_ID,ASSET_QUANTITY,UPDATE_STATUS,ACTIVE_START_DATE,ACTIVE_END_DATE , '||
806: ' OBJECT_VERSION_NUMBER FROM CSI_I_ASSETS ';
807: l_instance_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
808:
809: BEGIN
810: -- Standard Start of API savepoint

Line 1104: FROM csi_i_assets

1100: SELECT instance_asset_id,
1101: object_version_number
1102: INTO p_instance_asset_rec.instance_asset_id,
1103: p_instance_asset_rec.object_version_number
1104: FROM csi_i_assets
1105: WHERE instance_id = p_instance_asset_rec.instance_id
1106: and fa_asset_id = p_instance_asset_rec.fa_asset_id
1107: and fa_book_type_code = p_instance_asset_rec.fa_book_type_code
1108: AND fa_location_id = p_instance_asset_rec.fa_location_id

Line 1392: -- Call table handler to insert into csi_i_assets table

1388: END IF;
1389: END IF;
1390: END IF;
1391:
1392: -- Call table handler to insert into csi_i_assets table
1393: IF p_called_from_grp <> FND_API.G_TRUE THEN
1394: CSI_I_ASSETS_PKG.Insert_Row (
1395: px_INSTANCE_ASSET_ID => p_instance_asset_rec.INSTANCE_ASSET_ID,
1396: p_INSTANCE_ID => p_instance_asset_rec.INSTANCE_ID,

Line 1394: CSI_I_ASSETS_PKG.Insert_Row (

1390: END IF;
1391:
1392: -- Call table handler to insert into csi_i_assets table
1393: IF p_called_from_grp <> FND_API.G_TRUE THEN
1394: CSI_I_ASSETS_PKG.Insert_Row (
1395: px_INSTANCE_ASSET_ID => p_instance_asset_rec.INSTANCE_ASSET_ID,
1396: p_INSTANCE_ID => p_instance_asset_rec.INSTANCE_ID,
1397: p_FA_ASSET_ID => p_instance_asset_rec.FA_ASSET_ID,
1398: p_FA_BOOK_TYPE_CODE => p_instance_asset_rec.FA_BOOK_TYPE_CODE,

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 1580: FROM csi_i_assets

1576: creation_complete_flag,
1577: active_start_date,
1578: active_end_date,
1579: object_version_number
1580: FROM csi_i_assets
1581: WHERE INSTANCE_ASSET_ID = p_inst_asset_id
1582: FOR UPDATE OF object_version_number ;
1583:
1584: l_curr_asset_rec get_curr_asset_rec%ROWTYPE;

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 1675: -- Validate the Instance asset id exists in csi_i_assets

1671: CLOSE get_curr_asset_rec;
1672: --
1673: p_instance_asset_rec.instance_id := l_curr_asset_rec.instance_id;
1674: --
1675: -- Validate the Instance asset id exists in csi_i_assets
1676: IF NOT( CSI_Asset_vld_pvt.Is_Inst_asset_id_valid (p_instance_asset_rec.INSTANCE_ASSET_ID)) THEN
1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;
1679:

Line 1897: CSI_I_ASSETS_PKG.Update_Row (

1893:
1894: -- Increment the object_version_number before updating
1895: l_OBJECT_VERSION_NUMBER := l_curr_asset_rec.OBJECT_VERSION_NUMBER + 1 ;
1896:
1897: CSI_I_ASSETS_PKG.Update_Row (
1898: p_INSTANCE_ASSET_ID => p_instance_asset_rec.instance_asset_id,
1899: p_INSTANCE_ID => p_instance_asset_rec.INSTANCE_ID,
1900: p_FA_ASSET_ID => p_instance_asset_rec.FA_ASSET_ID,
1901: p_FA_BOOK_TYPE_CODE => p_instance_asset_rec.FA_BOOK_TYPE_CODE,

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:

Line 2485: csi_i_assets a

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:
2489: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_asset_hist';

Line 3002: FROM csi_item_instances a, csi_i_assets b

2998: l_dup_flag BOOLEAN;
2999:
3000: CURSOR c_item_instances ( p_fa_asset_id NUMBER, p_fa_location_id NUMBER) IS
3001: SELECT a.instance_id,null inst_interface_id, a.quantity, a.location_id ,a.location_type_code
3002: FROM csi_item_instances a, csi_i_assets b
3003: WHERE a.instance_id = b.instance_id
3004: AND b.fa_asset_id = p_fa_asset_id
3005: AND b.fa_location_id = p_fa_location_id ;
3006:

Line 3019: FROM csi_item_instances a, csi_i_assets b

3015: AND a.process_status IN ('R','X')
3016: AND a.source_system_name = nvl(p_source_system_name ,a.source_system_name)
3017: UNION ALL
3018: SELECT a.instance_id,null inst_interface_id, a.quantity, a.location_id ,a.location_type_code
3019: FROM csi_item_instances a, csi_i_assets b
3020: WHERE a.instance_id = b.instance_id
3021: AND b.fa_asset_id = p_fa_asset_id
3022: AND b.fa_location_id = p_fa_location_id
3023: AND NOT EXISTS ( SELECT 1 FROM csi_instance_interface c

Line 3172: FROM csi_item_instances a, csi_i_assets b

3168: l_sql_stmt VARCHAR2(32767) ;
3169: l_asset_cnt NUMBER;
3170: CURSOR c_instance_assets( p_instance_id NUMBER ) IS
3171: SELECT b.fa_asset_id,b.fa_location_id, b.asset_quantity
3172: FROM csi_item_instances a, csi_i_assets b
3173: WHERE a.instance_id = b.instance_id
3174: AND a.instance_id = p_instance_id ;
3175:
3176: CURSOR c_interface_assets( p_instance_id NUMBER

Line 3189: FROM csi_item_instances a, csi_i_assets b

3185: OR a.inst_interface_id = p_interface_id )
3186: AND a.source_system_name = nvl(p_source_system_name,a.source_system_name)
3187: UNION ALL
3188: SELECT b.fa_asset_id,b.fa_location_id, b.asset_quantity
3189: FROM csi_item_instances a, csi_i_assets b
3190: WHERE a.instance_id = b.instance_id
3191: AND a.instance_id = p_instance_id
3192: AND NOT EXISTS ( SELECT 1
3193: FROM csi_i_asset_interface c,