APPS.PN_R12_UTIL_PKG dependencies on PN_DISTRIBUTIONS

Line 187: p_ccid1 IN pn_distributions.account_id%TYPE,

183: -- legal_entity_id
184: ------------------------------------------------------------------------
185:
186: FUNCTION is_le_compatible(
187: p_ccid1 IN pn_distributions.account_id%TYPE,
188: p_ccid2 IN pn_distributions.account_id%TYPE,
189: p_le_id_old IN NUMBER,
190: p_vendor_site_id IN pn_payment_terms.vendor_site_id%TYPE,
191: p_org_id IN pn_payment_terms.org_id%TYPE)

Line 188: p_ccid2 IN pn_distributions.account_id%TYPE,

184: ------------------------------------------------------------------------
185:
186: FUNCTION is_le_compatible(
187: p_ccid1 IN pn_distributions.account_id%TYPE,
188: p_ccid2 IN pn_distributions.account_id%TYPE,
189: p_le_id_old IN NUMBER,
190: p_vendor_site_id IN pn_payment_terms.vendor_site_id%TYPE,
191: p_org_id IN pn_payment_terms.org_id%TYPE)
192:

Line 271: p_ccid IN pn_distributions.account_id%TYPE,

267: -- 25-AUG-05 ftanudja o Removed p_location_id from is_le_compatible.
268: -- 16-OCT-05 sdmahesh o Modified cursors to fetch legal_entity_id
269: --------------------------------------------------------------------------
270: FUNCTION is_le_compatible(
271: p_ccid IN pn_distributions.account_id%TYPE,
272: p_payment_term_id IN pn_payment_terms.payment_term_id%TYPE,
273: p_term_template_id IN pn_payment_terms.term_template_id%TYPE,
274: p_vendor_site_id IN pn_payment_terms.vendor_site_id%TYPE,
275: p_org_id IN pn_payment_terms.org_id%TYPE,

Line 276: p_distribution_id IN pn_distributions.distribution_id%TYPE,

272: p_payment_term_id IN pn_payment_terms.payment_term_id%TYPE,
273: p_term_template_id IN pn_payment_terms.term_template_id%TYPE,
274: p_vendor_site_id IN pn_payment_terms.vendor_site_id%TYPE,
275: p_org_id IN pn_payment_terms.org_id%TYPE,
276: p_distribution_id IN pn_distributions.distribution_id%TYPE,
277: p_mode IN VARCHAR2)
278: RETURN BOOLEAN IS
279:
280: l_answer BOOLEAN := TRUE;

Line 287: FROM pn_distributions dist,

283: -- cursor for checking distr in INSERT mode using term ID
284: CURSOR chk_other_dist_ins IS
285: SELECT ppt.legal_entity_id le_id,
286: dist.account_id cc_id
287: FROM pn_distributions dist,
288: pn_payment_terms_all ppt
289: WHERE dist.payment_term_id = p_payment_term_id
290: AND ppt.payment_term_id = p_payment_term_id
291: AND rownum < 2;

Line 297: FROM pn_distributions dist

293: -- cursor for checking distr in INSERT mode using template ID
294: CURSOR chk_other_dist_templ_ins IS
295: SELECT dist.account_id cc_id,
296: NULL AS le_id
297: FROM pn_distributions dist
298: WHERE dist.term_template_id = p_term_template_id
299: AND rownum < 2;
300:
301: -- cursor for checking distr in UPDATE mode using term ID

Line 305: FROM pn_distributions dist,

301: -- cursor for checking distr in UPDATE mode using term ID
302: CURSOR chk_other_dist_upd IS
303: SELECT ppt.legal_entity_id le_id,
304: dist.account_id cc_id
305: FROM pn_distributions dist,
306: pn_payment_terms_all ppt
307: WHERE dist.payment_term_id = p_payment_term_id
308: AND ppt.payment_term_id = p_payment_term_id
309: AND distribution_id <> p_distribution_id

Line 316: FROM pn_distributions dist

312: -- cursor for checking distr in UPDATE mode using template ID
313: CURSOR chk_other_dist_templ_upd IS
314: SELECT dist.account_id cc_id,
315: NULL AS le_id
316: FROM pn_distributions dist
317: WHERE dist.term_template_id = p_term_template_id
318: AND distribution_id <> p_distribution_id
319: AND rownum < 2;
320:

Line 402: p_code_combination_id pn_distributions.account_id%TYPE

398: -- HISTORY
399: -- 11-JUL-05 ftanudja o created.
400: --------------------------------------------------------------------------
401: FUNCTION get_le_for_ap(
402: p_code_combination_id pn_distributions.account_id%TYPE
403: ,p_location_id pn_payment_terms.vendor_site_id%TYPE
404: ,p_org_id pn_payment_terms.org_id%TYPE)
405: RETURN NUMBER IS
406: