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_TENANCIES_PKG dependencies on PN_SPACE_ASSIGN_CUST

Line 19: RECORD (cust_assign_start_date pn_space_assign_cust.cust_assign_start_date%TYPE,

15: ------------------------------------------------------------------------------------
16: -- 22-AUG-2003 Satish Tripathi o Fixed for BUG# 3085758, Added fin_oblig_end_date.
17: ------------------------------------------------------------------------------------
18: TYPE space_assign_info_rec IS
19: RECORD (cust_assign_start_date pn_space_assign_cust.cust_assign_start_date%TYPE,
20: cust_assign_end_date pn_space_assign_cust.cust_assign_end_date%TYPE,
21: fin_oblig_end_date pn_space_assign_cust.fin_oblig_end_date%TYPE,
22: allocated_area pn_space_assign_cust.allocated_area%TYPE,
23: allocated_area_pct pn_space_assign_cust_all.allocated_area_pct%TYPE);

Line 20: cust_assign_end_date pn_space_assign_cust.cust_assign_end_date%TYPE,

16: -- 22-AUG-2003 Satish Tripathi o Fixed for BUG# 3085758, Added fin_oblig_end_date.
17: ------------------------------------------------------------------------------------
18: TYPE space_assign_info_rec IS
19: RECORD (cust_assign_start_date pn_space_assign_cust.cust_assign_start_date%TYPE,
20: cust_assign_end_date pn_space_assign_cust.cust_assign_end_date%TYPE,
21: fin_oblig_end_date pn_space_assign_cust.fin_oblig_end_date%TYPE,
22: allocated_area pn_space_assign_cust.allocated_area%TYPE,
23: allocated_area_pct pn_space_assign_cust_all.allocated_area_pct%TYPE);
24:

Line 21: fin_oblig_end_date pn_space_assign_cust.fin_oblig_end_date%TYPE,

17: ------------------------------------------------------------------------------------
18: TYPE space_assign_info_rec IS
19: RECORD (cust_assign_start_date pn_space_assign_cust.cust_assign_start_date%TYPE,
20: cust_assign_end_date pn_space_assign_cust.cust_assign_end_date%TYPE,
21: fin_oblig_end_date pn_space_assign_cust.fin_oblig_end_date%TYPE,
22: allocated_area pn_space_assign_cust.allocated_area%TYPE,
23: allocated_area_pct pn_space_assign_cust_all.allocated_area_pct%TYPE);
24:
25: TYPE space_assign_info_type IS

Line 22: allocated_area pn_space_assign_cust.allocated_area%TYPE,

18: TYPE space_assign_info_rec IS
19: RECORD (cust_assign_start_date pn_space_assign_cust.cust_assign_start_date%TYPE,
20: cust_assign_end_date pn_space_assign_cust.cust_assign_end_date%TYPE,
21: fin_oblig_end_date pn_space_assign_cust.fin_oblig_end_date%TYPE,
22: allocated_area pn_space_assign_cust.allocated_area%TYPE,
23: allocated_area_pct pn_space_assign_cust_all.allocated_area_pct%TYPE);
24:
25: TYPE space_assign_info_type IS
26: TABLE OF space_assign_info_rec

Line 23: allocated_area_pct pn_space_assign_cust_all.allocated_area_pct%TYPE);

19: RECORD (cust_assign_start_date pn_space_assign_cust.cust_assign_start_date%TYPE,
20: cust_assign_end_date pn_space_assign_cust.cust_assign_end_date%TYPE,
21: fin_oblig_end_date pn_space_assign_cust.fin_oblig_end_date%TYPE,
22: allocated_area pn_space_assign_cust.allocated_area%TYPE,
23: allocated_area_pct pn_space_assign_cust_all.allocated_area_pct%TYPE);
24:
25: TYPE space_assign_info_type IS
26: TABLE OF space_assign_info_rec
27: INDEX BY BINARY_INTEGER;

Line 1293: -- where clause of pn_space_assign_cust_all to select all space

