APPS.PN_DISTRIBUTIONS_PKG dependencies on PN_DISTRIBUTIONS_PKG

Line 1: PACKAGE BODY pn_distributions_pkg

1: PACKAGE BODY pn_distributions_pkg
2: -- $Header: PNTDISTB.pls 120.11.12020000.2 2012/08/01 06:49:12 ppenumar ship $
3:
4: AS
5:

Line 79: -- PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.insert_row (+)');

75: WHERE term_template_id = p_template_ID;
76:
77: BEGIN
78:
79: -- PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.insert_row (+)');
80:
81: /* handle the le stamping */
82: FOR rec IN csr_vendor_info LOOP
83: l_org_id := rec.org_id;

Line 225: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.insert_row (-)');

221:
222: END IF;
223:
224:
225: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.insert_row (-)');
226: END insert_row;
227:
228: -------------------------------------------------------------------------------
229: -- PROCDURE : update_row

Line 281: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.update_row (+)');

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

Line 348: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.update_row (-)');

344: SET lease_change_id = x_lease_change_id
345: WHERE payment_term_id = x_payment_term_id;
346: END IF;
347:
348: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.update_row (-)');
349: END update_row;
350:
351:
352: -------------------------------------------------------------------------------

Line 396: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.lock_row (+)');

392:
393: tlinfo c1%ROWTYPE;
394: BEGIN
395:
396: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.lock_row (+)');
397: OPEN c1;
398: FETCH c1 INTO tlinfo;
399:
400: IF (c1%NOTFOUND)

Line 435: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.lock_row (-)');

431: ) THEN
432: pn_var_rent_pkg.lock_row_exception('LINE_NUMBER',tlinfo.line_number);
433: END IF;
434:
435: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.lock_row (-)');
436: END lock_row;
437:
438:
439: -------------------------------------------------------------------------------

Line 465: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.delete_row (+)');

461: AND rownum < 2;
462:
463: BEGIN
464:
465: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.delete_row (+)');
466: DELETE FROM pn_distributions_all
467: WHERE ROWID = x_rowid
468: RETURNING payment_term_id INTO l_term_id;
469:

Line 500: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.delete_row (-)');

496: END IF;
497: END LOOP;
498: END IF;
499:
500: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.delete_row (-)');
501: END delete_row;
502:
503: -------------------------------------------------------------------------------
504: -- PROCDURE : delete_row

Line 530: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.delete_row (+)');

526: AND rownum < 2;
527:
528: BEGIN
529:
530: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.delete_row (+)');
531: DELETE FROM pn_distributions_all
532: WHERE distribution_id = x_distribution_id
533: RETURNING payment_term_id INTO l_term_id;
534:

Line 565: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.delete_row (-)');

561: END IF;
562: END LOOP;
563: END IF;
564:
565: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.delete_row (-)');
566: END delete_row;
567:
568: END pn_distributions_pkg;

Line 568: END pn_distributions_pkg;

564:
565: --PNP_DEBUG_PKG.debug (' PN_DISTRIBUTIONS_PKG.delete_row (-)');
566: END delete_row;
567:
568: END pn_distributions_pkg;