DBA Data[Home] [Help]

APPS.CSE_FAC_INSERVICE_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 27: l_txn_rec csi_datastructures_pub.transaction_rec;

23: p_csi_txn_id IN number,
24: x_return_status OUT nocopy varchar2,
25: x_error_message OUT nocopy varchar2)
26: IS
27: l_txn_rec csi_datastructures_pub.transaction_rec;
28: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
29: l_msg_count number;
30: l_msg_data varchar2(2000);
31: BEGIN

Line 90: l_txn_error_rec csi_datastructures_pub.transaction_error_rec;

86: l_Task_Id_in NUMBER;
87:
88: l_depreciable VARCHAR2(1);
89: l_txn_error_id number;
90: l_txn_error_rec csi_datastructures_pub.transaction_error_rec;
91: l_in_srv_pa_attr_rec cse_datastructures_pub.proj_itm_insv_pa_attr_rec_type;
92:
93: CURSOR project_id_cur(p_project_num IN VARCHAR2) IS
94: SELECT project_id

Line 435: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;

431: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;
432: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;
433: l_Msg_Text VARCHAR2(4000);
434: l_Transaction_Error_Id NUMBER;
435: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
436:
437: CURSOR exp_line_cur(p_project_id IN number, p_task_id IN number, p_instance_id IN number) IS
438: SELECT pei.expenditure_item_id expenditure_item_id,
439: pei.quantity quantity,

Line 956: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;

952: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;
953: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;
954: l_Msg_Text VARCHAR2(4000);
955: l_Transaction_Error_Id NUMBER;
956: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
957: l_msg_count number;
958: l_msg_data varchar2(4000);
959: l_hook_used number;
960: l_transaction_id NUMBER;

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

966: debug('Inside API cse_fac_inservice_pkg.create_pa_asset_header');
967: debug('param.project_id : '||p_project_id);
968: debug('param.task_id : '||p_task_id);
969:
970: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
971: csi_gen_utility_pvt.populate_install_param_rec;
972: END IF;
973:
974: l_fa_group_by := csi_datastructures_pub.g_install_param_rec.fa_creation_group_by;

Line 974: l_fa_group_by := csi_datastructures_pub.g_install_param_rec.fa_creation_group_by;

970: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
971: csi_gen_utility_pvt.populate_install_param_rec;
972: END IF;
973:
974: l_fa_group_by := csi_datastructures_pub.g_install_param_rec.fa_creation_group_by;
975:
976: FOR insrv_txn_rec IN insrv_txn_cur
977: LOOP
978: l_transaction_id := insrv_txn_rec.transaction_id ;

Line 1133: l_csi_txn_rec csi_datastructures_pub.Transaction_Rec;

1129: l_instance_asset_id number;
1130: l_asset_quantity number;
1131: l_object_version_number number;
1132:
1133: l_csi_txn_rec csi_datastructures_pub.Transaction_Rec;
1134: l_inst_asset_rec csi_datastructures_pub.Instance_Asset_Rec;
1135: l_asset_count_rec csi_asset_pvt.asset_count_rec ;
1136: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;
1137: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;

Line 1134: l_inst_asset_rec csi_datastructures_pub.Instance_Asset_Rec;

1130: l_asset_quantity number;
1131: l_object_version_number number;
1132:
1133: l_csi_txn_rec csi_datastructures_pub.Transaction_Rec;
1134: l_inst_asset_rec csi_datastructures_pub.Instance_Asset_Rec;
1135: l_asset_count_rec csi_asset_pvt.asset_count_rec ;
1136: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;
1137: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;
1138: l_lookup_tbl csi_asset_pvt.lookup_tbl ;