1289:
1290: -------------------------------------------------------------------
1291: -- FUNCTION: cust_assign_assoc_exp_area_dt
1292: -- 08-APR-2004 Satish Tripathi o Fixed for BUG# 3284799, Modified CURSOR chk_locked_area_exp_det
1293: -- where clause of pn_space_assign_cust_all to select all space
1294: -- assignments between the p_start/end date to check if its locked.
1295: -------------------------------------------------------------------
1296: FUNCTION cust_assign_assoc_exp_area_dt(
1297: p_tenancy_id IN NUMBER

Line 1308: FROM pn_space_assign_cust_all spc

1304: CURSOR chk_assoc_exp_area_dtl IS
1305: SELECT 'Y'
1306: FROM DUAL
1307: WHERE EXISTS (SELECT NULL
1308: FROM pn_space_assign_cust_all spc
1309: WHERE spc.tenancy_id = p_tenancy_id
1310: AND (EXISTS (SELECT NULL
1311: FROM pn_rec_arcl_dtl_all mst,
1312: pn_rec_arcl_dtlln_all dtl

Line 1326: FROM pn_space_assign_cust_all spc

1322: CURSOR chk_locked_area_exp_det IS
1323: SELECT 'Y'
1324: FROM DUAL
1325: WHERE EXISTS (SELECT NULL
1326: FROM pn_space_assign_cust_all spc
1327: WHERE spc.tenancy_id = p_tenancy_id
1328: AND (NVL(spc.cust_assign_end_date,p_cust_assign_end_dt) >= p_cust_assign_start_dt OR
1329: spc.cust_assign_start_date <= p_cust_assign_end_dt)
1330: AND (EXISTS (SELECT NULL

Line 1519: FROM pn_space_assign_cust_all

1515: CURSOR csr_cust_info IS
1516: SELECT cust_assign_start_date,
1517: NVL(cust_assign_end_date, p_to_date) cust_assign_end_date,
1518: allocated_area
1519: FROM pn_space_assign_cust_all
1520: WHERE location_id = p_location_id
1521: AND cust_assign_start_date <= p_to_date
1522: AND NVL(cust_assign_end_date, p_to_date) >= p_from_date;
1523:

Line 1644: -- 28-Apr-04 vmmehta o BUG#3197182. Changed call to pn_space_assign_cust_pkg.insert_row

1640: -- table to x_fin_oblig_end_date.
1641: -- 08-NOV-03 STripathi o Fixed for BUG# 3242651. Call chk_dup_cust_assign to check
1642: -- duplicate assignment before insert_row pass DUP_ASSIGN in p_action.
1643: -- 05-MAR-04 ftanudja o Replaced call to chk_dup_cust_assign w/ exception handling.
1644: -- 28-Apr-04 vmmehta o BUG#3197182. Changed call to pn_space_assign_cust_pkg.insert_row
1645: -- Added parameter x_return_status and checking
1646: -- return_status rather than duplicate_exception.
1647: -------------------------------------------------------------------------------
1648: PROCEDURE insert_space_assign_row(

Line 1672: pn_space_assign_cust_pkg.insert_row(

1668: i := 0;
1669: FOR i IN 0 .. p_space_assign_info_tbl.count-1
1670: LOOP
1671:
1672: pn_space_assign_cust_pkg.insert_row(
1673: x_rowid => l_rowId,
1674: x_cust_space_assign_id => l_cust_space_assign_id,
1675: x_location_id => p_location_id,
1676: x_cust_account_id => p_customer_id,

Line 2136: PN_SPACE_ASSIGN_CUST_PKG.assignment_split(

2132: IF NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION',l_org_id),'N') = 'Y' AND
2133: l_loc_type_code IN ('OFFICE', 'SECTION')
2134: THEN
2135:
2136: PN_SPACE_ASSIGN_CUST_PKG.assignment_split(
2137: p_location_id => p_location_id,
2138: p_start_date => p_cust_assign_start_dt,
2139: p_end_date => p_cust_assign_end_dt);
2140:

Line 2159: -- PN_SPACE_ASSIGN_CUST_PKG.assignment_split

2155: --
2156: -- 10-JUN-03 PSidhu o Created for Recovery (CAM) impact on Leases and Space Assignments.
2157: -- 25-Nov-03 DThota o Added 2 parameters p_location_id and p_loc_type_code to
2158: -- delete_auto_space_assign. Added call to
2159: -- PN_SPACE_ASSIGN_CUST_PKG.assignment_split
2160: -- Fix for bug # 3282064
2161: -- 23-FEB-04 STripathi o Fixed for BUG# 3425167. Removed code for IF p_cust_assign_start_date
2162: -- IS NOT NULL AND p_cust_assign_end_date IS NOT NULL THEN.
2163: -- For a tenancy id, delete all space assgn records.

Line 2199: FROM pn_space_assign_cust_all

2195: ||l_auto_space_dist||', TenancyId: '||p_tenancy_id);
2196:
2197: DELETE FROM pn_rec_expcl_dtlln_all
2198: WHERE cust_space_assign_id IN (SELECT cust_space_assign_id
2199: FROM pn_space_assign_cust_all
2200: WHERE tenancy_id = p_tenancy_id);
2201: l_count := SQL%ROWCOUNT;
2202:
2203: DELETE FROM pn_rec_arcl_dtlln_all

Line 2205: FROM pn_space_assign_cust_all

2201: l_count := SQL%ROWCOUNT;
2202:
2203: DELETE FROM pn_rec_arcl_dtlln_all
2204: WHERE cust_space_assign_id IN (SELECT cust_space_assign_id
2205: FROM pn_space_assign_cust_all
2206: WHERE tenancy_id = p_tenancy_id);
2207: l_count := SQL%ROWCOUNT + l_count;
2208:
2209: DELETE FROM pn_space_assign_cust_all

Line 2209: DELETE FROM pn_space_assign_cust_all

2205: FROM pn_space_assign_cust_all
2206: WHERE tenancy_id = p_tenancy_id);
2207: l_count := SQL%ROWCOUNT + l_count;
2208:
2209: DELETE FROM pn_space_assign_cust_all
2210: WHERE tenancy_id = p_tenancy_id;
2211: l_del_count := SQL%ROWCOUNT;
2212:
2213: -- 3282064

Line 2218: PN_SPACE_ASSIGN_CUST_PKG.assignment_split(

2214: IF NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION',l_org_id),'N') = 'Y' AND
2215: p_loc_type_code IN ('OFFICE', 'SECTION')
2216: THEN
2217:
2218: PN_SPACE_ASSIGN_CUST_PKG.assignment_split(
2219: p_location_id => p_location_id,
2220: p_start_date => p_cust_assign_start_date,
2221: p_end_date => p_cust_assign_end_date);
2222:

Line 2290: FROM pn_space_assign_cust_all

2286: SELECT cust_space_assign_id,
2287: cust_assign_start_date,
2288: cust_assign_end_date,
2289: allocated_area
2290: FROM pn_space_assign_cust_all
2291: WHERE tenancy_id = p_tenancy_id
2292: AND cust_assign_start_date = (SELECT MIN(cust_assign_start_date)
2293: FROM pn_space_assign_cust_all
2294: WHERE tenancy_id = p_tenancy_id);

Line 2293: FROM pn_space_assign_cust_all

2289: allocated_area
2290: FROM pn_space_assign_cust_all
2291: WHERE tenancy_id = p_tenancy_id
2292: AND cust_assign_start_date = (SELECT MIN(cust_assign_start_date)
2293: FROM pn_space_assign_cust_all
2294: WHERE tenancy_id = p_tenancy_id);
2295:
2296: CURSOR csr_max_cust_assign IS
2297: SELECT cust_space_assign_id,

Line 2301: FROM pn_space_assign_cust_all

2297: SELECT cust_space_assign_id,
2298: cust_assign_start_date,
2299: cust_assign_end_date,
2300: allocated_area
2301: FROM pn_space_assign_cust_all
2302: WHERE tenancy_id = p_tenancy_id
2303: AND cust_assign_end_date = (SELECT MAX(cust_assign_end_date)
2304: FROM pn_space_assign_cust_all
2305: WHERE tenancy_id = p_tenancy_id);

Line 2304: FROM pn_space_assign_cust_all

2300: allocated_area
2301: FROM pn_space_assign_cust_all
2302: WHERE tenancy_id = p_tenancy_id
2303: AND cust_assign_end_date = (SELECT MAX(cust_assign_end_date)
2304: FROM pn_space_assign_cust_all
2305: WHERE tenancy_id = p_tenancy_id);
2306:
2307: CURSOR csr_spc_assign_exists IS
2308: SELECT 'Y'

Line 2311: FROM pn_space_assign_cust_all

2307: CURSOR csr_spc_assign_exists IS
2308: SELECT 'Y'
2309: FROM DUAL
2310: WHERE EXISTS (SELECT NULL
2311: FROM pn_space_assign_cust_all
2312: WHERE tenancy_id = p_tenancy_id);
2313:
2314: i NUMBER := 0;
2315: j NUMBER := 0;

Line 2344: FROM pn_space_assign_cust_all

2340:
2341: CURSOR cur_alloc_area IS
2342: SELECT cust_assign_start_date,
2343: cust_assign_end_date
2344: FROM pn_space_assign_cust_all
2345: WHERE tenancy_id = p_tenancy_id;
2346:
2347: l_org_id NUMBER;
2348:

Line 2499: DELETE FROM pn_space_assign_cust_all

2495: p_action := 'S';
2496: RETURN;
2497: ELSE
2498:
2499: DELETE FROM pn_space_assign_cust_all
2500: WHERE tenancy_id = p_tenancy_id
2501: AND cust_assign_end_date < p_cust_assign_start_dt;
2502: l_count := 0;
2503: l_count := SQL%ROWCOUNT;

Line 2506: UPDATE pn_space_assign_cust_all

2502: l_count := 0;
2503: l_count := SQL%ROWCOUNT;
2504: pnp_debug_pkg.debug('Update_Auto_Space_Assign : Check# 2: 1. Rows Deleted: '||l_count);
2505:
2506: UPDATE pn_space_assign_cust_all
2507: SET cust_assign_start_date = p_cust_assign_start_dt
2508: ,last_update_date = SYSDATE
2509: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),-1)
2510: WHERE tenancy_id = p_tenancy_id

Line 2548: DELETE FROM pn_space_assign_cust_all

2544: p_action := 'S';
2545: RETURN;
2546: ELSE
2547:
2548: DELETE FROM pn_space_assign_cust_all
2549: WHERE tenancy_id = p_tenancy_id
2550: AND cust_assign_start_date > p_cust_assign_end_dt;
2551: l_count := 0;
2552: l_count := SQL%ROWCOUNT;

Line 2555: UPDATE pn_space_assign_cust_all

2551: l_count := 0;
2552: l_count := SQL%ROWCOUNT;
2553: pnp_debug_pkg.debug('Update_Auto_Space_Assign : Check# 2: 3. Rows Deleted: '||l_count);
2554:
2555: UPDATE pn_space_assign_cust_all
2556: SET cust_assign_end_date = p_cust_assign_end_dt
2557: ,fin_oblig_end_date = p_fin_oblig_end_date
2558: ,last_update_date = SYSDATE
2559: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),-1)

Line 2651: UPDATE pn_space_assign_cust_all

2647: ||', end_date: '||space_assign_info_tbl(i).cust_assign_end_date
2648: ||', area: '||space_assign_info_tbl(i).allocated_area
2649: ||',');
2650:
2651: UPDATE pn_space_assign_cust_all
2652: SET cust_assign_start_date = space_assign_info_tbl(i).cust_assign_start_date
2653: WHERE cust_space_assign_id = l_min_cust_assign_id;
2654: ELSE
2655:

Line 2733: UPDATE pn_space_assign_cust_all

2729: ELSE
2730: l_fin_oblig_end_date := space_assign_info_tbl(i).cust_assign_end_date;
2731: END IF;
2732:
2733: UPDATE pn_space_assign_cust_all
2734: SET cust_assign_end_date = space_assign_info_tbl(i).cust_assign_end_date
2735: ,fin_oblig_end_date = l_fin_oblig_end_date
2736: WHERE cust_space_assign_id = l_max_cust_assign_id;
2737:

Line 2752: UPDATE pn_space_assign_cust_all

2748: -----------------------------------------------------------------------
2749: IF NVL(l_max_cust_end_date+1, space_assign_info_tbl(i).cust_assign_start_date) =
2750: space_assign_info_tbl(i).cust_assign_start_date
2751: THEN
2752: UPDATE pn_space_assign_cust_all
2753: SET fin_oblig_end_date = cust_assign_end_date
2754: WHERE cust_space_assign_id = l_max_cust_assign_id;
2755: END IF;
2756:

Line 2826: UPDATE pn_space_assign_cust_all

2822:
2823: pnp_debug_pkg.debug('Update_Auto_Space_Assign : Check# 3: fin_oblig_end_date is changed.');
2824:
2825: IF p_fin_oblig_end_date_old IS NOT NULL THEN
2826: UPDATE pn_space_assign_cust_all
2827: SET fin_oblig_end_date = p_fin_oblig_end_date
2828: ,last_update_date = SYSDATE
2829: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),-1)
2830: WHERE tenancy_id = p_tenancy_id

Line 2833: UPDATE pn_space_assign_cust_all

2829: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),-1)
2830: WHERE tenancy_id = p_tenancy_id
2831: AND fin_oblig_end_date = p_fin_oblig_end_date_old;
2832: ELSE
2833: UPDATE pn_space_assign_cust_all
2834: SET fin_oblig_end_date = p_fin_oblig_end_date
2835: ,last_update_date = SYSDATE
2836: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),-1)
2837: WHERE tenancy_id = p_tenancy_id

