eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_APPROVE_VARENT_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 135: pn_payment_terms_all pmt

131: decode(ip_rent_type,'FORECASTED',inv.forecasted_term_status,'ACTUAL',inv.actual_term_status,
132: 'VARIANCE',inv.variance_term_status) term_status
133: FROM pn_var_rent_inv_all inv,
134: pn_var_periods_all per,
135: pn_payment_terms_all pmt
136: WHERE per.var_rent_id = inv.var_rent_id
137: AND per.period_id = inv.period_id
138: AND inv.var_rent_id = ip_var_rent_id
139: AND per.period_num >= NVL(p_period_num_from,per.period_num)

Line 444: FROM pn_payment_terms_all

440: ,distribution_set_id
441: ,org_id
442: ,customer_id
443: ,CUSTOMER_SITE_USE_ID
444: FROM pn_payment_terms_all
445: WHERE var_rent_inv_id = ip_var_rent_inv_id
446: /*AND var_rent_type = ip_rent_type*/;
447:
448: /* get the distributions for a term */

Line 487: l_normalize pn_payment_terms_all.normalize%TYPE := NULL;

483: l_actual_amt pn_payment_terms.actual_amount%TYPE := NULL;
484: l_schedule_day pn_payment_terms.schedule_day%TYPE := NULL;
485: l_start_date pn_payment_terms.start_date%TYPE := NULL;
486: l_end_date pn_payment_terms.end_date%TYPE := NULL;
487: l_normalize pn_payment_terms_all.normalize%TYPE := NULL;
488: l_project_id pn_payment_terms_all.project_id%TYPE := NULL;
489: l_task_id pn_payment_terms_all.task_id%TYPE := NULL;
490: l_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;
491: l_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;

Line 488: l_project_id pn_payment_terms_all.project_id%TYPE := NULL;

484: l_schedule_day pn_payment_terms.schedule_day%TYPE := NULL;
485: l_start_date pn_payment_terms.start_date%TYPE := NULL;
486: l_end_date pn_payment_terms.end_date%TYPE := NULL;
487: l_normalize pn_payment_terms_all.normalize%TYPE := NULL;
488: l_project_id pn_payment_terms_all.project_id%TYPE := NULL;
489: l_task_id pn_payment_terms_all.task_id%TYPE := NULL;
490: l_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;
491: l_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;
492: l_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;

Line 489: l_task_id pn_payment_terms_all.task_id%TYPE := NULL;

485: l_start_date pn_payment_terms.start_date%TYPE := NULL;
486: l_end_date pn_payment_terms.end_date%TYPE := NULL;
487: l_normalize pn_payment_terms_all.normalize%TYPE := NULL;
488: l_project_id pn_payment_terms_all.project_id%TYPE := NULL;
489: l_task_id pn_payment_terms_all.task_id%TYPE := NULL;
490: l_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;
491: l_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;
492: l_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;
493: l_distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL;

Line 490: l_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;

486: l_end_date pn_payment_terms.end_date%TYPE := NULL;
487: l_normalize pn_payment_terms_all.normalize%TYPE := NULL;
488: l_project_id pn_payment_terms_all.project_id%TYPE := NULL;
489: l_task_id pn_payment_terms_all.task_id%TYPE := NULL;
490: l_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;
491: l_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;
492: l_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;
493: l_distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL;
494: l_org_id pn_payment_terms_all.org_id%TYPE;

Line 491: l_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;

487: l_normalize pn_payment_terms_all.normalize%TYPE := NULL;
488: l_project_id pn_payment_terms_all.project_id%TYPE := NULL;
489: l_task_id pn_payment_terms_all.task_id%TYPE := NULL;
490: l_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;
491: l_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;
492: l_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;
493: l_distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL;
494: l_org_id pn_payment_terms_all.org_id%TYPE;
495: l_cust_id pn_payment_terms_all.customer_id%type;

Line 492: l_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;

488: l_project_id pn_payment_terms_all.project_id%TYPE := NULL;
489: l_task_id pn_payment_terms_all.task_id%TYPE := NULL;
490: l_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;
491: l_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;
492: l_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;
493: l_distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL;
494: l_org_id pn_payment_terms_all.org_id%TYPE;
495: l_cust_id pn_payment_terms_all.customer_id%type;
496: l_cust_site_id pn_payment_terms_all.CUSTOMER_SITE_USE_ID%type;

Line 493: l_distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL;

489: l_task_id pn_payment_terms_all.task_id%TYPE := NULL;
490: l_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;
491: l_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;
492: l_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;
493: l_distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL;
494: l_org_id pn_payment_terms_all.org_id%TYPE;
495: l_cust_id pn_payment_terms_all.customer_id%type;
496: l_cust_site_id pn_payment_terms_all.CUSTOMER_SITE_USE_ID%type;
497: l_errmsg1 VARCHAR2(2000);

Line 494: l_org_id pn_payment_terms_all.org_id%TYPE;

490: l_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;
491: l_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;
492: l_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;
493: l_distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL;
494: l_org_id pn_payment_terms_all.org_id%TYPE;
495: l_cust_id pn_payment_terms_all.customer_id%type;
496: l_cust_site_id pn_payment_terms_all.CUSTOMER_SITE_USE_ID%type;
497: l_errmsg1 VARCHAR2(2000);
498:

Line 495: l_cust_id pn_payment_terms_all.customer_id%type;

491: l_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;
492: l_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;
493: l_distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL;
494: l_org_id pn_payment_terms_all.org_id%TYPE;
495: l_cust_id pn_payment_terms_all.customer_id%type;
496: l_cust_site_id pn_payment_terms_all.CUSTOMER_SITE_USE_ID%type;
497: l_errmsg1 VARCHAR2(2000);
498:
499:

Line 496: l_cust_site_id pn_payment_terms_all.CUSTOMER_SITE_USE_ID%type;

492: l_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;
493: l_distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL;
494: l_org_id pn_payment_terms_all.org_id%TYPE;
495: l_cust_id pn_payment_terms_all.customer_id%type;
496: l_cust_site_id pn_payment_terms_all.CUSTOMER_SITE_USE_ID%type;
497: l_errmsg1 VARCHAR2(2000);
498:
499:
500: E_NO_CUST EXCEPTION; /*Exception added for bug#6412170 */

Line 875: UPDATE pn_payment_terms_all

871: ,p_term_id => l_payment_term_id
872: ,p_term_end_dt => NULL);
873:
874: IF NVL(l_retcode,-1) <> 2 THEN
875: UPDATE pn_payment_terms_all
876: SET status = 'APPROVED',
877: last_update_date = SYSDATE,
878: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
879: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),