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 422: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;

418: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;
419: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;
420: l_Msg_Text VARCHAR2(4000);
421: l_Transaction_Error_Id NUMBER;
422: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
423:
424: CURSOR exp_line_cur(p_project_id IN number, p_task_id IN number, p_instance_id IN number) IS
425: SELECT pei.expenditure_item_id expenditure_item_id,
426: pei.quantity quantity,

Line 938: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;

934: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;
935: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;
936: l_Msg_Text VARCHAR2(4000);
937: l_Transaction_Error_Id NUMBER;
938: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
939: l_msg_count number;
940: l_msg_data varchar2(4000);
941: l_hook_used number;
942: l_transaction_id NUMBER;

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

948: debug('Inside API cse_fac_inservice_pkg.create_pa_asset_header');
949: debug('param.project_id : '||p_project_id);
950: debug('param.task_id : '||p_task_id);
951:
952: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
953: csi_gen_utility_pvt.populate_install_param_rec;
954: END IF;
955:
956: l_fa_group_by := csi_datastructures_pub.g_install_param_rec.fa_creation_group_by;

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

952: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
953: csi_gen_utility_pvt.populate_install_param_rec;
954: END IF;
955:
956: l_fa_group_by := csi_datastructures_pub.g_install_param_rec.fa_creation_group_by;
957:
958: FOR insrv_txn_rec IN insrv_txn_cur
959: LOOP
960: l_transaction_id := insrv_txn_rec.transaction_id ;

Line 1098: l_csi_txn_rec csi_datastructures_pub.Transaction_Rec;

1094: l_instance_asset_id number;
1095: l_asset_quantity number;
1096: l_object_version_number number;
1097:
1098: l_csi_txn_rec csi_datastructures_pub.Transaction_Rec;
1099: l_inst_asset_rec csi_datastructures_pub.Instance_Asset_Rec;
1100: l_asset_count_rec csi_asset_pvt.asset_count_rec ;
1101: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;
1102: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;

Line 1099: l_inst_asset_rec csi_datastructures_pub.Instance_Asset_Rec;

1095: l_asset_quantity number;
1096: l_object_version_number number;
1097:
1098: l_csi_txn_rec csi_datastructures_pub.Transaction_Rec;
1099: l_inst_asset_rec csi_datastructures_pub.Instance_Asset_Rec;
1100: l_asset_count_rec csi_asset_pvt.asset_count_rec ;
1101: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;
1102: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;
1103: l_lookup_tbl csi_asset_pvt.lookup_tbl ;