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_LOOKUPS

Line 5481: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;

5477: )
5478: IS
5479: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5480: l_index BINARY_INTEGER;
5481: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
5482: l_lookup_code PN_NOTE_HEADERS.NOTE_TYPE_LOOKUP_CODE%TYPE := pn_lease_utils.g_pn_miss_char;
5483: l_cur_id NUMBER;
5484: l_tbl_index BINARY_INTEGER;
5485: l_tbl_flag NUMBER := 1;

Line 5842: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;

5838: )
5839: IS
5840: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5841: l_index BINARY_INTEGER;
5842: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
5843: l_lookup_code PN_NOTE_HEADERS.NOTE_TYPE_LOOKUP_CODE%TYPE := pn_lease_utils.g_pn_miss_char;
5844: l_cur_id NUMBER;
5845: l_tbl_index BINARY_INTEGER;
5846: l_tbl_flag NUMBER ;

Line 6333: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;

6329: ,x_return_status IN OUT NOCOPY VARCHAR2
6330: )IS
6331: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
6332: l_index BINARY_INTEGER;
6333: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
6334: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
6335: l_cur_id NUMBER;
6336: l_tbl_index BINARY_INTEGER;
6337: l_tbl_flag NUMBER := 1;

Line 6334: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;

6330: )IS
6331: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
6332: l_index BINARY_INTEGER;
6333: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
6334: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
6335: l_cur_id NUMBER;
6336: l_tbl_index BINARY_INTEGER;
6337: l_tbl_flag NUMBER := 1;
6338: l_tbl temp_tbl_type;

Line 6678: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;

6674: )
6675: IS
6676: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
6677: l_index BINARY_INTEGER;
6678: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
6679: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
6680: l_cur_id NUMBER;
6681: l_tbl_index BINARY_INTEGER;
6682: l_tbl_flag NUMBER ;

Line 6679: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;

6675: IS
6676: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
6677: l_index BINARY_INTEGER;
6678: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
6679: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
6680: l_cur_id NUMBER;
6681: l_tbl_index BINARY_INTEGER;
6682: l_tbl_flag NUMBER ;
6683: l_tbl temp_tbl_type;

Line 7205: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE ;

7201: )
7202: IS
7203: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7204: l_index BINARY_INTEGER ;
7205: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE ;
7206: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE ;
7207: l_company_id NUMBER ;
7208: l_tbl_index BINARY_INTEGER ;
7209: l_tbl_flag NUMBER := 1 ;

Line 7206: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE ;

7202: IS
7203: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7204: l_index BINARY_INTEGER ;
7205: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE ;
7206: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE ;
7207: l_company_id NUMBER ;
7208: l_tbl_index BINARY_INTEGER ;
7209: l_tbl_flag NUMBER := 1 ;
7210: l_tbl temp_tbl_type ;

Line 7678: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;

7674: )
7675: IS
7676: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7677: l_index BINARY_INTEGER;
7678: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
7679: l_landlord_service_id PN_LANDLORD_SERVICES_ALL.LANDLORD_SERVICE_ID%TYPE;
7680: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
7681: l_company_id PN_LANDLORD_SERVICES_ALL.company_id%type ;
7682: l_cur_id NUMBER;

Line 7680: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;

7676: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7677: l_index BINARY_INTEGER;
7678: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
7679: l_landlord_service_id PN_LANDLORD_SERVICES_ALL.LANDLORD_SERVICE_ID%TYPE;
7680: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
7681: l_company_id PN_LANDLORD_SERVICES_ALL.company_id%type ;
7682: l_cur_id NUMBER;
7683: l_tbl_index BINARY_INTEGER;
7684: l_tbl_flag NUMBER;

Line 8320: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;

8316:
8317: )IS
8318: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8319: l_index BINARY_INTEGER;
8320: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
8321: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
8322: l_user_id NUMBER;
8323: l_tbl_index BINARY_INTEGER;
8324: l_tbl_flag NUMBER := 1;

Line 8321: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;

8317: )IS
8318: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8319: l_index BINARY_INTEGER;
8320: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
8321: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
8322: l_user_id NUMBER;
8323: l_tbl_index BINARY_INTEGER;
8324: l_tbl_flag NUMBER := 1;
8325: l_tbl temp_tbl_type;

Line 8653: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;

