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:
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:
67: CURSOR term_org (p_term_ID IN NUMBER) IS
68: SELECT org_ID
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
96: ,p_location_id => l_vendor_site_id
97: ,p_org_id => l_org_id
98: );
99: IF l_term_le_ID <> l_legal_entity_id THEN
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
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;
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;
278: l_count NUMBER;
279: BEGIN
280:
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:
295: ,p_location_id => csr_vendor_info_rec.vendor_site_id
296: ,p_org_id => csr_vendor_info_rec.org_id
297: );
298: IF csr_vendor_info_rec.legal_entity_id <> l_legal_entity_id THEN
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
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:
445: -------------------------------------------------------------------------------
446: PROCEDURE delete_row (x_rowid IN VARCHAR2)
447: IS
448:
449: l_term_id pn_payment_terms.payment_term_id%TYPE;
450: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
451:
452: CURSOR get_term_data(p_term_id pn_payment_terms.payment_term_id%TYPE) IS
453: SELECT term.vendor_site_id,
446: PROCEDURE delete_row (x_rowid IN VARCHAR2)
447: IS
448:
449: l_term_id pn_payment_terms.payment_term_id%TYPE;
450: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
451:
452: CURSOR get_term_data(p_term_id pn_payment_terms.payment_term_id%TYPE) IS
453: SELECT term.vendor_site_id,
454: term.legal_entity_id,
448:
449: l_term_id pn_payment_terms.payment_term_id%TYPE;
450: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
451:
452: CURSOR get_term_data(p_term_id pn_payment_terms.payment_term_id%TYPE) IS
453: SELECT term.vendor_site_id,
454: term.legal_entity_id,
455: term.org_id,
456: dist.account_id
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;
485: );
486:
487: IF NOT ((chk_dist_rec.legal_entity_id = l_legal_entity_id) OR
488: (chk_dist_rec.legal_entity_id IS NULL AND l_legal_entity_id IS NULL)) THEN
489: UPDATE pn_payment_terms
490: SET legal_entity_id = l_legal_entity_id,
491: last_update_date = SYSDATE,
492: last_updated_by = fnd_global.user_id,
493: last_update_login = fnd_global.login_id
510: -------------------------------------------------------------------------------
511: PROCEDURE delete_row (x_distribution_id IN NUMBER)
512: IS
513:
514: l_term_id pn_payment_terms.payment_term_id%TYPE;
515: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
516:
517: CURSOR get_term_data(p_term_id pn_payment_terms.payment_term_id%TYPE) IS
518: SELECT term.vendor_site_id,
511: PROCEDURE delete_row (x_distribution_id IN NUMBER)
512: IS
513:
514: l_term_id pn_payment_terms.payment_term_id%TYPE;
515: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
516:
517: CURSOR get_term_data(p_term_id pn_payment_terms.payment_term_id%TYPE) IS
518: SELECT term.vendor_site_id,
519: term.legal_entity_id,
513:
514: l_term_id pn_payment_terms.payment_term_id%TYPE;
515: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
516:
517: CURSOR get_term_data(p_term_id pn_payment_terms.payment_term_id%TYPE) IS
518: SELECT term.vendor_site_id,
519: term.legal_entity_id,
520: term.org_id,
521: dist.account_id
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;
550: );
551:
552: IF NOT ((chk_dist_rec.legal_entity_id = l_legal_entity_id) OR
553: (chk_dist_rec.legal_entity_id IS NULL AND l_legal_entity_id IS NULL)) THEN
554: UPDATE pn_payment_terms
555: SET legal_entity_id = l_legal_entity_id,
556: last_update_date = SYSDATE,
557: last_updated_by = fnd_global.user_id,
558: last_update_login = fnd_global.login_id