DBA Data[Home] [Help]

APPS.PN_DISTRIBUTIONS_PKG dependencies on PN_VAR_RENT_PKG

Line 409: pn_var_rent_pkg.lock_row_exception('DISTRIBUTION_ID',tlinfo.distribution_id);

405:
406: CLOSE c1;
407:
408: IF NOT (tlinfo.distribution_id = x_distribution_id) THEN
409: pn_var_rent_pkg.lock_row_exception('DISTRIBUTION_ID',tlinfo.distribution_id);
410: END IF;
411: IF NOT (tlinfo.account_id = x_account_id) THEN
412: pn_var_rent_pkg.lock_row_exception('ACCOUNT_ID',tlinfo.account_id);
413: END IF;

Line 412: pn_var_rent_pkg.lock_row_exception('ACCOUNT_ID',tlinfo.account_id);

408: IF NOT (tlinfo.distribution_id = x_distribution_id) THEN
409: pn_var_rent_pkg.lock_row_exception('DISTRIBUTION_ID',tlinfo.distribution_id);
410: END IF;
411: IF NOT (tlinfo.account_id = x_account_id) THEN
412: pn_var_rent_pkg.lock_row_exception('ACCOUNT_ID',tlinfo.account_id);
413: END IF;
414: IF NOT ( (tlinfo.payment_term_id = x_payment_term_id)
415: OR ((tlinfo.payment_term_id IS NULL) AND x_payment_term_id IS NULL)
416: ) THEN

Line 417: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_ID',tlinfo.payment_term_id);

413: END IF;
414: IF NOT ( (tlinfo.payment_term_id = x_payment_term_id)
415: OR ((tlinfo.payment_term_id IS NULL) AND x_payment_term_id IS NULL)
416: ) THEN
417: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_ID',tlinfo.payment_term_id);
418: END IF;
419: IF NOT ( (tlinfo.term_template_id = x_term_template_id)
420: OR ((tlinfo.term_template_id IS NULL) AND x_term_template_id IS NULL)
421: ) THEN

Line 422: pn_var_rent_pkg.lock_row_exception('TERM_TEMPLATE_ID',tlinfo.term_template_id);

418: END IF;
419: IF NOT ( (tlinfo.term_template_id = x_term_template_id)
420: OR ((tlinfo.term_template_id IS NULL) AND x_term_template_id IS NULL)
421: ) THEN
422: pn_var_rent_pkg.lock_row_exception('TERM_TEMPLATE_ID',tlinfo.term_template_id);
423: END IF;
424: IF NOT ( (tlinfo.percentage = x_percentage)
425: OR ((tlinfo.percentage IS NULL) AND x_percentage IS NULL)
426: ) THEN

Line 427: pn_var_rent_pkg.lock_row_exception('PERCENTAGE',tlinfo.percentage);

423: END IF;
424: IF NOT ( (tlinfo.percentage = x_percentage)
425: OR ((tlinfo.percentage IS NULL) AND x_percentage IS NULL)
426: ) THEN
427: pn_var_rent_pkg.lock_row_exception('PERCENTAGE',tlinfo.percentage);
428: END IF;
429: IF NOT ( (tlinfo.line_number = x_line_number)
430: OR ((tlinfo.line_number IS NULL) AND x_line_number IS NULL)
431: ) THEN

Line 432: pn_var_rent_pkg.lock_row_exception('LINE_NUMBER',tlinfo.line_number);

428: END IF;
429: IF NOT ( (tlinfo.line_number = x_line_number)
430: OR ((tlinfo.line_number IS NULL) AND x_line_number IS NULL)
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;