APPS.PN_REC_CALC_PKG dependencies on PN_DISTRIBUTIONS_ALL

Line 4124: FROM pn_distributions_all pd

4120:
4121: CURSOR csr_temp_dist(p_term_template_id IN NUMBER)
4122: IS
4123: SELECT pd.*
4124: FROM pn_distributions_all pd
4125: WHERE pd.term_template_id = p_term_template_id;
4126:
4127: CURSOR csr_term_dist(p_term_id IN NUMBER)
4128: IS

Line 4130: FROM pn_distributions_all pd

4126:
4127: CURSOR csr_term_dist(p_term_id IN NUMBER)
4128: IS
4129: SELECT pd.*
4130: FROM pn_distributions_all pd
4131: WHERE pd.payment_term_id = p_term_id;
4132:
4133: CURSOR csr_template (p_rec_agreement_id IN NUMBER)
4134: IS

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

4660: |
4661: | 19-MAY-2003 Daniel Thota o Created
4662: | 04-SEP-2003 Daniel Thota o Removed DECODE and used IF..THEN..ELSE instead
4663: | Fix for bugs 3123730,3122264
4664: | 05-SEP-2003 Daniel Thota o Added code to delete from pn_distributions_all,
4665: | before deleting from pn_payment_terms_all
4666: | 17-SEP-2003 Daniel Thota o Put in cursors get_distributions_exist_nocons
4667: | and cursors get_distributions_exist_cons
4668: | Fix for bug # 3142328

Line 4687: FROM pn_distributions_all dist

4683: CURSOR get_distributions_exist_nocons IS
4684: SELECT 'Y'
4685: FROM dual
4686: WHERE EXISTS (SELECT 1
4687: FROM pn_distributions_all dist
4688: ,pn_payment_terms_all term
4689: WHERE term.payment_term_id = dist.payment_term_id
4690: AND term.period_billrec_id = l_period_bill_record.period_billrec_id
4691: AND term.rec_agr_line_id = p_rec_agr_line_id

Line 4699: FROM pn_distributions_all dist

4695: CURSOR get_distributions_exist_cons IS
4696: SELECT 'Y'
4697: FROM dual
4698: WHERE EXISTS (SELECT 1
4699: FROM pn_distributions_all dist
4700: ,pn_payment_terms_all term
4701: WHERE term.payment_term_id = dist.payment_term_id
4702: AND term.period_billrec_id = l_period_bill_record.period_billrec_id
4703: AND term.status = 'DRAFT')

Line 4775: DELETE pn_distributions_all

4771:
4772: pnp_debug_pkg.log('now deleting terms l_distributions_exist: '||l_distributions_exist);
4773: IF l_distributions_exist = 'Y' THEN
4774:
4775: DELETE pn_distributions_all
4776: WHERE payment_term_id in (SELECT payment_term_id
4777: FROM pn_payment_terms_all
4778: WHERE period_billrec_id = l_period_bill_record.period_billrec_id
4779: AND rec_agr_line_id = p_rec_agr_line_id

Line 4800: DELETE pn_distributions_all

4796: CLOSE get_distributions_exist_cons;
4797:
4798: IF l_distributions_exist = 'Y' THEN
4799:
4800: DELETE pn_distributions_all
4801: WHERE payment_term_id in (SELECT payment_term_id
4802: FROM pn_payment_terms_all
4803: WHERE period_billrec_id = l_period_bill_record.period_billrec_id
4804: AND status = 'DRAFT')