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_UTILS dependencies on PN_LEASE_UTILS

Line 1: PACKAGE BODY PN_LEASE_UTILS AS

1: PACKAGE BODY PN_LEASE_UTILS AS
2: /* $Header: PNLSUTLB.pls 120.1.12020000.2 2012/10/12 11:11:46 nisinha ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'PN_LEASE_UTILS';
5: g_table_name CONSTANT VARCHAR2 (40) := 'PN_LEASES_ALL';

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

1: PACKAGE BODY PN_LEASE_UTILS AS
2: /* $Header: PNLSUTLB.pls 120.1.12020000.2 2012/10/12 11:11:46 nisinha ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'PN_LEASE_UTILS';
5: g_table_name CONSTANT VARCHAR2 (40) := 'PN_LEASES_ALL';
6: g_tl_table_name CONSTANT VARCHAR2 (40) := 'NONE';
7: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');--nvl(PN_MO_CACHE_UTILS.get_current_org_id,fnd_profile.VALUE ('org_id'));
8: --:= fnd_profile.VALUE ('org_id');

Line 68: OR x_lookup_type_code = pn_lease_utils.g_pn_miss_char

64: -- Initialize the return status.
65: x_return_status := fnd_api.g_ret_sts_success;
66:
67: IF ( x_lookup_type_code IS NULL
68: OR x_lookup_type_code = pn_lease_utils.g_pn_miss_char
69: )
70: THEN
71: OPEN c_lookup_type;
72:

Line 240: OR x_user_id = PN_LEASE_UTILS.G_PN_MISS_NUM)

236: -- Initialize the return status.
237: x_return_status := fnd_api.g_ret_sts_success;
238:
239: IF ( x_user_id IS NULL
240: OR x_user_id = PN_LEASE_UTILS.G_PN_MISS_NUM)
241: THEN
242: OPEN c_user;
243:
244: FETCH c_user

Line 447: IF (x_location_id IS NULL or x_location_id =PN_LEASE_UTILS.G_PN_MISS_NUM)

443: BEGIN
444: -- Initialize the return status.
445: x_return_status := fnd_api.g_ret_sts_success;
446:
447: IF (x_location_id IS NULL or x_location_id =PN_LEASE_UTILS.G_PN_MISS_NUM)
448: THEN
449: OPEN c_location;
450:
451:

Line 570: x_master_lease_id=PN_LEASE_UTILS.G_PN_MISS_NUM)

566: x_return_status := fnd_api.g_ret_sts_success;
567:
568: IF (x_master_lease_id IS NULL
569: OR
570: x_master_lease_id=PN_LEASE_UTILS.G_PN_MISS_NUM)
571: THEN
572: OPEN c_master_lease;
573:
574: FETCH c_master_lease

Line 654: IF Nvl(p_lease_term_date,pn_lease_utils.g_pn_miss_date) >= Nvl(p_lease_comm_date,pn_lease_utils.g_pn_miss_date)

650: || '.'
651: || l_api_name;
652: BEGIN
653: /*Bug#14651192 replaced the dates when null by g_pn_miss_date*/
654: IF Nvl(p_lease_term_date,pn_lease_utils.g_pn_miss_date) >= Nvl(p_lease_comm_date,pn_lease_utils.g_pn_miss_date)
655: THEN
656: x_return_status := fnd_api.g_ret_sts_success;
657: ELSE
658: /*fnd_message.set_name ('PN', 'PN_INVALID_TERMINATION_DT');

Line 726: (x_termtemp_id=PN_LEASE_UTILS.G_PN_MISS_NUM)

722: x_return_status := fnd_api.g_ret_sts_success;
723:
724: IF (x_termtemp_id) IS NULL
725: OR
726: (x_termtemp_id=PN_LEASE_UTILS.G_PN_MISS_NUM)
727: THEN
728: OPEN c_termtemp;
729:
730: FETCH c_termtemp

Line 828: IF (x_grouping_rule_id IS NULL OR x_grouping_rule_id=PN_LEASE_UTILS.G_PN_MISS_NUM)

824: BEGIN
825: -- Initialize the return status.
826: x_return_status := fnd_api.g_ret_sts_success;
827:
828: IF (x_grouping_rule_id IS NULL OR x_grouping_rule_id=PN_LEASE_UTILS.G_PN_MISS_NUM)
829: THEN
830: OPEN c_grouping_rule;
831:
832: FETCH c_grouping_rule

Line 975: --pn_lease_utils.add_desc_flex_msg (p_api_name, l_error_message);

971: , resp_id => p_resp_id
972: )
973: THEN
974: l_error_message := fnd_flex_descval.error_message;
975: --pn_lease_utils.add_desc_flex_msg (p_api_name, l_error_message);
976: p_return_status := fnd_api.g_ret_sts_error;
977:
978: END IF;
979: END IF;

Line 1056: -- := PN_LEASE_UTILS.G_PN_MISS_NUM;

1052:
1053: l_appl_short_name CONSTANT VARCHAR2 (5) := 'SQLGL';
1054: l_key_flex_code CONSTANT VARCHAR2 (5) := 'GL#';
1055: l_structure_num NUMBER;
1056: -- := PN_LEASE_UTILS.G_PN_MISS_NUM;
1057: l_delimitor VARCHAR2 (1);
1058: -- := PN_LEASE_UTILS.G_PN_MISS_CHAR;
1059: l_account_id NUMBER;
1060: -- := PN_LEASE_UTILS.G_PN_MISS_NUM;

Line 1058: -- := PN_LEASE_UTILS.G_PN_MISS_CHAR;

1054: l_key_flex_code CONSTANT VARCHAR2 (5) := 'GL#';
1055: l_structure_num NUMBER;
1056: -- := PN_LEASE_UTILS.G_PN_MISS_NUM;
1057: l_delimitor VARCHAR2 (1);
1058: -- := PN_LEASE_UTILS.G_PN_MISS_CHAR;
1059: l_account_id NUMBER;
1060: -- := PN_LEASE_UTILS.G_PN_MISS_NUM;
1061: l_concatenated_seg VARCHAR2 (800);
1062: -- := PN_LEASE_UTILS.G_PN_MISS_CHAR;

Line 1060: -- := PN_LEASE_UTILS.G_PN_MISS_NUM;

1056: -- := PN_LEASE_UTILS.G_PN_MISS_NUM;
1057: l_delimitor VARCHAR2 (1);
1058: -- := PN_LEASE_UTILS.G_PN_MISS_CHAR;
1059: l_account_id NUMBER;
1060: -- := PN_LEASE_UTILS.G_PN_MISS_NUM;
1061: l_concatenated_seg VARCHAR2 (800);
1062: -- := PN_LEASE_UTILS.G_PN_MISS_CHAR;
1063: BEGIN
1064: -- Initialize the return status.

Line 1062: -- := PN_LEASE_UTILS.G_PN_MISS_CHAR;

1058: -- := PN_LEASE_UTILS.G_PN_MISS_CHAR;
1059: l_account_id NUMBER;
1060: -- := PN_LEASE_UTILS.G_PN_MISS_NUM;
1061: l_concatenated_seg VARCHAR2 (800);
1062: -- := PN_LEASE_UTILS.G_PN_MISS_CHAR;
1063: BEGIN
1064: -- Initialize the return status.
1065: x_return_status := fnd_api.g_ret_sts_success;
1066: --------dbms_output.put_line ('IN Get_account_id procedure: ');

Line 1092: AND (p_account_id <> pn_lease_utils.g_pn_miss_num

1088: END IF;
1089:
1090: -- Validate and Get account_id using account id
1091: IF ( (p_account_id IS NOT NULL)
1092: AND (p_account_id <> pn_lease_utils.g_pn_miss_num
1093: ) --Rupak Changed this
1094: )
1095: THEN
1096: ------dbms_output.put_line ('In UTILS:IF: account ID');

Line 1123: AND (p_account_conc_segs <> pn_lease_utils.g_pn_miss_char

1119: THEN
1120: CLOSE c_get_account;
1121: END IF;
1122: ELSIF ( (p_account_conc_segs IS NOT NULL)
1123: AND (p_account_conc_segs <> pn_lease_utils.g_pn_miss_char
1124: ) --Rupak Changed this
1125: )
1126: THEN
1127: ------dbms_output.put_line('In UTILS ElseIF: Concanated Segments:p_account_segment1.Segment1');

Line 1286: OR x_company_id = pn_lease_utils.g_pn_miss_num

1282: -- AND comp.org_id = g_org_id;
1283: AND comp.org_id =fnd_profile.VALUE('org_id');
1284: BEGIN
1285: IF ( x_company_id IS NULL
1286: OR x_company_id = pn_lease_utils.g_pn_miss_num
1287: )
1288: THEN
1289: OPEN c_company_name (p_lease_role_type);
1290:

Line 1398: OR x_company_site_id = pn_lease_utils.g_pn_miss_num

1394: --AND org_id = g_org_id;
1395: AND org_id = fnd_profile.VALUE('ORG_ID');
1396: BEGIN
1397: IF ( x_company_site_id IS NULL
1398: OR x_company_site_id = pn_lease_utils.g_pn_miss_num
1399: )
1400: THEN
1401: /*------dbms_output.put_line
1402: ( 'In Company Site:Hi:Company ID :p_company_site_name '

Line 1568: IF ( ( p_actual_occ_date IS NOT NULL AND p_actual_occ_date <> pn_lease_utils.g_pn_miss_date)

1564:
1565: BEGIN
1566:
1567:
1568: IF ( ( p_actual_occ_date IS NOT NULL AND p_actual_occ_date <> pn_lease_utils.g_pn_miss_date)
1569: AND( p_estimated_occ_date IS NOT NULL AND p_estimated_occ_date <> pn_lease_utils.g_pn_miss_date)
1570: AND( p_tenancy_exp_date IS NOT NULL AND p_tenancy_exp_date <> pn_lease_utils.g_pn_miss_date)
1571: ) THEN
1572: IF ( ( p_estimated_occ_date < p_lease_comm_date AND p_actual_occ_date < p_lease_comm_date)

Line 1569: AND( p_estimated_occ_date IS NOT NULL AND p_estimated_occ_date <> pn_lease_utils.g_pn_miss_date)

1565: BEGIN
1566:
1567:
1568: IF ( ( p_actual_occ_date IS NOT NULL AND p_actual_occ_date <> pn_lease_utils.g_pn_miss_date)
1569: AND( p_estimated_occ_date IS NOT NULL AND p_estimated_occ_date <> pn_lease_utils.g_pn_miss_date)
1570: AND( p_tenancy_exp_date IS NOT NULL AND p_tenancy_exp_date <> pn_lease_utils.g_pn_miss_date)
1571: ) THEN
1572: IF ( ( p_estimated_occ_date < p_lease_comm_date AND p_actual_occ_date < p_lease_comm_date)
1573: OR ( p_tenancy_exp_date < p_lease_comm_date AND p_tenancy_exp_date > p_lease_term_date)

Line 1570: AND( p_tenancy_exp_date IS NOT NULL AND p_tenancy_exp_date <> pn_lease_utils.g_pn_miss_date)

1566:
1567:
1568: IF ( ( p_actual_occ_date IS NOT NULL AND p_actual_occ_date <> pn_lease_utils.g_pn_miss_date)
1569: AND( p_estimated_occ_date IS NOT NULL AND p_estimated_occ_date <> pn_lease_utils.g_pn_miss_date)
1570: AND( p_tenancy_exp_date IS NOT NULL AND p_tenancy_exp_date <> pn_lease_utils.g_pn_miss_date)
1571: ) THEN
1572: IF ( ( p_estimated_occ_date < p_lease_comm_date AND p_actual_occ_date < p_lease_comm_date)
1573: OR ( p_tenancy_exp_date < p_lease_comm_date AND p_tenancy_exp_date > p_lease_term_date)
1574: OR ( p_estimated_occ_date < p_lease_comm_date)

Line 1628: AND p_fin_oblig_end_date <> pn_lease_utils.g_pn_miss_date

1624: BEGIN
1625:
1626:
1627: IF ( p_fin_oblig_end_date IS NOT NULL
1628: AND p_fin_oblig_end_date <> pn_lease_utils.g_pn_miss_date
1629: )
1630:
1631: THEN
1632: IF (p_tenancy_exp_date > p_fin_oblig_end_date) THEN

Line 1717: OR x_customer_id = pn_lease_utils.g_pn_miss_num

1713: -- Initialize the return status.
1714: x_return_status := fnd_api.g_ret_sts_success;
1715:
1716: IF ( x_customer_id IS NULL
1717: OR x_customer_id = pn_lease_utils.g_pn_miss_num
1718: )
1719: THEN
1720: OPEN c_tenancy_customer_name;
1721:

Line 1765: AND x_customer_id <> pn_lease_utils.g_pn_miss_num

1761: END IF;
1762:
1763:
1764: IF ( x_customer_id IS NOT NULL
1765: AND x_customer_id <> pn_lease_utils.g_pn_miss_num
1766: )
1767: THEN
1768:
1769:

Line 1859: IF (x_customer_id IS NULL or x_customer_id=PN_LEASE_UTILS.G_PN_MISS_NUM)

1855: BEGIN
1856: -- Initialize the return status.
1857: x_return_status := fnd_api.g_ret_sts_success;
1858: ------dbms_output.put_line ('UTILS:0');--Rupak
1859: IF (x_customer_id IS NULL or x_customer_id=PN_LEASE_UTILS.G_PN_MISS_NUM)
1860: THEN
1861: OPEN cur_customer;
1862:
1863: FETCH cur_customer

Line 1939: l_cal_start DATE := PN_LEASE_UTILS.G_PN_MISS_DATE;

1935: l_dd_part VARCHAR2(2);
1936: l_mm_part VARCHAR2(2);
1937: l_api_name CONSTANT VARCHAR2 (30) := 'TENANCYDATES_CROSSVAL';
1938: l_api_name_full CONSTANT VARCHAR2 (61) := g_pkg_name || '.' || l_api_name;
1939: l_cal_start DATE := PN_LEASE_UTILS.G_PN_MISS_DATE;
1940: BEGIN
1941:
1942: l_dd_part := SUBSTR(x_cal_start,1,2);
1943: l_mm_part := SUBSTR(x_cal_start,4,2);

Line 2513: END pn_lease_utils;

2509: END GET_PAY_CUSTOMER_SITE_ID;
2510:
2511:
2512: --------------------------------Terms End-------------------------
2513: END pn_lease_utils;