APPS.PN_DISTRIBUTION_ACCOUNT dependencies on PN_DISTRIBUTIONS

Line 35: l_lia_rec_class pn_distributions.account_class%TYPE;

31: l_project_id NUMBER;
32: l_distribution_set_id NUMBER;
33: l_lease_num pn_leases.lease_num%TYPE;
34: l_lease_class_code pn_leases.lease_class_code%TYPE;
35: l_lia_rec_class pn_distributions.account_class%TYPE;
36: l_lia_rec_acc pn_distributions.account_id%TYPE;
37: l_accr_class pn_distributions.account_class%TYPE;
38: l_accr_acc pn_distributions.account_id%TYPE;
39: l_count NUMBER := 0;

Line 36: l_lia_rec_acc pn_distributions.account_id%TYPE;

32: l_distribution_set_id NUMBER;
33: l_lease_num pn_leases.lease_num%TYPE;
34: l_lease_class_code pn_leases.lease_class_code%TYPE;
35: l_lia_rec_class pn_distributions.account_class%TYPE;
36: l_lia_rec_acc pn_distributions.account_id%TYPE;
37: l_accr_class pn_distributions.account_class%TYPE;
38: l_accr_acc pn_distributions.account_id%TYPE;
39: l_count NUMBER := 0;
40: l_total_count NUMBER := 0;

Line 37: l_accr_class pn_distributions.account_class%TYPE;

33: l_lease_num pn_leases.lease_num%TYPE;
34: l_lease_class_code pn_leases.lease_class_code%TYPE;
35: l_lia_rec_class pn_distributions.account_class%TYPE;
36: l_lia_rec_acc pn_distributions.account_id%TYPE;
37: l_accr_class pn_distributions.account_class%TYPE;
38: l_accr_acc pn_distributions.account_id%TYPE;
39: l_count NUMBER := 0;
40: l_total_count NUMBER := 0;
41: l_context VARCHAR2(2000);

Line 38: l_accr_acc pn_distributions.account_id%TYPE;

34: l_lease_class_code pn_leases.lease_class_code%TYPE;
35: l_lia_rec_class pn_distributions.account_class%TYPE;
36: l_lia_rec_acc pn_distributions.account_id%TYPE;
37: l_accr_class pn_distributions.account_class%TYPE;
38: l_accr_acc pn_distributions.account_id%TYPE;
39: l_count NUMBER := 0;
40: l_total_count NUMBER := 0;
41: l_context VARCHAR2(2000);
42: /* v_where_clause VARCHAR2(2000):= NULL; */

Line 308: -- 14-JUL-05 hareesha o Bug 4284035 - Replaced pn_distributions with _ALL.

304: -- PROCDURE : CREATE_ACCNT_DIST
305: -- INVOKED FROM :
306: -- PURPOSE :
307: -- HISTORY :
308: -- 14-JUL-05 hareesha o Bug 4284035 - Replaced pn_distributions with _ALL.
309: -- 22-NOV-05 Hareesha o Replaced _all with secured synonyms/baseviews.
310: -------------------------------------------------------------------------------
311: PROCEDURE create_accnt_dist (
312: p_payment_term_id IN NUMBER ,

Line 324: FROM pn_distributions_all

320: CURSOR chk_exists IS
321: SELECT'Y'
322: FROM dual
323: WHERE EXISTS (SELECT NULL
324: FROM pn_distributions_all
325: WHERE payment_term_id = p_payment_term_id
326: AND account_class = p_accnt_class);
327:
328: l_exists VARCHAR2(30) := 'N';

Line 330: l_line_number pn_distributions.line_number%TYPE;

326: AND account_class = p_accnt_class);
327:
328: l_exists VARCHAR2(30) := 'N';
329: l_context VARCHAR2(2000);
330: l_line_number pn_distributions.line_number%TYPE;
331:
332: CURSOR org_cur IS
333: SELECT org_id FROM pn_payment_terms_all WHERE payment_term_ID = p_payment_term_id;
334:

Line 357: FROM pn_distributions_all

353:
354: l_context := 'getting line NUMBER';
355: SELECT NVL(MAX (line_number),0) + 1
356: INTO l_line_number
357: FROM pn_distributions_all
358: WHERE payment_term_id = p_payment_term_id;
359:
360: pnp_debug_pkg.log('Line Number : ' || TO_CHAR(l_line_number) );
361:

Line 372: INSERT INTO pn_distributions_all (distribution_id,

368: ELSE
369: l_org_ID := p_org_id;
370: END IF;
371:
372: INSERT INTO pn_distributions_all (distribution_id,
373: payment_term_id,
374: account_id,
375: account_class,
376: percentage,

Line 384: VALUES (pn_distributions_s.nextval,

380: last_updated_by,
381: creation_date,
382: created_by,
383: org_id)
384: VALUES (pn_distributions_s.nextval,
385: p_payment_term_id,
386: p_accnt_ccid,
387: p_accnt_class,
388: p_percent,

Line 397: pnp_debug_pkg.log('Inserted INTO pn_distributions ...' );

393: SYSDATE,
394: FND_GLOBAL.USER_ID,
395: l_org_ID);
396:
397: pnp_debug_pkg.log('Inserted INTO pn_distributions ...' );
398: pnp_debug_pkg.log('Payment Term Id : '|| TO_CHAR(p_payment_term_id) );
399: pnp_debug_pkg.log('Account Class : '|| p_accnt_class );
400: pnp_debug_pkg.log('Account Id : '|| TO_CHAR(p_accnt_ccid) );
401: pnp_debug_pkg.log('Percentage : '|| TO_CHAR(p_percent) );