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_INDEX_RENT_UTILS dependencies on PN_INDEX_RENT_UTILS

Line 1: PACKAGE BODY PN_INDEX_RENT_UTILS AS

1: PACKAGE BODY PN_INDEX_RENT_UTILS AS
2: /* $Header: PNIRUTLB.pls 120.1 2010/12/15 10:41:47 seevivek noship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'PN_INDEX_RENT_UTILS_PKG';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2 (30) := 'PN_INDEX_RENT_UTILS_PKG';

1: PACKAGE BODY PN_INDEX_RENT_UTILS AS
2: /* $Header: PNIRUTLB.pls 120.1 2010/12/15 10:41:47 seevivek noship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'PN_INDEX_RENT_UTILS_PKG';
5:
6: --Procedure to validate the Lookup code and Lookup Meaning for the input parameter Lookup Type
7:
8: PROCEDURE get_index_lease_id (

Line 52: OR x_index_lease_id = pn_index_rent_utils.g_pn_miss_num)

48: -- Initialize the return status.
49: x_return_status := fnd_api.g_ret_sts_success;
50:
51: IF ( x_index_lease_id IS NULL
52: OR x_index_lease_id = pn_index_rent_utils.g_pn_miss_num)
53: THEN
54: OPEN c_index_lease_num;
55:
56: FETCH c_index_lease_num

Line 161: OR x_lookup_type_code = pn_index_rent_utils.g_pn_miss_char

157: -- Initialize the return status.
158: x_return_status := fnd_api.g_ret_sts_success;
159:
160: IF ( x_lookup_type_code IS NULL
161: OR x_lookup_type_code = pn_index_rent_utils.g_pn_miss_char
162: )
163: THEN
164: OPEN c_lookup_type;
165:

Line 287: IF ( (x_lease_id IS NULL OR x_lease_id = pn_index_rent_utils.g_pn_miss_num)

283: BEGIN
284: -- Initialize the return status.
285: x_return_status := fnd_api.g_ret_sts_success;
286:
287: IF ( (x_lease_id IS NULL OR x_lease_id = pn_index_rent_utils.g_pn_miss_num)
288: AND
289: (p_lease_number IS NULL OR p_lease_number = pn_index_rent_utils.g_pn_miss_char)
290: )
291: THEN

Line 289: (p_lease_number IS NULL OR p_lease_number = pn_index_rent_utils.g_pn_miss_char)

285: x_return_status := fnd_api.g_ret_sts_success;
286:
287: IF ( (x_lease_id IS NULL OR x_lease_id = pn_index_rent_utils.g_pn_miss_num)
288: AND
289: (p_lease_number IS NULL OR p_lease_number = pn_index_rent_utils.g_pn_miss_char)
290: )
291: THEN
292: OPEN c_lease_name;
293:

Line 314: ELSIF ( (x_lease_id IS NULL OR x_lease_id = pn_index_rent_utils.g_pn_miss_num)

310: THEN
311: CLOSE c_lease_name;
312: END IF;
313:
314: ELSIF ( (x_lease_id IS NULL OR x_lease_id = pn_index_rent_utils.g_pn_miss_num)
315: AND
316: (p_lease_name IS NULL OR p_lease_name = pn_index_rent_utils.g_pn_miss_char)
317: )
318: THEN

Line 316: (p_lease_name IS NULL OR p_lease_name = pn_index_rent_utils.g_pn_miss_char)

312: END IF;
313:
314: ELSIF ( (x_lease_id IS NULL OR x_lease_id = pn_index_rent_utils.g_pn_miss_num)
315: AND
316: (p_lease_name IS NULL OR p_lease_name = pn_index_rent_utils.g_pn_miss_char)
317: )
318: THEN
319: OPEN c_lease_num;
320:

Line 450: OR x_location_id = pn_index_rent_utils.g_pn_miss_num)

446: -- Initialize the return status.
447: x_return_status := fnd_api.g_ret_sts_success;
448:
449: IF ( x_location_id IS NULL
450: OR x_location_id = pn_index_rent_utils.g_pn_miss_num)
451: THEN
452: OPEN c_location_code;
453:
454: FETCH c_location_code

Line 538: OR x_index_id = pn_index_rent_utils.g_pn_miss_num)

534: -- Initialize the return status.
535: x_return_status := fnd_api.g_ret_sts_success;
536:
537: IF ( x_index_id IS NULL
538: OR x_index_id = pn_index_rent_utils.g_pn_miss_num)
539: THEN
540: OPEN c_index;
541:
542: FETCH c_index

Line 630: OR x_user_id = pn_index_rent_utils.g_pn_miss_num)

626: -- Initialize the return status.
627: x_return_status := fnd_api.g_ret_sts_success;
628:
629: IF ( x_user_id IS NULL
630: OR x_user_id = pn_index_rent_utils.g_pn_miss_num)
631: THEN
632: OPEN c_user;
633:
634: FETCH c_user

Line 719: AND x_currency_code<> pn_index_rent_utils.g_pn_miss_char

715: -- Initialize the return status.
716: x_return_status := fnd_api.g_ret_sts_success;
717:
718: IF ( ( x_currency_code IS NOT NULL
719: AND x_currency_code<> pn_index_rent_utils.g_pn_miss_char
720: )
721: OR
722: ( p_functional_currency_code IS NOT NULL
723: AND p_functional_currency_code <> pn_index_rent_utils.g_pn_miss_char

Line 723: AND p_functional_currency_code <> pn_index_rent_utils.g_pn_miss_char

719: AND x_currency_code<> pn_index_rent_utils.g_pn_miss_char
720: )
721: OR
722: ( p_functional_currency_code IS NOT NULL
723: AND p_functional_currency_code <> pn_index_rent_utils.g_pn_miss_char
724: )
725: )
726: THEN
727: OPEN c_currency_code;

Line 814: OR x_lookup_code = pn_index_rent_utils.g_pn_miss_char

810: -- Initialize the return status.
811: x_return_status := fnd_api.g_ret_sts_success;
812:
813: IF ( x_lookup_code IS NULL
814: OR x_lookup_code = pn_index_rent_utils.g_pn_miss_char
815: )
816: THEN
817: OPEN c_lookup;
818:

Line 923: (x_termtemp_id=pn_index_rent_utils.g_pn_miss_num)

919: x_return_status := fnd_api.g_ret_sts_success;
920:
921: IF (x_termtemp_id) IS NULL
922: OR
923: (x_termtemp_id=pn_index_rent_utils.g_pn_miss_num)
924: THEN
925: OPEN c_termtemp;
926:
927: FETCH c_termtemp

Line 982: END PN_INDEX_RENT_UTILS;

978:
979: x_return_status := fnd_api.g_ret_sts_unexp_error;
980: END get_term_template_id;
981:
982: END PN_INDEX_RENT_UTILS;