APPS.PN_REC_CALC_PKG dependencies on PN_DISTRIBUTIONS_ALL

Line 4039: FROM pn_distributions_all pd

4035:
4036: CURSOR csr_temp_dist(p_term_template_id IN NUMBER)
4037: IS
4038: SELECT pd.*
4039: FROM pn_distributions_all pd
4040: WHERE pd.term_template_id = p_term_template_id;
4041:
4042: CURSOR csr_term_dist(p_term_id IN NUMBER)
4043: IS

Line 4045: FROM pn_distributions_all pd

4041:
4042: CURSOR csr_term_dist(p_term_id IN NUMBER)
4043: IS
4044: SELECT pd.*
4045: FROM pn_distributions_all pd
4046: WHERE pd.payment_term_id = p_term_id;
4047:
4048: CURSOR csr_template (p_rec_agreement_id IN NUMBER)
4049: IS

Line 4579: | 05-SEP-2003 Daniel Thota o Added code to delete from pn_distributions_all,

4575: |
4576: | 19-MAY-2003 Daniel Thota o Created
4577: | 04-SEP-2003 Daniel Thota o Removed DECODE and used IF..THEN..ELSE instead
4578: | Fix for bugs 3123730,3122264
4579: | 05-SEP-2003 Daniel Thota o Added code to delete from pn_distributions_all,
4580: | before deleting from pn_payment_terms_all
4581: | 17-SEP-2003 Daniel Thota o Put in cursors get_distributions_exist_nocons
4582: | and cursors get_distributions_exist_cons
4583: | Fix for bug # 3142328

Line 4602: FROM pn_distributions_all dist

4598: CURSOR get_distributions_exist_nocons IS
4599: SELECT 'Y'
4600: FROM dual
4601: WHERE EXISTS (SELECT 1
4602: FROM pn_distributions_all dist
4603: ,pn_payment_terms_all term
4604: WHERE term.payment_term_id = dist.payment_term_id
4605: AND term.period_billrec_id = l_period_bill_record.period_billrec_id
4606: AND term.rec_agr_line_id = p_rec_agr_line_id

Line 4614: FROM pn_distributions_all dist

4610: CURSOR get_distributions_exist_cons IS
4611: SELECT 'Y'
4612: FROM dual
4613: WHERE EXISTS (SELECT 1
4614: FROM pn_distributions_all dist
4615: ,pn_payment_terms_all term
4616: WHERE term.payment_term_id = dist.payment_term_id
4617: AND term.period_billrec_id = l_period_bill_record.period_billrec_id
4618: AND term.status = 'DRAFT')

Line 4690: DELETE pn_distributions_all

4686:
4687: pnp_debug_pkg.log('now deleting terms l_distributions_exist: '||l_distributions_exist);
4688: IF l_distributions_exist = 'Y' THEN
4689:
4690: DELETE pn_distributions_all
4691: WHERE payment_term_id in (SELECT payment_term_id
4692: FROM pn_payment_terms_all
4693: WHERE period_billrec_id = l_period_bill_record.period_billrec_id
4694: AND rec_agr_line_id = p_rec_agr_line_id

Line 4715: DELETE pn_distributions_all

4711: CLOSE get_distributions_exist_cons;
4712:
4713: IF l_distributions_exist = 'Y' THEN
4714:
4715: DELETE pn_distributions_all
4716: WHERE payment_term_id in (SELECT payment_term_id
4717: FROM pn_payment_terms_all
4718: WHERE period_billrec_id = l_period_bill_record.period_billrec_id
4719: AND status = 'DRAFT')