APPS.PN_OPEX_TERMS_PKG dependencies on PN_DISTRIBUTIONS

Line 16: l_distribution_id pn_distributions.distribution_id%TYPE;

12: x_catch_up_term_id OUT NOCOPY NUMBER,
13: x_return_status IN OUT NOCOPY VARCHAR2
14: ) IS
15: l_lease_class_code pn_leases.lease_class_code%TYPE;
16: l_distribution_id pn_distributions.distribution_id%TYPE;
17: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
18: l_rowid ROWID;
19: l_distribution_count NUMBER := 0;
20: l_inv_start_date DATE;

Line 63: FROM pn_distributions_all

59:
60: CURSOR distributions_cur (term_temp_id IN NUMBER)
61: IS
62: SELECT *
63: FROM pn_distributions_all
64: WHERE term_template_id = term_temp_id;
65:
66:
67:

Line 503: l_context := 'Inserting into pn_distributions';

499: FOR rec_distributions in distributions_cur(p_term_template_id)
500: LOOP
501: pnp_debug_pkg.put_log_msg(' account_id '||rec_distributions.account_id);
502: pnp_debug_pkg.put_log_msg(' account_class '||rec_distributions.account_id);
503: l_context := 'Inserting into pn_distributions';
504: pn_distributions_pkg.insert_row (
505: x_rowid => l_rowid
506: ,x_distribution_id => l_distribution_id
507: ,x_account_id => rec_distributions.account_id

Line 504: pn_distributions_pkg.insert_row (

500: LOOP
501: pnp_debug_pkg.put_log_msg(' account_id '||rec_distributions.account_id);
502: pnp_debug_pkg.put_log_msg(' account_class '||rec_distributions.account_id);
503: l_context := 'Inserting into pn_distributions';
504: pn_distributions_pkg.insert_row (
505: x_rowid => l_rowid
506: ,x_distribution_id => l_distribution_id
507: ,x_account_id => rec_distributions.account_id
508: ,x_payment_term_id => l_est_payment_term_id

Line 548: l_context := 'Inserting into pn_distributions';

544: FOR rec_distributions in distributions_cur(p_term_template_id)
545: LOOP
546: pnp_debug_pkg.put_log_msg(' account_id '||rec_distributions.account_id);
547: pnp_debug_pkg.put_log_msg(' account_class '||rec_distributions.account_id);
548: l_context := 'Inserting into pn_distributions';
549: pn_distributions_pkg.insert_row (
550: x_rowid => l_rowid
551: ,x_distribution_id => l_distribution_id
552: ,x_account_id => rec_distributions.account_id

Line 549: pn_distributions_pkg.insert_row (

545: LOOP
546: pnp_debug_pkg.put_log_msg(' account_id '||rec_distributions.account_id);
547: pnp_debug_pkg.put_log_msg(' account_class '||rec_distributions.account_id);
548: l_context := 'Inserting into pn_distributions';
549: pn_distributions_pkg.insert_row (
550: x_rowid => l_rowid
551: ,x_distribution_id => l_distribution_id
552: ,x_account_id => rec_distributions.account_id
553: ,x_payment_term_id => l_catch_up_payment_term_id

Line 617: l_distribution_id pn_distributions.distribution_id%TYPE;

613: x_return_status IN OUT NOCOPY VARCHAR2
614: ) IS
615:
616: l_lease_class_code pn_leases.lease_class_code%TYPE;
617: l_distribution_id pn_distributions.distribution_id%TYPE;
618: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
619: l_rowid ROWID;
620: l_distribution_count NUMBER := 0;
621: l_inv_start_date DATE;

Line 663: FROM pn_distributions_all

659:
660: CURSOR distributions_cur (term_temp_id IN NUMBER)
661: IS
662: SELECT *
663: FROM pn_distributions_all
664: WHERE term_template_id = term_temp_id;
665:
666:
667: -- Using the last estimated payment term to default the values in case present.

Line 985: l_context := 'Inserting into pn_distributions';

981: FOR rec_distributions in distributions_cur(agreement_rec.term_template_id)
982: LOOP
983: pnp_debug_pkg.put_log_msg(' account_id '||rec_distributions.account_id);
984: pnp_debug_pkg.put_log_msg(' account_class '||rec_distributions.account_id);
985: l_context := 'Inserting into pn_distributions';
986: pn_distributions_pkg.insert_row (
987: x_rowid => l_rowid
988: ,x_distribution_id => l_distribution_id
989: ,x_account_id => rec_distributions.account_id

Line 986: pn_distributions_pkg.insert_row (

982: LOOP
983: pnp_debug_pkg.put_log_msg(' account_id '||rec_distributions.account_id);
984: pnp_debug_pkg.put_log_msg(' account_class '||rec_distributions.account_id);
985: l_context := 'Inserting into pn_distributions';
986: pn_distributions_pkg.insert_row (
987: x_rowid => l_rowid
988: ,x_distribution_id => l_distribution_id
989: ,x_account_id => rec_distributions.account_id
990: ,x_payment_term_id => l_payment_term_id

Line 1238: delete from pn_distributions_all

1234:
1235: delete from pn_opex_est_payments_all
1236: where payment_term_id = prev_pay_term_id;
1237:
1238: delete from pn_distributions_all
1239: where payment_term_id = prev_pay_term_id;
1240:
1241: delete from pn_payment_terms_all
1242: where payment_term_id = prev_pay_term_id;