APPS.PN_DISTRIBUTIONS_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 62: FROM pn_payment_terms_all term

58: CURSOR csr_vendor_info IS
59: SELECT term.vendor_site_id AS vendor_site_id,
60: term.legal_entity_id AS legal_entity_id,
61: term.org_id AS org_id
62: FROM pn_payment_terms_all term
63: WHERE term.payment_term_id = x_payment_term_id;
64:
65: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
66:

Line 69: FROM pn_payment_terms_all

65: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
66:
67: CURSOR term_org (p_term_ID IN NUMBER) IS
68: SELECT org_ID
69: FROM pn_payment_terms_all
70: WHERE payment_term_id = p_term_ID;
71:
72: CURSOR template_org (p_template_ID IN NUMBER) IS
73: SELECT org_ID

Line 100: UPDATE pn_payment_terms_all

96: ,p_location_id => l_vendor_site_id
97: ,p_org_id => l_org_id
98: );
99: IF (nvl(l_term_le_ID,-99) <> l_legal_entity_id) THEN --Bug13997924
100: UPDATE pn_payment_terms_all
101: SET legal_entity_id = l_legal_entity_id,
102: last_update_date = x_last_update_date,
103: last_updated_by = x_last_updated_by,
104: last_update_login = x_last_update_login

Line 273: FROM pn_payment_terms_all term

269: CURSOR csr_vendor_info IS
270: SELECT term.vendor_site_id AS vendor_site_id,
271: term.legal_entity_id AS legal_entity_id,
272: term.org_id AS org_id
273: FROM pn_payment_terms_all term
274: WHERE term.payment_term_id = x_payment_term_id;
275:
276: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
277: l_return_status VARCHAR2 (30) := NULL;

Line 285: pn_payment_terms_all term

281: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.update_row (+)');
282:
283: SELECT count(*) INTO l_count
284: FROM pn_distributions_all dist,
285: pn_payment_terms_all term
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:

Line 299: UPDATE pn_payment_terms_all

295: ,p_location_id => csr_vendor_info_rec.vendor_site_id
296: ,p_org_id => csr_vendor_info_rec.org_id
297: );
298: IF (nvl(csr_vendor_info_rec.legal_entity_id,-99) <> l_legal_entity_id) THEN --Bug 13997924
299: UPDATE pn_payment_terms_all
300: SET legal_entity_id = l_legal_entity_id,
301: last_update_date = x_last_update_date,
302: last_updated_by = x_last_updated_by,
303: last_update_login = x_last_update_login

Line 343: UPDATE pn_payment_terms_all

339: RAISE NO_DATA_FOUND;
340: END IF;
341:
342: IF x_lease_change_id IS NOT NULL THEN
343: UPDATE pn_payment_terms_all
344: SET lease_change_id = x_lease_change_id
345: WHERE payment_term_id = x_payment_term_id;
346: END IF;
347:

Line 457: FROM pn_payment_terms_all term,

453: SELECT term.vendor_site_id,
454: term.legal_entity_id,
455: term.org_id,
456: dist.account_id
457: FROM pn_payment_terms_all term,
458: pn_distributions_all dist
459: WHERE term.payment_term_id = dist.payment_term_id (+)
460: AND term.payment_term_id = p_term_id
461: AND rownum < 2;

Line 522: FROM pn_payment_terms_all term,

518: SELECT term.vendor_site_id,
519: term.legal_entity_id,
520: term.org_id,
521: dist.account_id
522: FROM pn_payment_terms_all term,
523: pn_distributions_all dist
524: WHERE term.payment_term_id = dist.payment_term_id (+)
525: AND term.payment_term_id = p_term_id
526: AND rownum < 2;