8649: )
8650: IS
8651: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8652: l_index BINARY_INTEGER;
8653: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
8654: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
8655: l_user_id PN_LEASE_MILESTONES_ALL.USER_ID%TYPE;
8656: l_milestone_id PN_LEASE_MILESTONES_ALL.LEASE_MILESTONE_ID%TYPE;
8657: l_cur_id PN_LEASE_MILESTONES_ALL.LEASE_MILESTONE_ID%TYPE;

Line 8654: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;

8650: IS
8651: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8652: l_index BINARY_INTEGER;
8653: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
8654: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
8655: l_user_id PN_LEASE_MILESTONES_ALL.USER_ID%TYPE;
8656: l_milestone_id PN_LEASE_MILESTONES_ALL.LEASE_MILESTONE_ID%TYPE;
8657: l_cur_id PN_LEASE_MILESTONES_ALL.LEASE_MILESTONE_ID%TYPE;
8658: l_tbl_index BINARY_INTEGER;

Line 9143: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;

9139: ,x_return_status IN OUT NOCOPY VARCHAR2
9140: )IS
9141: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
9142: l_index BINARY_INTEGER;
9143: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
9144: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
9145: l_cur_id NUMBER;
9146: l_tbl_index BINARY_INTEGER;
9147: l_tbl_flag NUMBER := 1;

Line 9144: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;

9140: )IS
9141: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
9142: l_index BINARY_INTEGER;
9143: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
9144: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
9145: l_cur_id NUMBER;
9146: l_tbl_index BINARY_INTEGER;
9147: l_tbl_flag NUMBER := 1;
9148: l_tbl temp_tbl_type;

Line 9579: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;

9575: )
9576: IS
9577: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
9578: l_index BINARY_INTEGER;
9579: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
9580: l_api_name VARCHAR2(30) := 'UPDATE_INSURANCE';
9581: l_cur_id NUMBER;
9582: l_tbl_index BINARY_INTEGER;
9583: l_tbl_flag NUMBER := 1;

Line 10171: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;

10167: )
10168: IS
10169: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
10170: l_index BINARY_INTEGER;
10171: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
10172: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE := pn_lease_utils.g_pn_miss_char;
10173: l_cur_id NUMBER;
10174: l_tbl_index BINARY_INTEGER;
10175: l_tbl_flag NUMBER := 1;

Line 10172: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE := pn_lease_utils.g_pn_miss_char;

10168: IS
10169: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
10170: l_index BINARY_INTEGER;
10171: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
10172: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE := pn_lease_utils.g_pn_miss_char;
10173: l_cur_id NUMBER;
10174: l_tbl_index BINARY_INTEGER;
10175: l_tbl_flag NUMBER := 1;
10176: l_tbl temp_tbl_type;

Line 10719: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;

10715: )
10716: IS
10717: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
10718: l_index BINARY_INTEGER;
10719: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
10720: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
10721: l_cur_id NUMBER;
10722: l_tbl_index BINARY_INTEGER;
10723: l_tbl_flag NUMBER;

Line 10720: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;

10716: IS
10717: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
10718: l_index BINARY_INTEGER;
10719: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
10720: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
10721: l_cur_id NUMBER;
10722: l_tbl_index BINARY_INTEGER;
10723: l_tbl_flag NUMBER;
10724: l_tbl temp_tbl_type;

Line 18736: -- Validate passed p_new_approval_status_code against the FND_LOOKUPS.

18732: RAISE fnd_api.g_exc_error;
18733:
18734: END IF;
18735:
18736: -- Validate passed p_new_approval_status_code against the FND_LOOKUPS.
18737: IF p_new_approval_status_code IS NOT NULL AND p_new_approval_status_code <> pn_lease_utils.g_pn_miss_char
18738: THEN
18739: pn_lease_utils.get_lookup_code
18740: (p_parameter_name => l_param_status

Line 18763: -- Validate passed p_new_lease_status against the FND_LOOKUPS.

18759: --RAISE fnd_api.g_exc_error;
18760: END IF;
18761: END IF;
18762:
18763: -- Validate passed p_new_lease_status against the FND_LOOKUPS.
18764: IF p_new_lease_status IS NOT NULL AND p_new_lease_status <> pn_lease_utils.g_pn_miss_char
18765: THEN
18766: pn_lease_utils.get_lookup_code
18767: (p_parameter_name => l_param_lease_status