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 209: x_nl_pa_interface_rec OUT nocopy CSE_IPA_TRANS_PKG.nl_pa_interface_rec_type)

205: p_project_number IN varchar2,
206: p_task_number IN varchar2,
207: p_item_name IN varchar2,
208: p_ei_rec IN ei_cur_rec,
209: x_nl_pa_interface_rec OUT nocopy CSE_IPA_TRANS_PKG.nl_pa_interface_rec_type)
210: IS
211: l_ref_suffix_inner number; -- Changes for bug 7368371
212: BEGIN
213:

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

348: END IF;
349:
350: debug(' fa_location_id : '||l_fa_location_id);
351:
352: debug('Inside API cse_ipa_trans_pkg.get_grouping_attribute');
353:
354: cse_ipa_trans_pkg.get_grouping_attribute(
355: p_item_id => p_in_srv_pa_attr_rec.item_id,
356: p_organization_id => p_in_srv_pa_attr_rec.inv_master_org_id,

Line 354: cse_ipa_trans_pkg.get_grouping_attribute(

350: debug(' fa_location_id : '||l_fa_location_id);
351:
352: debug('Inside API cse_ipa_trans_pkg.get_grouping_attribute');
353:
354: cse_ipa_trans_pkg.get_grouping_attribute(
355: p_item_id => p_in_srv_pa_attr_rec.item_id,
356: p_organization_id => p_in_srv_pa_attr_rec.inv_master_org_id,
357: p_project_id => p_in_srv_pa_attr_rec.project_id,
358: p_fa_location_id => l_fa_location_id,

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

368: debug(' attribute9 : '||l_attribute9);
369: debug(' attribute10 : '||l_attribute10);
370:
371: IF l_return_status <> fnd_api.g_ret_sts_success THEN
372: debug('CSE_IPA_TRANS_PKG.get_grouping_attribute failed : '||l_error_message);
373: RAISE fnd_api.g_exc_error;
374: END IF;
375:
376: SELECT segment1, org_id -- Bug 6492235, changed to support multiple FA book

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

589: debug('l_nl_pa_interface_tbl.count : '||l_nl_pa_interface_tbl.COUNT);
590:
591: IF l_nl_pa_interface_tbl.COUNT > 0 THEN
592:
593: debug('Inside API cse_ipa_trans_pkg.populate_pa_interface');
594:
595: cse_ipa_trans_pkg.populate_pa_interface(
596: p_nl_pa_interface_tbl => l_nl_pa_interface_tbl,
597: x_return_status => l_return_status,

Line 595: cse_ipa_trans_pkg.populate_pa_interface(

591: IF l_nl_pa_interface_tbl.COUNT > 0 THEN
592:
593: debug('Inside API cse_ipa_trans_pkg.populate_pa_interface');
594:
595: cse_ipa_trans_pkg.populate_pa_interface(
596: p_nl_pa_interface_tbl => l_nl_pa_interface_tbl,
597: x_return_status => l_return_status,
598: x_error_message => l_error_message);
599: