DBA Data[Home] [Help]

APPS.PN_DISTRIBUTIONS_PKG dependencies on PN_R12_UTIL_PKG

Line 92: IF pn_r12_util_pkg.is_r12 AND (l_count < 1)THEN

88: SELECT count(*) INTO l_count
89: FROM pn_distributions_all pd
90: WHERE pd.payment_term_id = x_payment_term_id;
91:
92: IF pn_r12_util_pkg.is_r12 AND (l_count < 1)THEN
93: l_legal_entity_id :=
94: pn_r12_util_pkg.get_le_for_ap(
95: p_code_combination_id => x_account_id
96: ,p_location_id => l_vendor_site_id

Line 94: pn_r12_util_pkg.get_le_for_ap(

90: WHERE pd.payment_term_id = x_payment_term_id;
91:
92: IF pn_r12_util_pkg.is_r12 AND (l_count < 1)THEN
93: l_legal_entity_id :=
94: pn_r12_util_pkg.get_le_for_ap(
95: p_code_combination_id => x_account_id
96: ,p_location_id => l_vendor_site_id
97: ,p_org_id => l_org_id
98: );

Line 290: IF pn_r12_util_pkg.is_r12 AND (l_count < 1)THEN

286: WHERE dist.payment_term_id = term.payment_term_id
287: AND term.payment_term_id = x_payment_term_id
288: AND dist.distribution_id <> x_distribution_id;
289:
290: IF pn_r12_util_pkg.is_r12 AND (l_count < 1)THEN
291: FOR csr_vendor_info_rec IN csr_vendor_info LOOP
292: l_legal_entity_id :=
293: pn_r12_util_pkg.get_le_for_ap(
294: p_code_combination_id => x_account_id

Line 293: pn_r12_util_pkg.get_le_for_ap(

289:
290: IF pn_r12_util_pkg.is_r12 AND (l_count < 1)THEN
291: FOR csr_vendor_info_rec IN csr_vendor_info LOOP
292: l_legal_entity_id :=
293: pn_r12_util_pkg.get_le_for_ap(
294: p_code_combination_id => x_account_id
295: ,p_location_id => csr_vendor_info_rec.vendor_site_id
296: ,p_org_id => csr_vendor_info_rec.org_id
297: );

Line 475: IF pn_r12_util_pkg.is_r12 THEN

471: THEN
472: RAISE NO_DATA_FOUND;
473: END IF;
474:
475: IF pn_r12_util_pkg.is_r12 THEN
476: FOR chk_dist_rec IN get_term_data (l_term_id) LOOP
477: IF chk_dist_rec.account_id IS NULL AND
478: chk_dist_rec.vendor_site_id IS NOT NULL THEN
479:

Line 481: pn_r12_util_pkg.get_le_for_ap(

477: IF chk_dist_rec.account_id IS NULL AND
478: chk_dist_rec.vendor_site_id IS NOT NULL THEN
479:
480: l_legal_entity_id :=
481: pn_r12_util_pkg.get_le_for_ap(
482: p_code_combination_id => null
483: ,p_location_id => chk_dist_rec.vendor_site_id
484: ,p_org_id => chk_dist_rec.org_id
485: );

Line 540: IF pn_r12_util_pkg.is_r12 THEN

536: THEN
537: RAISE NO_DATA_FOUND;
538: END IF;
539:
540: IF pn_r12_util_pkg.is_r12 THEN
541: FOR chk_dist_rec IN get_term_data (l_term_id) LOOP
542: IF chk_dist_rec.account_id IS NULL AND
543: chk_dist_rec.vendor_site_id IS NOT NULL THEN
544:

Line 546: pn_r12_util_pkg.get_le_for_ap(

542: IF chk_dist_rec.account_id IS NULL AND
543: chk_dist_rec.vendor_site_id IS NOT NULL THEN
544:
545: l_legal_entity_id :=
546: pn_r12_util_pkg.get_le_for_ap(
547: p_code_combination_id => null
548: ,p_location_id => chk_dist_rec.vendor_site_id
549: ,p_org_id => chk_dist_rec.org_id
550: );