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_LEASE_PVT dependencies on PN_PAYMENT_TERMS_ALL

Line 14265: l_payment_term_type_code pn_payment_terms_all.payment_term_type_code %TYPE := NULL;

14261: l_record_count_accrual NUMBER := 0;
14262:
14263: l_acc_code VARCHAR2(100);
14264:
14265: l_payment_term_type_code pn_payment_terms_all.payment_term_type_code %TYPE := NULL;
14266: l_p_ar_term_id pn_payment_terms_all.ap_ar_term_id%TYPE := NULL;
14267: l_cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL;
14268: l_payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL;
14269: l_schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL;

Line 14266: l_p_ar_term_id pn_payment_terms_all.ap_ar_term_id%TYPE := NULL;

14262:
14263: l_acc_code VARCHAR2(100);
14264:
14265: l_payment_term_type_code pn_payment_terms_all.payment_term_type_code %TYPE := NULL;
14266: l_p_ar_term_id pn_payment_terms_all.ap_ar_term_id%TYPE := NULL;
14267: l_cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL;
14268: l_payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL;
14269: l_schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL;
14270: l_currency_code pn_payment_terms_all.currency_code%TYPE := NULL;

Line 14267: l_cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL;

14263: l_acc_code VARCHAR2(100);
14264:
14265: l_payment_term_type_code pn_payment_terms_all.payment_term_type_code %TYPE := NULL;
14266: l_p_ar_term_id pn_payment_terms_all.ap_ar_term_id%TYPE := NULL;
14267: l_cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL;
14268: l_payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL;
14269: l_schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL;
14270: l_currency_code pn_payment_terms_all.currency_code%TYPE := NULL;
14271: l_vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL;

Line 14268: l_payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL;

14264:
14265: l_payment_term_type_code pn_payment_terms_all.payment_term_type_code %TYPE := NULL;
14266: l_p_ar_term_id pn_payment_terms_all.ap_ar_term_id%TYPE := NULL;
14267: l_cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL;
14268: l_payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL;
14269: l_schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL;
14270: l_currency_code pn_payment_terms_all.currency_code%TYPE := NULL;
14271: l_vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL;
14272: l_vendor_site_id pn_payment_terms_all.vendor_site_id%TYPE := NULL;

Line 14269: l_schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL;

14265: l_payment_term_type_code pn_payment_terms_all.payment_term_type_code %TYPE := NULL;
14266: l_p_ar_term_id pn_payment_terms_all.ap_ar_term_id%TYPE := NULL;
14267: l_cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL;
14268: l_payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL;
14269: l_schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL;
14270: l_currency_code pn_payment_terms_all.currency_code%TYPE := NULL;
14271: l_vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL;
14272: l_vendor_site_id pn_payment_terms_all.vendor_site_id%TYPE := NULL;
14273: l_customer_id NUMBER := NULL;

Line 14270: l_currency_code pn_payment_terms_all.currency_code%TYPE := NULL;

14266: l_p_ar_term_id pn_payment_terms_all.ap_ar_term_id%TYPE := NULL;
14267: l_cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL;
14268: l_payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL;
14269: l_schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL;
14270: l_currency_code pn_payment_terms_all.currency_code%TYPE := NULL;
14271: l_vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL;
14272: l_vendor_site_id pn_payment_terms_all.vendor_site_id%TYPE := NULL;
14273: l_customer_id NUMBER := NULL;
14274: l_customer_site_use_id pn_payment_terms_all.customer_site_use_id%TYPE := NULL;

Line 14271: l_vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL;

14267: l_cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL;
14268: l_payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL;
14269: l_schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL;
14270: l_currency_code pn_payment_terms_all.currency_code%TYPE := NULL;
14271: l_vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL;
14272: l_vendor_site_id pn_payment_terms_all.vendor_site_id%TYPE := NULL;
14273: l_customer_id NUMBER := NULL;
14274: l_customer_site_use_id pn_payment_terms_all.customer_site_use_id%TYPE := NULL;
14275:

Line 14272: l_vendor_site_id pn_payment_terms_all.vendor_site_id%TYPE := NULL;

14268: l_payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL;
14269: l_schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL;
14270: l_currency_code pn_payment_terms_all.currency_code%TYPE := NULL;
14271: l_vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL;
14272: l_vendor_site_id pn_payment_terms_all.vendor_site_id%TYPE := NULL;
14273: l_customer_id NUMBER := NULL;
14274: l_customer_site_use_id pn_payment_terms_all.customer_site_use_id%TYPE := NULL;
14275:
14276: l_count_template NUMBER := NULL;

Line 14274: l_customer_site_use_id pn_payment_terms_all.customer_site_use_id%TYPE := NULL;

