APPS.PN_LEASE_PVT dependencies on PN_TERM_TEMPLATES_ALL

Line 3875: l_term_template_type pn_term_templates_all.term_template_type%TYPE;

3871: IS
3872: l_lease_rec lease_rec;
3873: l_return_status VARCHAR2 (30) := NULL;
3874: l_org_id NUMBER := g_org_id;--pn_mo_cache_utils.get_profile_value('org_id');--pn_mo_cache_utils.get_current_org_id;
3875: l_term_template_type pn_term_templates_all.term_template_type%TYPE;
3876: l_api_name CONSTANT VARCHAR2 (30) := p_operation;
3877: l_api_name_full CONSTANT VARCHAR2 (61) := g_pkg_name || '.'|| l_api_name;
3878: l_error_flag VARCHAR2(1);
3879: l_tcc_status VARCHAR2(30);

Line 13891: FROM pn_term_templates_all

13887: , location_id
13888: , term_template_type
13889: , tax_classification_code
13890: , include_in_var_rent
13891: FROM pn_term_templates_all
13892: WHERE term_template_id = p_term_temp_id
13893: AND active = 'Y';
13894:
13895: l_term_defaults cur_term_template%ROWTYPE;

Line 14423: FROM pn_term_templates_all

14419: ,l_vendor_id
14420: ,l_vendor_site_id
14421: ,l_customer_id
14422: ,l_customer_site_use_id
14423: FROM pn_term_templates_all
14424: WHERE term_template_id = p_payment_terms_tbl(i).term_template_id;
14425:
14426: EXCEPTION
14427: WHEN OTHERS THEN

Line 16717: l_termtemp_type pn_term_templates_all.payment_term_type_code%TYPE;

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:
16721: l_assign_flag VARCHAR2(1):= 'N';

Line 17777: l_termtemp_type pn_term_templates_all.payment_term_type_code%TYPE;

17773: l_lease_class_code VARCHAR2 (30);
17774: l_lease_commencement_date DATE;
17775: l_lease_termination_date DATE;
17776: l_parent_lease_id NUMBER;
17777: l_termtemp_type pn_term_templates_all.payment_term_type_code%TYPE;
17778: l_schedule_context VARCHAR2(10) := NULL;
17779: l_requestid NUMBER := NULL;
17780: l_lease_change_id NUMBER;
17781: x_request_id NUMBER:=NULL;