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_DATASTRUCTURES_PUB

Line 19: x_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_header_rec,

15: /* Description : This procudure recontructs the record */
16: /* from the history */
17: /*----------------------------------------------------------*/
18: PROCEDURE Initialize_asset_rec_no_dump (
19: x_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_header_rec,
20: p_inst_asset_id IN NUMBER ,
21: x_no_dump IN OUT NOCOPY DATE)
22: IS
23:

Line 66: x_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_header_rec,

62: /*----------------------------------------------------------*/
63:
64: PROCEDURE Initialize_asset_rec
65: (
66: x_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_header_rec,
67: p_inst_asset_hist_id IN NUMBER ,
68: x_nearest_full_dump IN OUT NOCOPY DATE
69: ) IS
70:

Line 105: px_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec,

101: END Initialize_asset_rec ;
102:
103:
104: PROCEDURE set_fa_sync_flag (
105: px_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec,
106: p_location_id IN NUMBER,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_error_msg OUT NOCOPY VARCHAR2)
109: IS

Line 272: x_instance_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl,

268: /*----------------------------------------------------------*/
269:
270: PROCEDURE Construct_asset_from_hist
271: (
272: x_instance_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl,
273: p_time_stamp IN DATE
274: ) IS
275:
276: l_nearest_full_dump DATE := p_time_stamp;

Line 278: l_instance_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;

274: ) IS
275:
276: l_nearest_full_dump DATE := p_time_stamp;
277: l_inst_asset_history_id NUMBER;
278: l_instance_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
279: l_asset_count NUMBER := 0;
280: --
281: Process_next EXCEPTION;
282:

Line 428: (p_asset_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl)

424: /* id columns */
425: /*----------------------------------------------------------*/
426:
427: PROCEDURE Resolve_id_columns
428: (p_asset_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl)
429:
430: IS
431: l_code_combination_id NUMBER;
432: l_assigned_to NUMBER;

Line 576: x_inst_asset_rec OUT NOCOPY csi_datastructures_pub.instance_asset_header_rec

572:
573: PROCEDURE Get_Asset_Column_Values
574: (
575: p_get_asset_cursor_id IN NUMBER ,
576: x_inst_asset_rec OUT NOCOPY csi_datastructures_pub.instance_asset_header_rec
577: )IS
578: BEGIN
579:
580: dbms_sql.column_value(p_get_asset_cursor_id, 1, x_inst_asset_rec.instance_asset_id);

Line 605: l_inst_asset_rec csi_datastructures_pub.instance_asset_header_rec;

601: (
602: p_get_asset_cursor_id IN NUMBER
603: ) IS
604:
605: l_inst_asset_rec csi_datastructures_pub.instance_asset_header_rec;
606:
607: BEGIN
608:
609: dbms_sql.define_column(p_get_asset_cursor_id, 1, l_inst_asset_rec.instance_asset_id);

Line 630: p_inst_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec,

626: /*----------------------------------------------------------*/
627:
628: PROCEDURE Bind_asset_variable
629: (
630: p_inst_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec,
631: p_get_asset_cursor_id IN NUMBER
632: )IS
633:
634: BEGIN

Line 674: ( p_inst_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec

670: /* cluase for Party relationship */
671: /*----------------------------------------------------------*/
672:
673: PROCEDURE Gen_Asset_Where_Clause
674: ( p_inst_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec
675: ,x_where_clause OUT NOCOPY VARCHAR2
676: ) IS
677:
678: BEGIN

Line 782: ,p_instance_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec

778: p_api_version IN NUMBER
779: ,p_commit IN VARCHAR2
780: ,p_init_msg_list IN VARCHAR2
781: ,p_validation_level IN NUMBER
782: ,p_instance_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec
783: ,p_resolve_id_columns IN VARCHAR2
784: ,p_time_stamp IN DATE
785: ,x_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
786: ,x_return_status OUT NOCOPY VARCHAR2

Line 785: ,x_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl

781: ,p_validation_level IN NUMBER
782: ,p_instance_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec
783: ,p_resolve_id_columns IN VARCHAR2
784: ,p_time_stamp IN DATE
785: ,x_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
786: ,x_return_status OUT NOCOPY VARCHAR2
787: ,x_msg_count OUT NOCOPY NUMBER
788: ,x_msg_data OUT NOCOPY VARCHAR2
789: ) IS

Line 794: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;

