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_VAREN_PVT dependencies on PN_LEASE_DETAILS_ALL

Line 5958: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;

5954: IS
5955: l_return_status VARCHAR2 (1);
5956: l_ret_status VARCHAR2 (1);
5957: l_return_msg VARCHAR2 (10);
5958: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;
5959: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;
5960: l_purpose_code pn_var_templates_all.purpose_code%TYPE;
5961: l_type_code pn_var_templates_all.type_code%TYPE;
5962: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;

Line 5959: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;

5955: l_return_status VARCHAR2 (1);
5956: l_ret_status VARCHAR2 (1);
5957: l_return_msg VARCHAR2 (10);
5958: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;
5959: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;
5960: l_purpose_code pn_var_templates_all.purpose_code%TYPE;
5961: l_type_code pn_var_templates_all.type_code%TYPE;
5962: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
5963: l_invoice_on pn_var_templates_all.invoice_on%TYPE;

Line 7724: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;

7720: IS
7721: l_return_status VARCHAR2 (1);
7722: l_ret_status VARCHAR2 (1);
7723: l_return_msg VARCHAR2 (2000);
7724: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;
7725: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;
7726: l_purpose_code pn_var_templates_all.purpose_code%TYPE;
7727: l_type_code pn_var_templates_all.type_code%TYPE;
7728: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;

Line 7725: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;

7721: l_return_status VARCHAR2 (1);
7722: l_ret_status VARCHAR2 (1);
7723: l_return_msg VARCHAR2 (2000);
7724: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;
7725: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;
7726: l_purpose_code pn_var_templates_all.purpose_code%TYPE;
7727: l_type_code pn_var_templates_all.type_code%TYPE;
7728: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
7729: l_invoice_on pn_var_templates_all.invoice_on%TYPE;

Line 9271: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;

9267: l_var_rent_date_id pn_var_rent_dates_all.var_rent_date_id%TYPE;
9268: --
9269: l_location_id pn_locations_all.location_id%TYPE;
9270: -- l_location_code pn_locations_all.location_code%type;
9271: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;
9272: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;
9273: --
9274: -- l_rowid VARCHAR2( 18 ) := NULL;
9275: l_varentid NUMBER := NULL;

Line 9272: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;

9268: --
9269: l_location_id pn_locations_all.location_id%TYPE;
9270: -- l_location_code pn_locations_all.location_code%type;
9271: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;
9272: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;
9273: --
9274: -- l_rowid VARCHAR2( 18 ) := NULL;
9275: l_varentid NUMBER := NULL;
9276: l_rentnum VARCHAR2 (30) := NULL;