14270: l_currency_code pn_payment_terms_all.currency_code%TYPE := NULL;
14271: l_vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL;
14272: l_vendor_site_id pn_payment_terms_all.vendor_site_id%TYPE := NULL;
14273: l_customer_id NUMBER := NULL;
14274: l_customer_site_use_id pn_payment_terms_all.customer_site_use_id%TYPE := NULL;
14275:
14276: l_count_template NUMBER := NULL;
14277: l_acc_exist_count NUMBER := NULL;
14278: l_lia_exist_count NUMBER := NULL;

Line 14284: l_term_project_id pn_payment_terms_all.project_id%TYPE := NULL;

14280: l_project_info VARCHAR2(1):='N';
14281: l_check VARCHAR2(1) := NULL;
14282: l_check_date DATE;
14283:
14284: l_term_project_id pn_payment_terms_all.project_id%TYPE := NULL;
14285: l_term_task_id pn_payment_terms_all.task_id%TYPE := NULL;
14286: l_term_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;
14287: l_term_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;
14288: l_term_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;

Line 14285: l_term_task_id pn_payment_terms_all.task_id%TYPE := NULL;

14281: l_check VARCHAR2(1) := NULL;
14282: l_check_date DATE;
14283:
14284: l_term_project_id pn_payment_terms_all.project_id%TYPE := NULL;
14285: l_term_task_id pn_payment_terms_all.task_id%TYPE := NULL;
14286: l_term_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;
14287: l_term_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;
14288: l_term_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;
14289:

Line 14286: l_term_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;

14282: l_check_date DATE;
14283:
14284: l_term_project_id pn_payment_terms_all.project_id%TYPE := NULL;
14285: l_term_task_id pn_payment_terms_all.task_id%TYPE := NULL;
14286: l_term_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;
14287: l_term_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;
14288: l_term_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;
14289:
14290: CURSOR exp_rev_account_cur(l_term_template_id NUMBER,l_account_class VARCHAR2)

Line 14287: l_term_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;

14283:
14284: l_term_project_id pn_payment_terms_all.project_id%TYPE := NULL;
14285: l_term_task_id pn_payment_terms_all.task_id%TYPE := NULL;
14286: l_term_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;
14287: l_term_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;
14288: l_term_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;
14289:
14290: CURSOR exp_rev_account_cur(l_term_template_id NUMBER,l_account_class VARCHAR2)
14291: is

Line 14288: l_term_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;

14284: l_term_project_id pn_payment_terms_all.project_id%TYPE := NULL;
14285: l_term_task_id pn_payment_terms_all.task_id%TYPE := NULL;
14286: l_term_expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL;
14287: l_term_expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL;
14288: l_term_organization_id pn_payment_terms_all.organization_id%TYPE := NULL;
14289:
14290: CURSOR exp_rev_account_cur(l_term_template_id NUMBER,l_account_class VARCHAR2)
14291: is
14292: select account_id,percentage

Line 14439: FROM pn_payment_terms_all

14435: ELSE
14436: ------dbms_output.put_line('TermTemplate:HELLO:3'||p_operation);
14437: SELECT COUNT(1)
14438: INTO l_count_template
14439: FROM pn_payment_terms_all
14440: WHERE payment_term_id = p_payment_terms_tbl(i).payment_term_id
14441: AND term_template_id = p_payment_terms_tbl(i).term_template_id
14442: AND org_id = g_org_id;
14443: IF(l_count_template=1) THEN

Line 15514: FROM pn_payment_terms_all

15510: , l_term_task_id--p_payment_terms_tbl(i).task_id
15511: , l_term_expenditure_type--p_payment_terms_tbl(i).expenditure_type
15512: , l_term_expenditure_item_date--p_payment_terms_tbl(i).expenditure_item_date
15513: , l_term_organization_id--p_payment_terms_tbl(i).organization_id
15514: FROM pn_payment_terms_all
15515: WHERE payment_term_id = p_payment_terms_tbl(i).payment_term_id
15516: AND org_id = g_org_id;
15517: EXCEPTION
15518: WHEN OTHERS THEN

Line 16716: --l_payterm_rec pn_payment_terms_all%ROWTYPE;

16712: l_lease_commencement_date DATE;
16713: l_lease_termination_date DATE;
16714: l_parent_lease_id NUMBER;
16715: --l_pterm_rec payments_rec_type := p_pterm_rec;
16716: --l_payterm_rec pn_payment_terms_all%ROWTYPE;
16717: l_termtemp_type pn_term_templates_all.payment_term_type_code%TYPE;
16718: l_schedule_context VARCHAR2(10) := NULL;
16719: l_requestid NUMBER := NULL;
16720:

Line 16732: FROM pn_payment_terms_all

16728:
16729: CURSOR cur_payment_terms(p_payment_term_id NUMBER)
16730: IS
16731: SELECT *
16732: FROM pn_payment_terms_all
16733: WHERE payment_term_id = p_payment_term_id;
16734:
16735: CURSOR cur_dist_details(p_payment_term_id NUMBER)
16736: IS