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 FND_LOOKUP_TYPES

Line 13: l_leasetype_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_TYPE';

9: g_user_id CONSTANT NUMBER := fnd_global.user_id;
10: g_login_id CONSTANT NUMBER := fnd_global.login_id;
11: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');
12: -- Variables to hold the lookup_types
13: l_leasetype_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_TYPE';
14: l_leaseclass_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_CLASS';
15: l_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_STATUS_TYPE';
16: l_lease_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASESTATUS_TYPE';
17: l_proration_rule_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_PRORATION_RULE';

Line 14: l_leaseclass_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_CLASS';

10: g_login_id CONSTANT NUMBER := fnd_global.login_id;
11: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');
12: -- Variables to hold the lookup_types
13: l_leasetype_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_TYPE';
14: l_leaseclass_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_CLASS';
15: l_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_STATUS_TYPE';
16: l_lease_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASESTATUS_TYPE';
17: l_proration_rule_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_PRORATION_RULE';
18: l_lease_role_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_ROLE_TYPE';

Line 15: l_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_STATUS_TYPE';

11: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');
12: -- Variables to hold the lookup_types
13: l_leasetype_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_TYPE';
14: l_leaseclass_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_CLASS';
15: l_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_STATUS_TYPE';
16: l_lease_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASESTATUS_TYPE';
17: l_proration_rule_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_PRORATION_RULE';
18: l_lease_role_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_ROLE_TYPE';
19: l_lease_tenancy_usage_lookup fnd_lookup_types.lookup_type%TYPE := 'PN_TENANCY_USAGE_TYPE';

Line 16: l_lease_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASESTATUS_TYPE';

12: -- Variables to hold the lookup_types
13: l_leasetype_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_TYPE';
14: l_leaseclass_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_CLASS';
15: l_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_STATUS_TYPE';
16: l_lease_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASESTATUS_TYPE';
17: l_proration_rule_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_PRORATION_RULE';
18: l_lease_role_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_ROLE_TYPE';
19: l_lease_tenancy_usage_lookup fnd_lookup_types.lookup_type%TYPE := 'PN_TENANCY_USAGE_TYPE';
20: l_tenancy_recovery_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_TYPE';

Line 17: l_proration_rule_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_PRORATION_RULE';

13: l_leasetype_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_TYPE';
14: l_leaseclass_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_CLASS';
15: l_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_STATUS_TYPE';
16: l_lease_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASESTATUS_TYPE';
17: l_proration_rule_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_PRORATION_RULE';
18: l_lease_role_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_ROLE_TYPE';
19: l_lease_tenancy_usage_lookup fnd_lookup_types.lookup_type%TYPE := 'PN_TENANCY_USAGE_TYPE';
20: l_tenancy_recovery_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_TYPE';
21: l_recovery_space_std_lkp_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_SPACE_STD_TYPE';

Line 18: l_lease_role_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_ROLE_TYPE';

14: l_leaseclass_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_CLASS';
15: l_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_STATUS_TYPE';
16: l_lease_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASESTATUS_TYPE';
17: l_proration_rule_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_PRORATION_RULE';
18: l_lease_role_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_ROLE_TYPE';
19: l_lease_tenancy_usage_lookup fnd_lookup_types.lookup_type%TYPE := 'PN_TENANCY_USAGE_TYPE';
20: l_tenancy_recovery_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_TYPE';
21: l_recovery_space_std_lkp_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_SPACE_STD_TYPE';
22:

Line 19: l_lease_tenancy_usage_lookup fnd_lookup_types.lookup_type%TYPE := 'PN_TENANCY_USAGE_TYPE';

15: l_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_STATUS_TYPE';
16: l_lease_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASESTATUS_TYPE';
17: l_proration_rule_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_PRORATION_RULE';
18: l_lease_role_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_ROLE_TYPE';
19: l_lease_tenancy_usage_lookup fnd_lookup_types.lookup_type%TYPE := 'PN_TENANCY_USAGE_TYPE';
20: l_tenancy_recovery_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_TYPE';
21: l_recovery_space_std_lkp_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_SPACE_STD_TYPE';
22:
23: l_pn_payment_term_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_TERM_TYPE';

Line 20: l_tenancy_recovery_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_TYPE';

16: l_lease_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASESTATUS_TYPE';
17: l_proration_rule_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_PRORATION_RULE';
18: l_lease_role_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_ROLE_TYPE';
19: l_lease_tenancy_usage_lookup fnd_lookup_types.lookup_type%TYPE := 'PN_TENANCY_USAGE_TYPE';
20: l_tenancy_recovery_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_TYPE';
21: l_recovery_space_std_lkp_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_SPACE_STD_TYPE';
22:
23: l_pn_payment_term_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_TERM_TYPE';
24: l_pn_payment_purpose_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_PURPOSE_TYPE';

Line 21: l_recovery_space_std_lkp_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_SPACE_STD_TYPE';

17: l_proration_rule_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_PRORATION_RULE';
18: l_lease_role_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_ROLE_TYPE';
19: l_lease_tenancy_usage_lookup fnd_lookup_types.lookup_type%TYPE := 'PN_TENANCY_USAGE_TYPE';
20: l_tenancy_recovery_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_TYPE';
21: l_recovery_space_std_lkp_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_SPACE_STD_TYPE';
22:
23: l_pn_payment_term_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_TERM_TYPE';
24: l_pn_payment_purpose_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_PURPOSE_TYPE';
25: l_pn_term_source_module fnd_lookup_types.lookup_type%TYPE := 'PN_TERM_SOURCE_MODULE';

Line 23: l_pn_payment_term_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_TERM_TYPE';

19: l_lease_tenancy_usage_lookup fnd_lookup_types.lookup_type%TYPE := 'PN_TENANCY_USAGE_TYPE';
20: l_tenancy_recovery_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_TYPE';
21: l_recovery_space_std_lkp_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_SPACE_STD_TYPE';
22:
23: l_pn_payment_term_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_TERM_TYPE';
24: l_pn_payment_purpose_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_PURPOSE_TYPE';
25: l_pn_term_source_module fnd_lookup_types.lookup_type%TYPE := 'PN_TERM_SOURCE_MODULE';
26: l_pn_payment_frequency_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_FREQUENCY_TYPE';
27: l_pn_note_type fnd_lookup_types.lookup_type%TYPE := 'PN_NOTE_TYPE';

Line 24: l_pn_payment_purpose_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_PURPOSE_TYPE';

20: l_tenancy_recovery_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_TYPE';
21: l_recovery_space_std_lkp_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_SPACE_STD_TYPE';
22:
23: l_pn_payment_term_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_TERM_TYPE';
24: l_pn_payment_purpose_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_PURPOSE_TYPE';
25: l_pn_term_source_module fnd_lookup_types.lookup_type%TYPE := 'PN_TERM_SOURCE_MODULE';
26: l_pn_payment_frequency_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_FREQUENCY_TYPE';
27: l_pn_note_type fnd_lookup_types.lookup_type%TYPE := 'PN_NOTE_TYPE';
28: l_pn_rights_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHTS_TYPE';

Line 25: l_pn_term_source_module fnd_lookup_types.lookup_type%TYPE := 'PN_TERM_SOURCE_MODULE';

21: l_recovery_space_std_lkp_type fnd_lookup_types.lookup_type%TYPE := 'PN_RECOVERY_SPACE_STD_TYPE';
22:
23: l_pn_payment_term_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_TERM_TYPE';
24: l_pn_payment_purpose_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_PURPOSE_TYPE';
25: l_pn_term_source_module fnd_lookup_types.lookup_type%TYPE := 'PN_TERM_SOURCE_MODULE';
26: l_pn_payment_frequency_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_FREQUENCY_TYPE';
27: l_pn_note_type fnd_lookup_types.lookup_type%TYPE := 'PN_NOTE_TYPE';
28: l_pn_rights_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHTS_TYPE';
29: l_pn_right_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHT_STATUS_TYPE';

Line 26: l_pn_payment_frequency_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_FREQUENCY_TYPE';

22:
23: l_pn_payment_term_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_TERM_TYPE';
24: l_pn_payment_purpose_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_PURPOSE_TYPE';
25: l_pn_term_source_module fnd_lookup_types.lookup_type%TYPE := 'PN_TERM_SOURCE_MODULE';
26: l_pn_payment_frequency_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_FREQUENCY_TYPE';
27: l_pn_note_type fnd_lookup_types.lookup_type%TYPE := 'PN_NOTE_TYPE';
28: l_pn_rights_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHTS_TYPE';
29: l_pn_right_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHT_STATUS_TYPE';
30: l_pn_status fnd_lookup_types.lookup_type%TYPE := 'PN_STATUS';

Line 27: l_pn_note_type fnd_lookup_types.lookup_type%TYPE := 'PN_NOTE_TYPE';

23: l_pn_payment_term_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_TERM_TYPE';
24: l_pn_payment_purpose_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_PURPOSE_TYPE';
25: l_pn_term_source_module fnd_lookup_types.lookup_type%TYPE := 'PN_TERM_SOURCE_MODULE';
26: l_pn_payment_frequency_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_FREQUENCY_TYPE';
27: l_pn_note_type fnd_lookup_types.lookup_type%TYPE := 'PN_NOTE_TYPE';
28: l_pn_rights_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHTS_TYPE';
29: l_pn_right_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHT_STATUS_TYPE';
30: l_pn_status fnd_lookup_types.lookup_type%TYPE := 'PN_STATUS';
31: l_pn_landlord_service_type fnd_lookup_types.lookup_type%TYPE := 'PN_LANDLORD_SERVICE_TYPE';

Line 28: l_pn_rights_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHTS_TYPE';

24: l_pn_payment_purpose_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_PURPOSE_TYPE';
25: l_pn_term_source_module fnd_lookup_types.lookup_type%TYPE := 'PN_TERM_SOURCE_MODULE';
26: l_pn_payment_frequency_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_FREQUENCY_TYPE';
27: l_pn_note_type fnd_lookup_types.lookup_type%TYPE := 'PN_NOTE_TYPE';
28: l_pn_rights_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHTS_TYPE';
29: l_pn_right_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHT_STATUS_TYPE';
30: l_pn_status fnd_lookup_types.lookup_type%TYPE := 'PN_STATUS';
31: l_pn_landlord_service_type fnd_lookup_types.lookup_type%TYPE := 'PN_LANDLORD_SERVICE_TYPE';
32: l_pn_obligation_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_RESP_TYPE';

Line 29: l_pn_right_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHT_STATUS_TYPE';

25: l_pn_term_source_module fnd_lookup_types.lookup_type%TYPE := 'PN_TERM_SOURCE_MODULE';
26: l_pn_payment_frequency_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_FREQUENCY_TYPE';
27: l_pn_note_type fnd_lookup_types.lookup_type%TYPE := 'PN_NOTE_TYPE';
28: l_pn_rights_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHTS_TYPE';
29: l_pn_right_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHT_STATUS_TYPE';
30: l_pn_status fnd_lookup_types.lookup_type%TYPE := 'PN_STATUS';
31: l_pn_landlord_service_type fnd_lookup_types.lookup_type%TYPE := 'PN_LANDLORD_SERVICE_TYPE';
32: l_pn_obligation_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_RESP_TYPE';
33: l_pn_obligation_fin_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_FIN_RESP_PARTY';

Line 30: l_pn_status fnd_lookup_types.lookup_type%TYPE := 'PN_STATUS';

26: l_pn_payment_frequency_type fnd_lookup_types.lookup_type%TYPE := 'PN_PAYMENT_FREQUENCY_TYPE';
27: l_pn_note_type fnd_lookup_types.lookup_type%TYPE := 'PN_NOTE_TYPE';
28: l_pn_rights_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHTS_TYPE';
29: l_pn_right_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHT_STATUS_TYPE';
30: l_pn_status fnd_lookup_types.lookup_type%TYPE := 'PN_STATUS';
31: l_pn_landlord_service_type fnd_lookup_types.lookup_type%TYPE := 'PN_LANDLORD_SERVICE_TYPE';
32: l_pn_obligation_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_RESP_TYPE';
33: l_pn_obligation_fin_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_FIN_RESP_PARTY';
34: l_pn_insurance_type fnd_lookup_types.lookup_type%TYPE := 'PN_INSURANCE_TYPE';

Line 31: l_pn_landlord_service_type fnd_lookup_types.lookup_type%TYPE := 'PN_LANDLORD_SERVICE_TYPE';

27: l_pn_note_type fnd_lookup_types.lookup_type%TYPE := 'PN_NOTE_TYPE';
28: l_pn_rights_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHTS_TYPE';
29: l_pn_right_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHT_STATUS_TYPE';
30: l_pn_status fnd_lookup_types.lookup_type%TYPE := 'PN_STATUS';
31: l_pn_landlord_service_type fnd_lookup_types.lookup_type%TYPE := 'PN_LANDLORD_SERVICE_TYPE';
32: l_pn_obligation_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_RESP_TYPE';
33: l_pn_obligation_fin_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_FIN_RESP_PARTY';
34: l_pn_insurance_type fnd_lookup_types.lookup_type%TYPE := 'PN_INSURANCE_TYPE';
35: l_pn_units_of_measures fnd_lookup_types.lookup_type%TYPE := 'PN_UNITS_OF_MEASURE';

Line 32: l_pn_obligation_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_RESP_TYPE';

28: l_pn_rights_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHTS_TYPE';
29: l_pn_right_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHT_STATUS_TYPE';
30: l_pn_status fnd_lookup_types.lookup_type%TYPE := 'PN_STATUS';
31: l_pn_landlord_service_type fnd_lookup_types.lookup_type%TYPE := 'PN_LANDLORD_SERVICE_TYPE';
32: l_pn_obligation_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_RESP_TYPE';
33: l_pn_obligation_fin_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_FIN_RESP_PARTY';
34: l_pn_insurance_type fnd_lookup_types.lookup_type%TYPE := 'PN_INSURANCE_TYPE';
35: l_pn_units_of_measures fnd_lookup_types.lookup_type%TYPE := 'PN_UNITS_OF_MEASURE';
36: l_pn_lease_option_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_OPTION_TYPE';

Line 33: l_pn_obligation_fin_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_FIN_RESP_PARTY';

29: l_pn_right_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_RIGHT_STATUS_TYPE';
30: l_pn_status fnd_lookup_types.lookup_type%TYPE := 'PN_STATUS';
31: l_pn_landlord_service_type fnd_lookup_types.lookup_type%TYPE := 'PN_LANDLORD_SERVICE_TYPE';
32: l_pn_obligation_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_RESP_TYPE';
33: l_pn_obligation_fin_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_FIN_RESP_PARTY';
34: l_pn_insurance_type fnd_lookup_types.lookup_type%TYPE := 'PN_INSURANCE_TYPE';
35: l_pn_units_of_measures fnd_lookup_types.lookup_type%TYPE := 'PN_UNITS_OF_MEASURE';
36: l_pn_lease_option_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_OPTION_TYPE';
37: l_pn_option_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_OPTION_STATUS_TYPE';

Line 34: l_pn_insurance_type fnd_lookup_types.lookup_type%TYPE := 'PN_INSURANCE_TYPE';

30: l_pn_status fnd_lookup_types.lookup_type%TYPE := 'PN_STATUS';
31: l_pn_landlord_service_type fnd_lookup_types.lookup_type%TYPE := 'PN_LANDLORD_SERVICE_TYPE';
32: l_pn_obligation_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_RESP_TYPE';
33: l_pn_obligation_fin_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_FIN_RESP_PARTY';
34: l_pn_insurance_type fnd_lookup_types.lookup_type%TYPE := 'PN_INSURANCE_TYPE';
35: l_pn_units_of_measures fnd_lookup_types.lookup_type%TYPE := 'PN_UNITS_OF_MEASURE';
36: l_pn_lease_option_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_OPTION_TYPE';
37: l_pn_option_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_OPTION_STATUS_TYPE';
38: l_pn_yes_no fnd_lookup_types.lookup_type%TYPE := 'PN_YES_NO';

Line 35: l_pn_units_of_measures fnd_lookup_types.lookup_type%TYPE := 'PN_UNITS_OF_MEASURE';

31: l_pn_landlord_service_type fnd_lookup_types.lookup_type%TYPE := 'PN_LANDLORD_SERVICE_TYPE';
32: l_pn_obligation_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_RESP_TYPE';
33: l_pn_obligation_fin_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_FIN_RESP_PARTY';
34: l_pn_insurance_type fnd_lookup_types.lookup_type%TYPE := 'PN_INSURANCE_TYPE';
35: l_pn_units_of_measures fnd_lookup_types.lookup_type%TYPE := 'PN_UNITS_OF_MEASURE';
36: l_pn_lease_option_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_OPTION_TYPE';
37: l_pn_option_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_OPTION_STATUS_TYPE';
38: l_pn_yes_no fnd_lookup_types.lookup_type%TYPE := 'PN_YES_NO';
39: l_pn_milestones_type fnd_lookup_types.lookup_type%TYPE := 'PN_MILESTONES_TYPE';

Line 36: l_pn_lease_option_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_OPTION_TYPE';

32: l_pn_obligation_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_RESP_TYPE';
33: l_pn_obligation_fin_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_FIN_RESP_PARTY';
34: l_pn_insurance_type fnd_lookup_types.lookup_type%TYPE := 'PN_INSURANCE_TYPE';
35: l_pn_units_of_measures fnd_lookup_types.lookup_type%TYPE := 'PN_UNITS_OF_MEASURE';
36: l_pn_lease_option_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_OPTION_TYPE';
37: l_pn_option_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_OPTION_STATUS_TYPE';
38: l_pn_yes_no fnd_lookup_types.lookup_type%TYPE := 'PN_YES_NO';
39: l_pn_milestones_type fnd_lookup_types.lookup_type%TYPE := 'PN_MILESTONES_TYPE';
40:

Line 37: l_pn_option_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_OPTION_STATUS_TYPE';

33: l_pn_obligation_fin_resp_type fnd_lookup_types.lookup_type%TYPE := 'PN_OBLIGATION_FIN_RESP_PARTY';
34: l_pn_insurance_type fnd_lookup_types.lookup_type%TYPE := 'PN_INSURANCE_TYPE';
35: l_pn_units_of_measures fnd_lookup_types.lookup_type%TYPE := 'PN_UNITS_OF_MEASURE';
36: l_pn_lease_option_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_OPTION_TYPE';
37: l_pn_option_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_OPTION_STATUS_TYPE';
38: l_pn_yes_no fnd_lookup_types.lookup_type%TYPE := 'PN_YES_NO';
39: l_pn_milestones_type fnd_lookup_types.lookup_type%TYPE := 'PN_MILESTONES_TYPE';
40:
41: l_param_milestone_type VARCHAR2 (30) := 'P_MILESTONE_TYPE';

Line 38: l_pn_yes_no fnd_lookup_types.lookup_type%TYPE := 'PN_YES_NO';

34: l_pn_insurance_type fnd_lookup_types.lookup_type%TYPE := 'PN_INSURANCE_TYPE';
35: l_pn_units_of_measures fnd_lookup_types.lookup_type%TYPE := 'PN_UNITS_OF_MEASURE';
36: l_pn_lease_option_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_OPTION_TYPE';
37: l_pn_option_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_OPTION_STATUS_TYPE';
38: l_pn_yes_no fnd_lookup_types.lookup_type%TYPE := 'PN_YES_NO';
39: l_pn_milestones_type fnd_lookup_types.lookup_type%TYPE := 'PN_MILESTONES_TYPE';
40:
41: l_param_milestone_type VARCHAR2 (30) := 'P_MILESTONE_TYPE';
42: l_param_milestone_user_name VARCHAR2 (30) := 'P_MILESTONE_USER_NAME';

Line 39: l_pn_milestones_type fnd_lookup_types.lookup_type%TYPE := 'PN_MILESTONES_TYPE';

35: l_pn_units_of_measures fnd_lookup_types.lookup_type%TYPE := 'PN_UNITS_OF_MEASURE';
36: l_pn_lease_option_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_OPTION_TYPE';
37: l_pn_option_status_type fnd_lookup_types.lookup_type%TYPE := 'PN_OPTION_STATUS_TYPE';
38: l_pn_yes_no fnd_lookup_types.lookup_type%TYPE := 'PN_YES_NO';
39: l_pn_milestones_type fnd_lookup_types.lookup_type%TYPE := 'PN_MILESTONES_TYPE';
40:
41: l_param_milestone_type VARCHAR2 (30) := 'P_MILESTONE_TYPE';
42: l_param_milestone_user_name VARCHAR2 (30) := 'P_MILESTONE_USER_NAME';
43: l_param_notice_given_type VARCHAR2 (30) := 'P_NOTICE_GIVEN_TYPE';

Line 18671: l_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_STATUS_TYPE';

18667: --l_org_id NUMBER := g_org_id;
18668: l_api_name CONSTANT VARCHAR2 (30) := p_operation;
18669: --l_api_name_full CONSTANT VARCHAR2 (61) := g_pkg_name || '.'|| l_api_name; This line should be uncommented
18670: l_param_status VARCHAR2 (30) := 'P_APPROVAL_STATUS';
18671: l_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_STATUS_TYPE';
18672: l_param_lease_status VARCHAR2 (30) := 'P_LEASE_STATUS';
18673: l_lease_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASESTATUS_TYPE';
18674: l_error_flag VARCHAR2(1) := 'Y';
18675: l_lease_id NUMBER;

Line 18673: l_lease_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASESTATUS_TYPE';

18669: --l_api_name_full CONSTANT VARCHAR2 (61) := g_pkg_name || '.'|| l_api_name; This line should be uncommented
18670: l_param_status VARCHAR2 (30) := 'P_APPROVAL_STATUS';
18671: l_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASE_STATUS_TYPE';
18672: l_param_lease_status VARCHAR2 (30) := 'P_LEASE_STATUS';
18673: l_lease_status_lookup_type fnd_lookup_types.lookup_type%TYPE := 'PN_LEASESTATUS_TYPE';
18674: l_error_flag VARCHAR2(1) := 'Y';
18675: l_lease_id NUMBER;
18676: l_approval_status_old VARCHAR2 (30);
18677: l_lease_status_old VARCHAR2 (30);