790:
791: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_asset';
792: l_api_version CONSTANT NUMBER := 1.0;
793: l_CSI_DEBUG_LEVEL NUMBER;
794: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
795: l_msg_index NUMBER;
796: l_msg_count NUMBER;
797: l_VERSION_LABEL_ID NUMBER := NULL;
798: l_count NUMBER := 0;

Line 802: l_inst_asset_rec csi_datastructures_pub.instance_asset_header_rec ;

798: l_count NUMBER := 0;
799: l_instance_asset_id NUMBER;
800: l_where_clause VARCHAR2(2000) := '' ;
801: l_get_inst_asset_cursor_id NUMBER ;
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 ';

Line 807: l_instance_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;

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
811: /*

Line 992: p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec,

988: p_api_version IN NUMBER,
989: p_commit IN VARCHAR2,
990: p_init_msg_list IN VARCHAR2,
991: p_validation_level IN NUMBER,
992: p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec,
993: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
994: x_return_status OUT NOCOPY VARCHAR2,
995: x_msg_count OUT NOCOPY NUMBER,
996: x_msg_data OUT NOCOPY VARCHAR2,

Line 993: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

989: p_commit IN VARCHAR2,
990: p_init_msg_list IN VARCHAR2,
991: p_validation_level IN NUMBER,
992: p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec,
993: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
994: x_return_status OUT NOCOPY VARCHAR2,
995: x_msg_count OUT NOCOPY NUMBER,
996: x_msg_data OUT NOCOPY VARCHAR2,
997: p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl,

Line 1539: p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec,

1535: p_api_version IN NUMBER,
1536: p_commit IN VARCHAR2,
1537: p_init_msg_list IN VARCHAR2,
1538: p_validation_level IN NUMBER,
1539: p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec,
1540: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1541: x_return_status OUT NOCOPY VARCHAR2,
1542: x_msg_count OUT NOCOPY NUMBER,
1543: x_msg_data OUT NOCOPY VARCHAR2,

Line 1540: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

1536: p_commit IN VARCHAR2,
1537: p_init_msg_list IN VARCHAR2,
1538: p_validation_level IN NUMBER,
1539: p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec,
1540: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1541: x_return_status OUT NOCOPY VARCHAR2,
1542: x_msg_count OUT NOCOPY NUMBER,
1543: x_msg_data OUT NOCOPY VARCHAR2,
1544: p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl,

Line 1561: l_ins_asset_hist_rec csi_datastructures_pub.ins_asset_history_rec;

1557: l_instance_asset_hist_id NUMBER;
1558: l_acct_class_code VARCHAR2(10);
1559: l_exists_flag VARCHAR2(1);
1560: l_valid_flag VARCHAR2(1);
1561: l_ins_asset_hist_rec csi_datastructures_pub.ins_asset_history_rec;
1562: l_creation_complete_flag varchar2(1);
1563: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1564: l_error_message varchar2(2000);
1565:

Line 1953: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

1949: -- Generate the instance asset history id from the sequence
1950: l_instance_asset_hist_id := CSI_Asset_vld_pvt.gen_inst_asset_hist_id;
1951:
1952: -- Get the full_dump_frequency from csi_install_parameter
1953: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
1954: csi_gen_utility_pvt.populate_install_param_rec;
1955: END IF;
1956: --
1957: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;

Line 1957: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;

1953: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
1954: csi_gen_utility_pvt.populate_install_param_rec;
1955: END IF;
1956: --
1957: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
1958: --
1959: IF l_full_dump_frequency IS NULL THEN
1960: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
1961: FND_MSG_PUB.ADD;

Line 2454: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl

2450: ,p_commit IN VARCHAR2
2451: ,p_init_msg_list IN VARCHAR2
2452: ,p_validation_level IN NUMBER
2453: ,p_transaction_id IN NUMBER
2454: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
2455: ,x_return_status OUT NOCOPY VARCHAR2
2456: ,x_msg_count OUT NOCOPY NUMBER
2457: ,x_msg_data OUT NOCOPY VARCHAR2
2458: ) IS

Line 2491: l_old_ins_asset_rec csi_datastructures_pub.instance_asset_header_rec;

2487: AND ah.instance_asset_id = a.instance_asset_id;
2488:
2489: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_asset_hist';
2490: l_api_version CONSTANT NUMBER := 1.0;
2491: l_old_ins_asset_rec csi_datastructures_pub.instance_asset_header_rec;
2492: l_new_ins_asset_rec csi_datastructures_pub.instance_asset_header_rec;
2493: l_old_ins_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
2494: l_new_ins_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
2495: l_ins_asset_rec csi_datastructures_pub.ins_asset_history_rec;

Line 2492: l_new_ins_asset_rec csi_datastructures_pub.instance_asset_header_rec;

2488:
2489: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_asset_hist';
2490: l_api_version CONSTANT NUMBER := 1.0;
2491: l_old_ins_asset_rec csi_datastructures_pub.instance_asset_header_rec;
2492: l_new_ins_asset_rec csi_datastructures_pub.instance_asset_header_rec;
2493: l_old_ins_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
2494: l_new_ins_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
2495: l_ins_asset_rec csi_datastructures_pub.ins_asset_history_rec;
2496: l_temp_asset_rec csi_datastructures_pub.ins_asset_history_rec;

Line 2493: l_old_ins_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;

2489: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_asset_hist';
2490: l_api_version CONSTANT NUMBER := 1.0;
2491: l_old_ins_asset_rec csi_datastructures_pub.instance_asset_header_rec;
2492: l_new_ins_asset_rec csi_datastructures_pub.instance_asset_header_rec;
2493: l_old_ins_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
2494: l_new_ins_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
2495: l_ins_asset_rec csi_datastructures_pub.ins_asset_history_rec;
2496: l_temp_asset_rec csi_datastructures_pub.ins_asset_history_rec;
2497: i NUMBER :=0 ;

Line 2494: l_new_ins_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;

2490: l_api_version CONSTANT NUMBER := 1.0;
2491: l_old_ins_asset_rec csi_datastructures_pub.instance_asset_header_rec;
2492: l_new_ins_asset_rec csi_datastructures_pub.instance_asset_header_rec;
2493: l_old_ins_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
2494: l_new_ins_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
2495: l_ins_asset_rec csi_datastructures_pub.ins_asset_history_rec;
2496: l_temp_asset_rec csi_datastructures_pub.ins_asset_history_rec;
2497: i NUMBER :=0 ;
2498: BEGIN

Line 2495: l_ins_asset_rec csi_datastructures_pub.ins_asset_history_rec;

2491: l_old_ins_asset_rec csi_datastructures_pub.instance_asset_header_rec;
2492: l_new_ins_asset_rec csi_datastructures_pub.instance_asset_header_rec;
2493: l_old_ins_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
2494: l_new_ins_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
2495: l_ins_asset_rec csi_datastructures_pub.ins_asset_history_rec;
2496: l_temp_asset_rec csi_datastructures_pub.ins_asset_history_rec;
2497: i NUMBER :=0 ;
2498: BEGIN
2499: /*

Line 2496: l_temp_asset_rec csi_datastructures_pub.ins_asset_history_rec;

2492: l_new_ins_asset_rec csi_datastructures_pub.instance_asset_header_rec;
2493: l_old_ins_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
2494: l_new_ins_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
2495: l_ins_asset_rec csi_datastructures_pub.ins_asset_history_rec;
2496: l_temp_asset_rec csi_datastructures_pub.ins_asset_history_rec;
2497: i NUMBER :=0 ;
2498: BEGIN
2499: /*
2500: IF fnd_api.to_boolean(p_commit)

Line 3645: p_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,

3641: p_api_version IN number,
3642: p_commit IN varchar2,
3643: p_init_msg_list IN varchar2,
3644: p_validation_level IN number,
3645: p_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
3646: p_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
3647: p_lookup_tbl IN OUT nocopy csi_asset_pvt.lookup_tbl,
3648: p_asset_count_rec IN OUT nocopy csi_asset_pvt.asset_count_rec,
3649: p_asset_id_tbl IN OUT nocopy csi_asset_pvt.asset_id_tbl,

Line 3646: p_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

3642: p_commit IN varchar2,
3643: p_init_msg_list IN varchar2,
3644: p_validation_level IN number,
3645: p_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
3646: p_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
3647: p_lookup_tbl IN OUT nocopy csi_asset_pvt.lookup_tbl,
3648: p_asset_count_rec IN OUT nocopy csi_asset_pvt.asset_count_rec,
3649: p_asset_id_tbl IN OUT nocopy csi_asset_pvt.asset_id_tbl,
3650: p_asset_loc_tbl IN OUT nocopy csi_asset_pvt.asset_loc_tbl,