Line 2864: pn_space_assign_cust_pkg.chk_dup_cust_assign(

2860: ||'space_std/recovery_type is changed.');
2861:
2862: /*IF (NVL(p_customer_id, -99) <> NVL(p_customer_id_old, -99)) THEN
2863:
2864: pn_space_assign_cust_pkg.chk_dup_cust_assign(
2865: p_cust_acnt_id => p_customer_id
2866: ,p_loc_id => p_location_id
2867: ,p_assgn_str_dt => p_cust_assign_start_dt
2868: ,p_assgn_end_dt => p_cust_assign_end_dt

Line 2878: UPDATE pn_space_assign_cust_all

2874: RETURN;
2875: END IF;
2876: END IF;*/
2877:
2878: UPDATE pn_space_assign_cust_all
2879: SET cust_account_id = p_customer_id
2880: ,site_use_id = p_cust_site_use_id
2881: ,recovery_space_std_code = p_recovery_space_std_code
2882: ,recovery_type_code = p_recovery_type_code

Line 2909: UPDATE pn_space_assign_cust_all

2905: p_cust_assign_end_date => l_cust_assign_end_date,
2906: p_allocated_area_pct => p_allocated_pct,
2907: p_allocated_area => l_allocated_area);
2908:
2909: UPDATE pn_space_assign_cust_all
2910: SET allocated_area_pct = p_allocated_pct
2911: ,allocated_area = l_allocated_area
2912: WHERE tenancy_id = p_tenancy_id
2913: AND cust_assign_start_date = l_cust_assign_start_date;

