DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_IN_SRV_PKG dependencies on CSE_IPA_TRANS_PKG

Line 94: l_nl_pa_interface_tbl CSE_IPA_TRANS_PKG.nl_pa_interface_tbl_type;

90: l_active_instance_only VARCHAR2(1) DEFAULT FND_API.G_TRUE;
91: l_txn_rec csi_datastructures_pub.transaction_rec;
92: l_asset_location_rec csi_datastructures_pub.instance_asset_location_rec;
93: l_asset_location_tbl csi_datastructures_pub.instance_asset_location_tbl;
94: l_nl_pa_interface_tbl CSE_IPA_TRANS_PKG.nl_pa_interface_tbl_type;
95: l_nl_pa_interface_rec CSE_IPA_TRANS_PKG.nl_pa_interface_rec_type;
96: l_burden_cost_sum NUMBER;
97: l_qty_sum NUMBER;
98: l_sum_of_qty NUMBER;

Line 95: l_nl_pa_interface_rec CSE_IPA_TRANS_PKG.nl_pa_interface_rec_type;

91: l_txn_rec csi_datastructures_pub.transaction_rec;
92: l_asset_location_rec csi_datastructures_pub.instance_asset_location_rec;
93: l_asset_location_tbl csi_datastructures_pub.instance_asset_location_tbl;
94: l_nl_pa_interface_tbl CSE_IPA_TRANS_PKG.nl_pa_interface_tbl_type;
95: l_nl_pa_interface_rec CSE_IPA_TRANS_PKG.nl_pa_interface_rec_type;
96: l_burden_cost_sum NUMBER;
97: l_qty_sum NUMBER;
98: l_sum_of_qty NUMBER;
99: l_fa_location_id NUMBER;

Line 215: x_nl_pa_interface_rec OUT nocopy CSE_IPA_TRANS_PKG.nl_pa_interface_rec_type)

211: p_project_number IN varchar2,
212: p_task_number IN varchar2,
213: p_item_name IN varchar2,
214: p_ei_rec IN ei_cur_rec,
215: x_nl_pa_interface_rec OUT nocopy CSE_IPA_TRANS_PKG.nl_pa_interface_rec_type)
216: IS
217: l_ref_suffix_inner number; -- Changes for bug 7368371
218: BEGIN
219:

Line 358: debug('Inside API cse_ipa_trans_pkg.get_grouping_attribute');

354: END IF;
355:
356: debug(' fa_location_id : '||l_fa_location_id);
357:
358: debug('Inside API cse_ipa_trans_pkg.get_grouping_attribute');
359:
360: cse_ipa_trans_pkg.get_grouping_attribute(
361: p_item_id => p_in_srv_pa_attr_rec.item_id,
362: p_organization_id => p_in_srv_pa_attr_rec.inv_master_org_id,

Line 360: cse_ipa_trans_pkg.get_grouping_attribute(

356: debug(' fa_location_id : '||l_fa_location_id);
357:
358: debug('Inside API cse_ipa_trans_pkg.get_grouping_attribute');
359:
360: cse_ipa_trans_pkg.get_grouping_attribute(
361: p_item_id => p_in_srv_pa_attr_rec.item_id,
362: p_organization_id => p_in_srv_pa_attr_rec.inv_master_org_id,
363: p_project_id => p_in_srv_pa_attr_rec.project_id,
364: p_fa_location_id => l_fa_location_id,

Line 378: debug('CSE_IPA_TRANS_PKG.get_grouping_attribute failed : '||l_error_message);

374: debug(' attribute9 : '||l_attribute9);
375: debug(' attribute10 : '||l_attribute10);
376:
377: IF l_return_status <> fnd_api.g_ret_sts_success THEN
378: debug('CSE_IPA_TRANS_PKG.get_grouping_attribute failed : '||l_error_message);
379: RAISE fnd_api.g_exc_error;
380: END IF;
381:
382: SELECT segment1, org_id -- Bug 6492235, changed to support multiple FA book

Line 603: debug('Inside API cse_ipa_trans_pkg.populate_pa_interface');

599: debug('l_nl_pa_interface_tbl.count : '||l_nl_pa_interface_tbl.COUNT);
600:
601: IF l_nl_pa_interface_tbl.COUNT > 0 THEN
602:
603: debug('Inside API cse_ipa_trans_pkg.populate_pa_interface');
604:
605: cse_ipa_trans_pkg.populate_pa_interface(
606: p_nl_pa_interface_tbl => l_nl_pa_interface_tbl,
607: x_return_status => l_return_status,

Line 605: cse_ipa_trans_pkg.populate_pa_interface(

601: IF l_nl_pa_interface_tbl.COUNT > 0 THEN
602:
603: debug('Inside API cse_ipa_trans_pkg.populate_pa_interface');
604:
605: cse_ipa_trans_pkg.populate_pa_interface(
606: p_nl_pa_interface_tbl => l_nl_pa_interface_tbl,
607: x_return_status => l_return_status,
608: x_error_message => l_error_message);
609: