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.CSE_ASSET_MOVE_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 246: l_txn_rec csi_datastructures_pub.transaction_rec ;

242: x_return_status OUT NOCOPY VARCHAR2,
243: x_error_msg OUT NOCOPY VARCHAR2)
244: IS
245:
246: l_txn_rec csi_datastructures_pub.transaction_rec ;
247: l_dest_txn_processed NUMBER ;
248: l_dest_txn_qty NUMBER ;
249: l_msg_index NUMBER;
250: l_msg_data VARCHAR2(2000);

Line 377: px_txn_rec IN OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_REC,

373: ------------------------------------------------------------------------------------------
374: -- Creates a CSI Transactions record using CSI Private API.
375: ------------------------------------------------------------------------------------------
376: PROCEDURE create_csi_txn(
377: px_txn_rec IN OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_REC,
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_error_message OUT NOCOPY VARCHAR2)
380: IS
381:

Line 432: l_txn_rec csi_datastructures_pub.transaction_rec;

428: l_prorate_convention varchar2(10);
429: l_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;
430: l_sysdate date ;
431: l_unit_cost number;
432: l_txn_rec csi_datastructures_pub.transaction_rec;
433:
434: l_return_status varchar2(1);
435: l_error_msg varchar2(2000);
436:

Line 668: p_inst_asset_rec IN csi_datastructures_pub.instance_asset_rec ,

664: -- If it finds one, it will update else it will create.
665: -- Callers will pass +ve to increment the instance-asset by p_transaction_units or -ve to decrement.
666: -----------------------------------------------------------------------------------------------
667: PROCEDURE update_inst_asset (
668: p_inst_asset_rec IN csi_datastructures_pub.instance_asset_rec ,
669: p_transaction_units IN NUMBER,
670: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
671: x_return_status OUT NOCOPY VARCHAR2,
672: x_error_msg OUT NOCOPY VARCHAR2)

Line 670: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,

666: -----------------------------------------------------------------------------------------------
667: PROCEDURE update_inst_asset (
668: p_inst_asset_rec IN csi_datastructures_pub.instance_asset_rec ,
669: p_transaction_units IN NUMBER,
670: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
671: x_return_status OUT NOCOPY VARCHAR2,
672: x_error_msg OUT NOCOPY VARCHAR2)
673: IS
674:

Line 685: l_dest_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec ;

681: l_time_stamp DATE ;
682: l_sysdate DATE ;
683:
684: --Specific to the API's here
685: l_dest_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec ;
686: l_dest_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
687: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
688: l_dest_asset_tbl cse_datastructures_pub.asset_query_tbl;
689: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;

Line 686: l_dest_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

682: l_sysdate DATE ;
683:
684: --Specific to the API's here
685: l_dest_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec ;
686: l_dest_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
687: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
688: l_dest_asset_tbl cse_datastructures_pub.asset_query_tbl;
689: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;
690: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;

Line 687: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

683:
684: --Specific to the API's here
685: l_dest_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec ;
686: l_dest_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
687: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
688: l_dest_asset_tbl cse_datastructures_pub.asset_query_tbl;
689: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;
690: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;
691: l_lookup_tbl csi_asset_pvt.lookup_tbl ;

Line 695: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;

691: l_lookup_tbl csi_asset_pvt.lookup_tbl ;
692: l_asset_count_rec csi_asset_pvt.asset_count_rec ;
693:
694: ---Local variables only for this spec.
695: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
696: l_csi_txn_rec csi_datastructures_pub.transaction_rec ;
697:
698: CURSOR inst_asset_cur (c_instance_asset_id IN NUMBER) IS
699: SELECT cia.object_version_number

Line 696: l_csi_txn_rec csi_datastructures_pub.transaction_rec ;

692: l_asset_count_rec csi_asset_pvt.asset_count_rec ;
693:
694: ---Local variables only for this spec.
695: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
696: l_csi_txn_rec csi_datastructures_pub.transaction_rec ;
697:
698: CURSOR inst_asset_cur (c_instance_asset_id IN NUMBER) IS
699: SELECT cia.object_version_number
700: FROM csi_i_assets cia

Line 882: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,

878: p_src_fa_inst_dtls_rec IN fa_inst_dtls_rec,
879: p_dest_move_trans_rec IN move_trans_rec,
880: p_dest_fa_dist_rec IN cse_datastructures_pub.distribution_rec,
881: p_transaction_units IN NUMBER,
882: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
883: x_return_status OUT NOCOPY VARCHAR2,
884: x_error_msg OUT NOCOPY VARCHAR2 )
885: IS
886: l_api_version NUMBER ;

Line 903: l_src_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;

899: l_fnd_error VARCHAR2(1);
900: l_asset_attrib_rec CSE_DATASTRUCTURES_PUB.asset_attrib_rec;
901:
902: temp_str VARCHAR2(512);
903: l_src_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
904: l_dest_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
905:
906: e_error EXCEPTION ;
907: l_error_msg VARCHAR2(2000);

Line 904: l_dest_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;

900: l_asset_attrib_rec CSE_DATASTRUCTURES_PUB.asset_attrib_rec;
901:
902: temp_str VARCHAR2(512);
903: l_src_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
904: l_dest_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
905:
906: e_error EXCEPTION ;
907: l_error_msg VARCHAR2(2000);
908:

Line 1067: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,

1063: p_dest_move_trans_rec IN move_trans_rec,
1064: p_dest_fa_rec IN fa_rec,
1065: p_dest_fa_dist_rec IN cse_datastructures_pub.distribution_rec,
1066: p_transaction_units IN NUMBER,
1067: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1068: x_return_status OUT NOCOPY VARCHAR2,
1069: x_error_msg OUT NOCOPY VARCHAR2)
1070: IS
1071: l_return_status VARCHAR2(1);

Line 1193: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec ;

1189:
1190: l_fnd_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
1191: l_fnd_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
1192: l_sysdate DATE := sysdate;
1193: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec ;
1194: l_error_msg VARCHAR2(4000);
1195: l_return_status VARCHAR2(1);
1196: l_valid_to_process VARCHAR2(1);
1197: l_src_move_trans_rec move_trans_rec ;

Line 1212: l_trx_error_rec csi_datastructures_pub.transaction_error_rec ;

1208: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1209: l_msg_index NUMBER;
1210: l_msg_data VARCHAR2(2000);
1211: l_msg_count NUMBER;
1212: l_trx_error_rec csi_datastructures_pub.transaction_error_rec ;
1213: l_txn_error_id NUMBER ;
1214: l_mass_add_rec fa_mass_additions%ROWTYPE ;
1215: l_asset_query_rec cse_datastructures_pub.asset_query_rec ;
1216:

Line 1418: x_instance_rec OUT nocopy csi_datastructures_pub.instance_header_rec,

1414: PROCEDURE get_inst_txn_dtls_srl(
1415: p_instance_id IN number,
1416: p_transaction_id IN number,
1417: p_source_dest_flag IN varchar2 default 'C',
1418: x_instance_rec OUT nocopy csi_datastructures_pub.instance_header_rec,
1419: x_return_status OUT nocopy varchar2)
1420: IS
1421:
1422: l_transaction_id number;

Line 1426: g_inst_rec csi_datastructures_pub.instance_header_rec;

1422: l_transaction_id number;
1423: l_time_stamp date := sysdate;
1424:
1425: -- get instance details variables
1426: g_inst_rec csi_datastructures_pub.instance_header_rec;
1427: g_pty_tbl csi_datastructures_pub.party_header_tbl;
1428: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;
1429: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1430: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1427: g_pty_tbl csi_datastructures_pub.party_header_tbl;

1423: l_time_stamp date := sysdate;
1424:
1425: -- get instance details variables
1426: g_inst_rec csi_datastructures_pub.instance_header_rec;
1427: g_pty_tbl csi_datastructures_pub.party_header_tbl;
1428: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;
1429: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1430: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1431: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 1428: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;

1424:
1425: -- get instance details variables
1426: g_inst_rec csi_datastructures_pub.instance_header_rec;
1427: g_pty_tbl csi_datastructures_pub.party_header_tbl;
1428: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;
1429: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1430: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1431: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1432: g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 1429: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;

1425: -- get instance details variables
1426: g_inst_rec csi_datastructures_pub.instance_header_rec;
1427: g_pty_tbl csi_datastructures_pub.party_header_tbl;
1428: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;
1429: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1430: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1431: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1432: g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1433: g_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 1430: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;

1426: g_inst_rec csi_datastructures_pub.instance_header_rec;
1427: g_pty_tbl csi_datastructures_pub.party_header_tbl;
1428: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;
1429: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1430: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1431: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1432: g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1433: g_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
1434:

Line 1431: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1427: g_pty_tbl csi_datastructures_pub.party_header_tbl;
1428: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;
1429: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1430: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1431: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1432: g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1433: g_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
1434:
1435: l_return_status varchar2(1);

Line 1432: g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

1428: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;
1429: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1430: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1431: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1432: g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1433: g_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
1434:
1435: l_return_status varchar2(1);
1436: l_msg_data varchar2(2000);

Line 1433: g_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;

1429: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1430: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1431: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1432: g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1433: g_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
1434:
1435: l_return_status varchar2(1);
1436: l_msg_data varchar2(2000);
1437: l_msg_count number;

Line 1620: l_src_inst_rec csi_datastructures_pub.instance_header_rec;

1616: l_txn_quantity number;
1617:
1618: l_src_move_tbl cse_asset_move_pkg.move_trans_tbl;
1619: l_dest_move_tbl cse_asset_move_pkg.move_trans_tbl;
1620: l_src_inst_rec csi_datastructures_pub.instance_header_rec;
1621: l_dest_inst_rec csi_datastructures_pub.instance_header_rec;
1622:
1623: s_ind binary_integer := 0;
1624: d_ind binary_integer := 0;

Line 1621: l_dest_inst_rec csi_datastructures_pub.instance_header_rec;

1617:
1618: l_src_move_tbl cse_asset_move_pkg.move_trans_tbl;
1619: l_dest_move_tbl cse_asset_move_pkg.move_trans_tbl;
1620: l_src_inst_rec csi_datastructures_pub.instance_header_rec;
1621: l_dest_inst_rec csi_datastructures_pub.instance_header_rec;
1622:
1623: s_ind binary_integer := 0;
1624: d_ind binary_integer := 0;
1625:

Line 2020: l_txn_rec csi_datastructures_pub.transaction_rec;

2016: l_qty_canbe_process NUMBER;
2017: l_qty_being_process NUMBER;
2018:
2019: l_sysdate DATE := sysdate;
2020: l_txn_rec csi_datastructures_pub.transaction_rec;
2021:
2022: l_src_transaction_id NUMBER;
2023: l_src_fa_inst_dtls_tbl src_fa_inst_dtls_tbl;
2024:

Line 2410: l_txn_rec csi_datastructures_pub.transaction_rec;

2406: p_csi_txn_id IN number,
2407: x_return_status OUT nocopy varchar2,
2408: x_error_message OUT nocopy varchar2)
2409: IS
2410: l_txn_rec csi_datastructures_pub.transaction_rec;
2411: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2412: l_msg_count number;
2413: l_msg_data varchar2(2000);
2414: BEGIN

Line 2464: l_txn_rec csi_datastructures_pub.transaction_rec ;

2460: l_error_msg varchar2(2000);
2461: l_src_txn_object_ver_num number ;
2462: l_dest_txn_qty number ;
2463: l_dest_txn_processed number ;
2464: l_txn_rec csi_datastructures_pub.transaction_rec ;
2465:
2466: CURSOR csi_txn_cur (c_transaction_id IN NUMBER) IS
2467: SELECT object_version_number
2468: FROM csi_transactions

Line 2535: l_src_inst_asset_query_rec csi_datastructures_pub.instance_asset_rec ;

2531: l_cost_api_ver NUMBER ;
2532: l_api_version NUMBER ;
2533: l_src_transaction_id NUMBER;
2534: l_src_transaction_type_id NUMBER;
2535: l_src_inst_asset_query_rec csi_datastructures_pub.instance_asset_rec ;
2536: l_src_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
2537: l_dest_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
2538: l_src_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2539: l_dest_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2536: l_src_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;

2532: l_api_version NUMBER ;
2533: l_src_transaction_id NUMBER;
2534: l_src_transaction_type_id NUMBER;
2535: l_src_inst_asset_query_rec csi_datastructures_pub.instance_asset_rec ;
2536: l_src_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
2537: l_dest_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
2538: l_src_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2539: l_dest_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2540: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 2537: l_dest_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;

2533: l_src_transaction_id NUMBER;
2534: l_src_transaction_type_id NUMBER;
2535: l_src_inst_asset_query_rec csi_datastructures_pub.instance_asset_rec ;
2536: l_src_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
2537: l_dest_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
2538: l_src_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2539: l_dest_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2540: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2541: l_dest_num_of_rows NUMBER;

Line 2538: l_src_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

2534: l_src_transaction_type_id NUMBER;
2535: l_src_inst_asset_query_rec csi_datastructures_pub.instance_asset_rec ;
2536: l_src_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
2537: l_dest_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
2538: l_src_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2539: l_dest_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2540: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2541: l_dest_num_of_rows NUMBER;
2542: l_dest_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec ;