Line 2932: PN_SPACE_ASSIGN_CUST_PKG.assignment_split(

2928: IF NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION',l_org_id),'N') = 'Y' AND
2929: l_loc_type_code IN ('OFFICE', 'SECTION')
2930: THEN
2931:
2932: PN_SPACE_ASSIGN_CUST_PKG.assignment_split(
2933: p_location_id => p_location_id,
2934: p_start_date => p_cust_assign_start_dt,
2935: p_end_date => p_cust_assign_end_dt);
2936:

Line 2982: FROM pn_space_assign_cust_all

2978: CURSOR get_cust_space_assign_id IS
2979: SELECT cust_space_assign_id,
2980: NVL(cust_assign_start_date, pnt_locations_pkg.g_start_of_time) cust_assign_start_date,
2981: NVL(cust_assign_end_date, pnt_locations_pkg.g_end_of_time) cust_assign_end_date
2982: FROM pn_space_assign_cust_all
2983: WHERE cust_account_id = p_customer_id
2984: AND location_id = p_location_id
2985: AND cust_assign_start_date <= p_cust_assign_end_dt
2986: AND NVL(cust_assign_end_date, TO_DATE('12/31/4712', 'MM/DD/YYYY'))

Line 3024: UPDATE pn_space_assign_cust_all

3020: CLOSE get_cust_space_assign_id;
3021:
3022: IF l_cust_space_assign_id IS NOT NULL THEN
3023:
3024: UPDATE pn_space_assign_cust_all
3025: SET lease_id = p_lease_id
3026: ,tenancy_id = p_tenancy_id
3027: ,cust_assign_start_date = NVL(cust_assign_start_date, pnt_locations_pkg.g_start_of_time)
3028: ,cust_assign_end_date = NVL(cust_assign_end_date, pnt_locations_pkg.g_end_of_time)

Line 3090: FROM pn_space_assign_cust_all

3086: l_lease_class_code VARCHAR2(30);
3087:
3088: CURSOR cur_allocated_area_pct IS
3089: SELECT min(allocated_area_pct) min_area_pct
3090: FROM pn_space_assign_cust_all
3091: WHERE tenancy_id = p_tenancy_id;
3092:
3093: CURSOR cur_lease_code IS
3094: SELECT leases.lease_class_code lease_code,

Line 3142: FROM pn_space_assign_cust_all

3138: l_lease_class_code VARCHAR2(30);
3139:
3140: CURSOR cur_allocated_area IS
3141: SELECT min(allocated_area) min_area
3142: FROM pn_space_assign_cust_all
3143: WHERE tenancy_id = p_tenancy_id;
3144:
3145: CURSOR get_lease_class IS
3146: SELECT leases.lease_class_code lease_code,

Line 3196: FROM pn_space_assign_cust_all

3192: CURSOR csr_cust_info IS
3193: SELECT cust_assign_start_date,
3194: NVL(cust_assign_end_date, p_to_date) cust_assign_end_date,
3195: nvl(allocated_area,0) allocated_area
3196: FROM pn_space_assign_cust_all
3197: WHERE location_id = p_location_id
3198: AND cust_assign_start_date <= p_to_date
3199: AND NVL(cust_assign_end_date, p_to_date) >= p_from_date;
3200: