APPS.CSE_FAC_INSERVICE_PKG dependencies on CSE_DATASTRUCTURES_PUB

Line 37: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;

33: x_return_status := fnd_api.g_ret_sts_success;
34:
35: l_txn_rec.transaction_id := p_csi_txn_id;
36: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;
37: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;
38:
39: SELECT object_version_number
40: INTO l_txn_rec.object_version_number
41: FROM csi_transactions

Line 91: l_in_srv_pa_attr_rec cse_datastructures_pub.proj_itm_insv_pa_attr_rec_type;

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
95: FROM pa_projects_all

Line 116: AND transaction_status_code = cse_datastructures_pub.g_pending

112: source_header_ref_id project_id,
113: source_line_ref_id task_id
114: FROM csi_transactions
115: WHERE transaction_type_id = 108
116: AND transaction_status_code = cse_datastructures_pub.g_pending
117: AND source_header_ref_id = nvl(p_project_id, source_header_ref_id)
118: AND source_line_ref_id = nvl(p_task_id, source_line_ref_id);
119:
120: CURSOR inservice_inst_cur(p_csi_txn_id IN number) IS

Line 384: l_asset_attrib_rec CSE_DATASTRUCTURES_PUB.asset_attrib_rec;

380: l_task_attribute10 varchar2(80);
381:
382: l_date_placed_in_service date;
383: l_asset_units number;
384: l_asset_attrib_rec CSE_DATASTRUCTURES_PUB.asset_attrib_rec;
385:
386: -- asset naming convention variables
387: l_anc_name varchar2(30);
388: l_anc_desc1 varchar2(30);

Line 1241: l_csi_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete;

1237: l_csi_txn_rec.source_transaction_date := sysdate;
1238: l_csi_txn_rec.transaction_quantity := l_units;
1239: l_csi_txn_rec.source_header_ref := 'ASSET_ID';
1240: l_csi_txn_rec.source_header_ref_id := l_asset_id;
1241: l_csi_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete;
1242: l_csi_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
1243:
1244: l_inst_asset_rec := cse_util_pkg.init_instance_asset_rec;
1245: l_inst_asset_rec.asset_quantity := l_asset_quantity + l_units;

Line 1248: l_inst_asset_rec.update_status := cse_datastructures_pub.g_in_service;

1244: l_inst_asset_rec := cse_util_pkg.init_instance_asset_rec;
1245: l_inst_asset_rec.asset_quantity := l_asset_quantity + l_units;
1246: l_inst_asset_rec.instance_asset_id := l_instance_asset_id;
1247: l_inst_asset_rec.object_version_number := l_object_version_number;
1248: l_inst_asset_rec.update_status := cse_datastructures_pub.g_in_service;
1249: l_inst_asset_rec.active_end_date := null;
1250: l_inst_asset_rec.check_for_instance_expiry := fnd_api.g_false;
1251:
1252: debug(' instance_asset_id : '||l_inst_asset_rec.instance_asset_id);