Line 2539: l_dest_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

2535: l_src_inst_asset_query_rec csi_datastructures_pub.instance_asset_rec ;
2536: l_src_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
2537: l_dest_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
2538: l_src_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2539: l_dest_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2540: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2541: l_dest_num_of_rows NUMBER;
2542: l_dest_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec ;
2543: l_dest_transaction_type_id NUMBER;

Line 2540: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

2536: l_src_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
2537: l_dest_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
2538: l_src_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2539: l_dest_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2540: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2541: l_dest_num_of_rows NUMBER;
2542: l_dest_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec ;
2543: l_dest_transaction_type_id NUMBER;
2544: l_dest_asset_query_rec cse_datastructures_pub.asset_query_rec ;

Line 2542: l_dest_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec ;

2538: l_src_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2539: l_dest_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2540: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2541: l_dest_num_of_rows NUMBER;
2542: l_dest_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec ;
2543: l_dest_transaction_type_id NUMBER;
2544: l_dest_asset_query_rec cse_datastructures_pub.asset_query_rec ;
2545: e_goto_next_trans EXCEPTION;
2546: l_commit VARCHAR2(1) ;

Line 2550: l_txn_rec csi_datastructures_pub.transaction_rec ;

2546: l_commit VARCHAR2(1) ;
2547: l_init_msg_list VARCHAR2(1) ;
2548: l_validation_level NUMBER ;
2549: l_msg_data VARCHAR2(2000);
2550: l_txn_rec csi_datastructures_pub.transaction_rec ;
2551: j PLS_INTEGER;
2552: i PLS_INTEGER;
2553: l_msg_index NUMBER;
2554: l_msg_count NUMBER;

Line 2557: l_trx_error_rec csi_datastructures_pub.transaction_error_rec;

2553: l_msg_index NUMBER;
2554: l_msg_count NUMBER;
2555:
2556: l_serial_move_type VARCHAR2(20) ;
2557: l_trx_error_rec csi_datastructures_pub.transaction_error_rec;
2558: l_txn_error_id NUMBER ;
2559: l_api_name VARCHAR2(100) ;
2560: l_sysdate DATE ;
2561: l_time_stamp DATE ;

Line 3370: l_dest_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;

3366: 'INTERORG_DIRECT_SHIP',
3367: 'ISO_DIRECT_SHIP') ;
3368:
3369: l_sysdate DATE ;
3370: l_dest_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
3371: l_txn_rec csi_datastructures_pub.transaction_rec ;
3372: l_msg_index NUMBER;
3373: l_msg_count NUMBER;
3374: l_msg_data VARCHAR2(2000);

Line 3371: l_txn_rec csi_datastructures_pub.transaction_rec ;

3367: 'ISO_DIRECT_SHIP') ;
3368:
3369: l_sysdate DATE ;
3370: l_dest_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
3371: l_txn_rec csi_datastructures_pub.transaction_rec ;
3372: l_msg_index NUMBER;
3373: l_msg_count NUMBER;
3374: l_msg_data VARCHAR2(2000);
3375: l_return_status VARCHAR2(1);

Line 3377: l_trx_error_rec csi_datastructures_pub.transaction_error_rec;

3373: l_msg_count NUMBER;
3374: l_msg_data VARCHAR2(2000);
3375: l_return_status VARCHAR2(1);
3376: l_error_msg VARCHAR2(2000);
3377: l_trx_error_rec csi_datastructures_pub.transaction_error_rec;
3378: i NUMBER ;
3379: j NUMBER ;
3380: l_src_move_trans_tbl move_trans_tbl ;
3381: l_dest_move_trans_tbl move_trans_tbl ;

Line 4148: l_error_rec csi_datastructures_pub.transaction_error_rec;

4144: PROCEDURE log_error(
4145: p_txn_context IN txn_context,
4146: p_error_message IN varchar2)
4147: IS
4148: l_error_rec csi_datastructures_pub.transaction_error_rec;
4149: l_error_id number;
4150: l_source_type varchar2(20);
4151: l_error_message varchar2(2000);
4152:

Line 4315: l_csi_txn_rec csi_datastructures_pub.transaction_rec ;

4311: l_txn_action varchar2(20);
4312: l_return_status varchar2(1);
4313: l_error_message varchar2(2000);
4314:
4315: l_csi_txn_rec csi_datastructures_pub.transaction_rec ;
4316:
4317: ---For Public API's
4318: l_api_name varchar2(100);
4319: l_api_version number;