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 PN_LOCATIONS

Line 1124: IF (get_attribute_status('PN_LOCATIONS') > 0) THEN

1120: p_lease_tenancies_tbl(i).attribute15 := NULL;
1121: -- ELSE
1122: -- l_lease_tenancies_rec.attribute15 := p_lease_tenancies_tbl (i).attribute15;
1123: END IF;
1124: IF (get_attribute_status('PN_LOCATIONS') > 0) THEN
1125: /* get_attribute_mandatory_status('PN_LOCATIONS'
1126: ,p_lease_tenancies_tbl(i).attribute1
1127: ,p_lease_tenancies_tbl(i).attribute2
1128: ,p_lease_tenancies_tbl(i).attribute3

Line 1125: /* get_attribute_mandatory_status('PN_LOCATIONS'

1121: -- ELSE
1122: -- l_lease_tenancies_rec.attribute15 := p_lease_tenancies_tbl (i).attribute15;
1123: END IF;
1124: IF (get_attribute_status('PN_LOCATIONS') > 0) THEN
1125: /* get_attribute_mandatory_status('PN_LOCATIONS'
1126: ,p_lease_tenancies_tbl(i).attribute1
1127: ,p_lease_tenancies_tbl(i).attribute2
1128: ,p_lease_tenancies_tbl(i).attribute3
1129: ,p_lease_tenancies_tbl(i).attribute4

Line 1176: , p_desc_flex_name => 'PN_LOCATIONS'

1172: ) THEN
1173: pn_lease_utils.validate_desc_flex
1174: (p_api_name => 'PN_LEASE_PVT'|| '.'|| 'CREATE_TENANCIES'
1175: , p_application_short_name => 'PN'
1176: , p_desc_flex_name => 'PN_LOCATIONS'
1177: , p_desc_segment1 => p_lease_tenancies_tbl(i).attribute1
1178: , p_desc_segment2 => p_lease_tenancies_tbl(i).attribute2
1179: , p_desc_segment3 => p_lease_tenancies_tbl(i).attribute3
1180: , p_desc_segment4 => p_lease_tenancies_tbl(i).attribute4

Line 1288: l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE := p_lease_tenancies_rec.location_code;

1284: l_allocated_pct NUMBER;
1285: l_min_pct NUMBER;
1286: l_loc_code VARCHAR2(30) := NULL;
1287: l_loc_area NUMBER;
1288: l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE := p_lease_tenancies_rec.location_code;
1289:
1290: -- Get the details of Allocated area percentage
1291: CURSOR cur_alloc_pct(p_tenancy_id number) IS
1292: SELECT nvl(min(allocated_area_pct),0) allocated_area_pct

Line 1841: , p_desc_flex_name => 'PN_LOCATIONS'

1837:
1838: pn_lease_utils.validate_desc_flex
1839: (p_api_name => l_api_name_full
1840: , p_application_short_name => 'PN'
1841: , p_desc_flex_name => 'PN_LOCATIONS'
1842: , p_desc_segment1 => p_lease_tenancies_tbl_update (i).attribute1
1843: , p_desc_segment2 => p_lease_tenancies_tbl_update (i).attribute2
1844: , p_desc_segment3 => p_lease_tenancies_tbl_update (i).attribute3
1845: , p_desc_segment4 => p_lease_tenancies_tbl_update (i).attribute4

Line 2956: -- l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE := NAME_IN('tenancy_fdr_blk.location_code'); /* Bug#7162821 */

2952: -- l_allocated_area NUMBER;
2953: l_loc_area NUMBER;
2954: l_min_pct NUMBER;
2955: -- l_answer NUMBER;
2956: -- l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE := NAME_IN('tenancy_fdr_blk.location_code'); /* Bug#7162821 */
2957: -- l_allocated_pct NUMBER;
2958: l_loc_code VARCHAR2(30) := NULL;
2959: l_mutiple_lease VARCHAR2(30) := NULL;
2960: l_automatic_distrubution VARCHAR2(30) := NULL;