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

Line 1: PACKAGE BODY pn_space_assign_cust_pkg AS

1: PACKAGE BODY pn_space_assign_cust_pkg AS
2: /* $Header: PNSPCUSB.pls 120.12 2007/02/14 12:31:55 rdonthul ship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCEDURE : Insert_Row

Line 13: -- 30-JUN-05 hrodda o Bug 4284035 - Replaced pn_space_assign_cust

9: -- 05-MAR-04 ftanudja o Replaced check_dupcust.. w/ chk_dup_cust..
10: -- 14-DEC-04 STripath o Modified for Portfolio Status Enh BUG# 4030816. Added
11: -- code to check loc is contigious assignable betn assign
12: -- start and end dates.
13: -- 30-JUN-05 hrodda o Bug 4284035 - Replaced pn_space_assign_cust
14: -- with _ALL table.
15: -- 08-SEP-o5 hrodda o Modified insert statement to include org_id.
16: -- 28-NOV-05 pikhar o fetched org_id using cursor.
17: -- 08-Feb-07 rdonthul o Removed the check fro duplicate space assignments

Line 68: FROM pn_space_assign_cust_all

64: )
65: IS
66: CURSOR c IS
67: SELECT ROWID
68: FROM pn_space_assign_cust_all
69: WHERE cust_space_assign_id = x_cust_space_assign_id;
70:
71: l_status VARCHAR2(100);
72: l_err_msg VARCHAR2(30);

Line 83: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.INSERT_ROW (+) SpcAsgnId: '

79: l_org_id NUMBER;
80:
81: BEGIN
82:
83: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.INSERT_ROW (+) SpcAsgnId: '
84: ||x_cust_space_assign_id||', LocId: '||x_location_id
85: ||', StrDt: '||TO_CHAR(x_cust_assign_start_date,'MM/DD/YYYY')
86: ||', EndDt: '||TO_CHAR(x_cust_assign_end_date, 'MM/DD/YYYY')
87: ||', CustId: '||x_cust_account_id);

Line 104: /* pn_space_assign_cust_pkg.chk_dup_cust_assign(

100: x_return_status := 'INVALID_LOC_DATE';
101: return;
102: END IF;
103:
104: /* pn_space_assign_cust_pkg.chk_dup_cust_assign(
105: p_cust_acnt_id => x_cust_account_id
106: ,p_loc_id => x_location_id
107: ,p_assgn_str_dt => x_cust_assign_start_date
108: ,p_assgn_end_dt => x_cust_assign_end_date

Line 129: SELECT pn_space_assign_cust_s.NEXTVAL

125: l_org_id := x_org_id;
126: END IF;
127:
128: IF ( X_CUST_SPACE_ASSIGN_ID IS NULL) THEN
129: SELECT pn_space_assign_cust_s.NEXTVAL
130: INTO x_cust_space_assign_id
131: FROM DUAL;
132: END IF;
133:

Line 134: INSERT INTO pn_space_assign_cust_all

130: INTO x_cust_space_assign_id
131: FROM DUAL;
132: END IF;
133:
134: INSERT INTO pn_space_assign_cust_all
135: ( CUST_SPACE_ASSIGN_ID,
136: LOCATION_ID,
137: CUST_ACCOUNT_ID,
138: SITE_USE_ID,

Line 228: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.INSERT_ROW (-) SpcAsgnId: '

224: RAISE NO_DATA_FOUND;
225: END IF;
226: CLOSE c;
227:
228: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.INSERT_ROW (-) SpcAsgnId: '
229: ||x_cust_space_assign_id||', LocId: '||x_location_id
230: ||', StrDt: '||TO_CHAR(x_cust_assign_start_date,'MM/DD/YYYY')
231: ||', EndDt: '||TO_CHAR(x_cust_assign_end_date, 'MM/DD/YYYY')
232: ||', CustId: '||x_cust_account_id);

Line 278: FROM pn_space_assign_cust_all

274: )
275: IS
276: CURSOR c1 IS
277: SELECT *
278: FROM pn_space_assign_cust_all
279: WHERE cust_space_assign_id = x_cust_space_assign_id
280: FOR UPDATE OF cust_space_assign_id NOWAIT;
281:
282: BEGIN

Line 284: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.LOCK_ROW (+) SpcAsgnId: '

280: FOR UPDATE OF cust_space_assign_id NOWAIT;
281:
282: BEGIN
283:
284: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.LOCK_ROW (+) SpcAsgnId: '
285: ||x_cust_space_assign_id);
286:
287: OPEN c1;
288: FETCH c1 INTO tlcustinfo;

Line 463: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.LOCK_ROW (-) SpcAsgnId: '

459: OR ((tlcustinfo.TENANCY_ID is null) AND (X_TENANCY_ID is null))) THEN
460: pn_var_rent_pkg.lock_row_exception('TENANCY_ID',tlcustinfo.TENANCY_ID);
461: END IF;
462:
463: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.LOCK_ROW (-) SpcAsgnId: '
464: ||x_cust_space_assign_id);
465:
466: END Lock_Row;
467:

Line 477: -- 21-JUN-05 hrodda o Bug 4284035 - Replaced pn_space_assign_cust

473: -- 05-MAR-04 ftanudja o Replaced check_dupcust.. w/ chk_dup_cust..
474: -- 14-DEC-04 STripath o Modified for Portfolio Status Enh BUG# 4030816. Added
475: -- code to check loc is contigious assignable betn assign
476: -- start and end dates.
477: -- 21-JUN-05 hrodda o Bug 4284035 - Replaced pn_space_assign_cust
478: -- with _ALL table.
479: -- 08-SEP-05 Hareesha o Modified insert statement to include org_id.
480: -- 08-Feb-07 Ram kumar o Removed the check for duplicate Space assignments
481: -- for bug fix 5864468

Line 534: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.UPDATE_ROW (+) SpcAsgnId: '

530: l_status VARCHAR2(100);
531: l_err_msg VARCHAR2(30);
532:
533: BEGIN
534: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.UPDATE_ROW (+) SpcAsgnId: '
535: ||x_cust_space_assign_id||', Mode: '||x_update_correct_option||', LocId: '||x_location_id
536: ||', StrDt: '||TO_CHAR(x_cust_assign_start_date,'MM/DD/YYYY')
537: ||', EndDt: '||TO_CHAR(x_cust_assign_end_date, 'MM/DD/YYYY')
538: ||', CustId: '||x_cust_account_id);

Line 563: pn_space_assign_cust_pkg.chk_dup_cust_assign(

559: END IF;
560:
561: /*IF x_cust_account_id <> tlcustinfo.cust_account_id THEN
562:
563: pn_space_assign_cust_pkg.chk_dup_cust_assign(
564: p_cust_acnt_id => x_cust_account_id
565: ,p_loc_id => x_location_id
566: ,p_assgn_str_dt => x_cust_assign_start_date
567: ,p_assgn_end_dt => x_cust_assign_end_date

Line 580: SELECT pn_space_assign_cust_s.NEXTVAL

576: END IF; */
577:
578: IF X_UPDATE_CORRECT_OPTION = 'UPDATE' THEN
579:
580: SELECT pn_space_assign_cust_s.NEXTVAL
581: INTO l_cust_space_assign_id
582: FROM DUAL;
583:
584: IF X_FIN_OBLIG_END_DATE IS NOT NULL THEN

Line 591: INSERT INTO pn_space_assign_cust_all

587: l_fin_oblig_end_date := NULL;
588: END IF;
589:
590:
591: INSERT INTO pn_space_assign_cust_all
592: (CUST_SPACE_ASSIGN_ID,
593: LOCATION_ID,
594: CUST_ACCOUNT_ID,
595: SITE_USE_ID,

Line 678: UPDATE PN_SPACE_ASSIGN_CUST_ALL SET

674:
675: END IF;
676:
677:
678: UPDATE PN_SPACE_ASSIGN_CUST_ALL SET
679: LOCATION_ID = X_LOCATION_ID,
680: CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID,
681: SITE_USE_ID = X_SITE_USE_ID,
682: EXPENSE_ACCOUNT_ID = X_EXPENSE_ACCOUNT_ID,

Line 724: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.UPDATE_ROW (-) SpcAsgnId: '

720: IF (SQL%NOTFOUND) THEN
721: RAISE NO_DATA_FOUND;
722: END IF;
723:
724: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.UPDATE_ROW (-) SpcAsgnId: '
725: ||x_cust_space_assign_id||', Mode: '||x_update_correct_option||', LocId: '||x_location_id
726: ||', StrDt: '||TO_CHAR(x_cust_assign_start_date,'MM/DD/YYYY')
727: ||', EndDt: '||TO_CHAR(x_cust_assign_end_date, 'MM/DD/YYYY')
728: ||', CustId: '||x_cust_account_id);

Line 737: -- 21-JUN-05 hrodda o Bug 4284035 - Replaced pn_space_assign_cust

733: -- PROCEDURE : Delete_Row
734: -- INVOKED FROM : Delete_Row procedure
735: -- PURPOSE : deletes the row
736: -- HISTORY :
737: -- 21-JUN-05 hrodda o Bug 4284035 - Replaced pn_space_assign_cust
738: -- with _ALL table.
739: -------------------------------------------------------------------------------
740: PROCEDURE Delete_Row (
741: X_CUST_SPACE_ASSIGN_ID IN NUMBER

Line 747: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.DELETE_ROW (+) SpcAsgnId: '

743: IS
744:
745: BEGIN
746:
747: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.DELETE_ROW (+) SpcAsgnId: '
748: ||x_cust_space_assign_id);
749:
750:
751: DELETE FROM pn_space_assign_cust_all

Line 751: DELETE FROM pn_space_assign_cust_all

747: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.DELETE_ROW (+) SpcAsgnId: '
748: ||x_cust_space_assign_id);
749:
750:
751: DELETE FROM pn_space_assign_cust_all
752: WHERE cust_space_assign_id = x_cust_space_assign_id;
753:
754: IF (SQL%NOTFOUND) THEN
755: RAISE NO_DATA_FOUND;

Line 758: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.DELETE_ROW (-) SpcAsgnId: '

754: IF (SQL%NOTFOUND) THEN
755: RAISE NO_DATA_FOUND;
756: END IF;
757:
758: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.DELETE_ROW (-) SpcAsgnId: '
759: ||x_cust_space_assign_id);
760:
761: END Delete_Row;
762:

Line 770: -- 21-JUN-05 hrodda o Bug 4284035 - Replaced pn_space_assign_cust

766: -- record for the same customer, for the same date range.
767: -- If there exists one then it stops user from doing the assignment.
768: -- HISTORY :
769: -- 05-MAR-04 ftanudja o Copied from pn_tenancies_pkg v115.50
770: -- 21-JUN-05 hrodda o Bug 4284035 - Replaced pn_space_assign_cust
771: -- with _ALL table.
772: -------------------------------------------------------------------------------
773:
774: PROCEDURE chk_dup_cust_assign(

Line 788: FROM pn_space_assign_cust_all

784: CURSOR check_cust_assignment IS
785: SELECT 'Y'
786: FROM DUAL
787: WHERE EXISTS (SELECT NULL
788: FROM pn_space_assign_cust_all
789: WHERE cust_account_id = p_cust_acnt_id
790: AND location_id = p_loc_id
791: AND cust_assign_start_date <= p_assgn_end_dt
792: AND NVL(cust_assign_end_date, TO_DATE('12/31/4712', 'MM/DD/YYYY'))

Line 795: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.CHK_DUP_CUST_ASSIGN (+)');

791: AND cust_assign_start_date <= p_assgn_end_dt
792: AND NVL(cust_assign_end_date, TO_DATE('12/31/4712', 'MM/DD/YYYY'))
793: >= p_assgn_str_dt);
794: BEGIN
795: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.CHK_DUP_CUST_ASSIGN (+)');
796:
797: OPEN check_cust_assignment;
798: FETCH check_cust_assignment INTO l_err_flag;
799: CLOSE check_cust_assignment;

Line 805: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.CHK_DUP_CUST_ASSIGN (-) '||p_return_status);

801: IF NVL(l_err_flag,'N') = 'Y' THEN
802: p_return_status := 'DUP_ASSIGN';
803: END IF;
804:
805: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.CHK_DUP_CUST_ASSIGN (-) '||p_return_status);
806: END chk_dup_cust_assign;
807:
808: -------------------------------------------------------------------
809: -- PROCEDURE : GET_DUP_CUST_ASSIGN_COUNT

Line 828: FROM pn_space_assign_cust_all

824: l_dup_assign_count NUMBER := 0;
825:
826: CURSOR get_cust_assignment IS
827: SELECT cust_space_assign_id, cust_account_id
828: FROM pn_space_assign_cust_all
829: WHERE location_id = p_loc_id
830: AND cust_assign_start_date <= p_assgn_end_dt
831: AND NVL(cust_assign_end_date, TO_DATE('12/31/4712', 'MM/DD/YYYY'))
832: >= p_assgn_str_dt;

Line 834: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.GET_DUP_CUST_ASSIGN_COUNT (+)');

830: AND cust_assign_start_date <= p_assgn_end_dt
831: AND NVL(cust_assign_end_date, TO_DATE('12/31/4712', 'MM/DD/YYYY'))
832: >= p_assgn_str_dt;
833: BEGIN
834: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.GET_DUP_CUST_ASSIGN_COUNT (+)');
835:
836: FOR cust_assign IN get_cust_assignment
837: LOOP
838: l_assign_count := l_assign_count + 1;

Line 847: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.GET_DUP_CUST_ASSIGN_COUNT (-) '||p_assign_count);

843:
844: p_assign_count := l_assign_count;
845: p_dup_assign_count := l_dup_assign_count;
846:
847: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.GET_DUP_CUST_ASSIGN_COUNT (-) '||p_assign_count);
848: END get_dup_cust_assign_count;
849:
850: -----------------------------------------------------------------------
851: -- FUNCTION : check_assign_arcl_line

Line 967: -- 21-JUN-05 hareesha o Bug 4284035 - Replaced pn_space_assign_cust,

963: -- assignment_split().
964: -- 19-MAY-05 ftanudja o #4349490 - Changed csr_emp and csr_cust to increase
965: -- range by +/- 1 day so that split assignments are
966: -- included.
967: -- 21-JUN-05 hareesha o Bug 4284035 - Replaced pn_space_assign_cust,
968: -- pn_space_assign_emp and pn_loactions with _ALL
969: -- table.
970: -- 25-Aug-05 hareesha o Bug 4551557 - Modified csr_main cursor query to
971: -- include space assignments starting after the specified

Line 975: -- instead of pn_space_assign_cust_all because

971: -- include space assignments starting after the specified
972: -- end_date.
973: -- 28-NOV-05 pikhar o passed org_id in pn_mo_cache_utils.get_profile_value
974: -- 04-APR-06 Hareesha o Bug #5202023 Fetched org_id from pn_locations_all
975: -- instead of pn_space_assign_cust_all because
976: -- assignment_split could be called for
977: -- employee space assignment too.
978: -------------------------------------------------------------------------------
979:

Line 998: FROM pn_space_assign_cust_all

994: ,NVL(cust_assign_end_date , to_date('12/31/4712','MM/DD/YYYY')) end_date
995: ,allocated_area
996: ,location_id
997: ,'CUST: '||cust_space_assign_id assign_type_id
998: FROM pn_space_assign_cust_all
999: WHERE location_id = p_location_id
1000: AND cust_assign_start_date <= p_end_date
1001: AND NVL(cust_assign_end_date,TO_DATE('12/31/4712','MM/DD/YYYY')) >= p_start_date
1002: UNION ALL

Line 1008: FROM pn_space_assign_cust_all

1004: ,NVL(cust_assign_end_date, to_date('12/31/4712','MM/DD/YYYY')) end_date
1005: ,allocated_area
1006: ,location_id
1007: ,'CUST: '||cust_space_assign_id assign_type_id
1008: FROM pn_space_assign_cust_all
1009: WHERE location_id = p_location_id
1010: AND cust_assign_start_date > p_end_date
1011: UNION ALL
1012: SELECT emp_assign_start_date start_date

Line 1054: FROM pn_space_assign_cust_all

1050: ,allocated_area
1051: ,allocated_area_pct
1052: ,location_id
1053: ,ROWID
1054: FROM pn_space_assign_cust_all
1055: WHERE location_id = p_location_id
1056: AND cust_assign_start_date <= (p_end_date + 1)
1057: AND NVL(cust_assign_end_date,TO_DATE('12/31/4712','MM/DD/YYYY')) >= (p_start_date - 1)
1058: ;

Line 1080: CURSOR csr_cust_split(p_as_of_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%TYPE) IS

1076: -------------------------------------------------------------------------------------
1077: -- This cursor is used to get all customer assignment records whose start date is less than
1078: -- and end date greater than the split date returned by 'process vacancy'.
1079: -------------------------------------------------------------------------------------
1080: CURSOR csr_cust_split(p_as_of_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%TYPE) IS
1081: SELECT *
1082: FROM pn_space_assign_cust_all
1083: WHERE location_id = p_location_id
1084: AND cust_assign_start_date < p_as_of_date

Line 1082: FROM pn_space_assign_cust_all

1078: -- and end date greater than the split date returned by 'process vacancy'.
1079: -------------------------------------------------------------------------------------
1080: CURSOR csr_cust_split(p_as_of_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%TYPE) IS
1081: SELECT *
1082: FROM pn_space_assign_cust_all
1083: WHERE location_id = p_location_id
1084: AND cust_assign_start_date < p_as_of_date
1085: AND NVL(cust_assign_end_date,to_date('12/31/4712','MM/DD/YYYY')) >= p_as_of_date
1086: ORDER BY cust_assign_start_date,cust_assign_end_date;

Line 1155: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Assignment_Split (+) Loc Id: '||p_location_id

1151: END LOOP;
1152:
1153: l_profile := pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION',l_org_id);
1154:
1155: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Assignment_Split (+) Loc Id: '||p_location_id
1156: ||', l_profile: '||l_profile);
1157:
1158: i := 1;
1159: FOR main_rec IN csr_main

Line 1210: PN_SPACE_ASSIGN_CUST_PKG.UPDATE_ROW(

1206: ---------------------------------------------------------------------------------------
1207: -- Splits the existing assignment with the (date-1) passed from the date table returned
1208: -- by process vacancy and creates a new assignment with the split date
1209: ---------------------------------------------------------------------------------------
1210: PN_SPACE_ASSIGN_CUST_PKG.UPDATE_ROW(
1211: X_CUST_SPACE_ASSIGN_ID => cust_split_rec.CUST_SPACE_ASSIGN_ID
1212: ,X_LOCATION_ID => cust_split_rec.LOCATION_ID
1213: ,X_CUST_ACCOUNT_ID => cust_split_rec.CUST_ACCOUNT_ID
1214: ,X_SITE_USE_ID => NULL

Line 1322: pn_space_assign_cust_pkg.area_pct_and_area(

1318: -- Call to re-distribute area among all customers for the location
1319: FOR office_sec_rec IN office_sec_cur(cust_rec.location_id) /*Bug4565550*/
1320: LOOP
1321:
1322: pn_space_assign_cust_pkg.area_pct_and_area(
1323: x_usable_area => l_assignable_area
1324: ,x_location_id => cust_rec.location_id
1325: ,x_start_date => cust_rec.cust_assign_start_date
1326: ,x_end_date => cust_rec.cust_assign_end_date

Line 1334: UPDATE pn_space_assign_cust_all

1330:
1331: ELSE
1332: l_allocated_area := TRUNC((l_assignable_area * cust_rec.allocated_area_pct)/100, 2); /*4533091*/
1333: IF l_allocated_area <> cust_rec.allocated_area THEN
1334: UPDATE pn_space_assign_cust_all
1335: SET allocated_area = l_allocated_area
1336: WHERE ROWID = cust_rec.ROWID;
1337: END IF;
1338: END IF;

Line 1356: PN_SPACE_ASSIGN_CUST_PKG.area_pct_and_area(

1352: -- Call to re-distribute area among all employees for the location
1353: FOR office_sec_rec IN office_sec_cur(emp_rec.location_id) /*Bug4565550*/
1354: LOOP
1355:
1356: PN_SPACE_ASSIGN_CUST_PKG.area_pct_and_area(
1357: x_usable_area => l_assignable_area
1358: ,x_location_id => emp_rec.location_id
1359: ,x_start_date => emp_rec.emp_assign_start_date
1360: ,x_end_date => emp_rec.emp_assign_end_date

Line 1376: pn_space_assign_cust_pkg.Defrag_Contig_Assign(p_location_id);

1372: END IF;
1373: END LOOP;
1374: pnp_debug_pkg.debug('Done distributing Area_Pct and Area... (-)');
1375:
1376: pn_space_assign_cust_pkg.Defrag_Contig_Assign(p_location_id);
1377:
1378: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Assignment_Split (-) Loc Id: '||p_location_id);
1379:
1380: END assignment_split;

Line 1378: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Assignment_Split (-) Loc Id: '||p_location_id);

1374: pnp_debug_pkg.debug('Done distributing Area_Pct and Area... (-)');
1375:
1376: pn_space_assign_cust_pkg.Defrag_Contig_Assign(p_location_id);
1377:
1378: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Assignment_Split (-) Loc Id: '||p_location_id);
1379:
1380: END assignment_split;
1381:
1382: -------------------------------------------------------------------------------

Line 1397: -- either pn_space_assign_emp or pn_space_assign_cust.

1393: -- add/subtract the fractional remainder after space
1394: -- redistribution to one record.
1395: -- 20-OCT-03 dthota o bug # 3234403 - Copied this procedure from PNTSPACE.pld
1396: -- 14-DEC-04 STripath o Fixed for bug# 4092157. If l_total_pct <> 100, update
1397: -- either pn_space_assign_emp or pn_space_assign_cust.
1398: -- 22-FEB-05 MMisra o Bug # 4198937. Merged IF conditions where area and
1399: -- percentage differnce was being checked.
1400: -- 21-JUN-05 hrodda o Bug 4284035 - Replaced pn_space_assign_emp,pn_locations
1401: -- pn_space_assign_cust with _ALL table.

Line 1401: -- pn_space_assign_cust with _ALL table.

1397: -- either pn_space_assign_emp or pn_space_assign_cust.
1398: -- 22-FEB-05 MMisra o Bug # 4198937. Merged IF conditions where area and
1399: -- percentage differnce was being checked.
1400: -- 21-JUN-05 hrodda o Bug 4284035 - Replaced pn_space_assign_emp,pn_locations
1401: -- pn_space_assign_cust with _ALL table.
1402: -------------------------------------------------------------------------------
1403: PROCEDURE area_pct_and_area(x_usable_area NUMBER,
1404: x_location_id NUMBER,
1405: x_start_date DATE,

Line 1421: l_utilized := PN_SPACE_ASSIGN_CUST_PKG.assignment_count(x_location_id,x_start_date,x_end_date);

1417: l_alloc_area pn_space_assign_emp_all.allocated_area%TYPE;
1418:
1419: BEGIN
1420:
1421: l_utilized := PN_SPACE_ASSIGN_CUST_PKG.assignment_count(x_location_id,x_start_date,x_end_date);
1422: l_alloc_area_pct := TRUNC(100 / l_utilized, 2); /*4533091*/
1423: l_alloc_area := TRUNC(x_usable_area / l_utilized, 2); /*4533091*/
1424:
1425: pnp_debug_pkg.debug('Area_Pct_And_Area (+) Loc Id: '||x_location_id

Line 1450: UPDATE pn_space_assign_cust_all cust

1446:
1447: l_emp_updated := SQL%ROWCOUNT;
1448:
1449:
1450: UPDATE pn_space_assign_cust_all cust
1451: SET cust.allocated_area_pct = l_alloc_area_pct,
1452: cust.allocated_area = l_alloc_area
1453: WHERE cust.location_id = x_location_id
1454: AND (cust.cust_assign_start_date <= x_end_date AND

Line 1487: UPDATE pn_space_assign_cust_all cust

1483: AND ROWNUM < 2;
1484:
1485:
1486: ELSIF NVL(l_cust_updated, 0) > 0 THEN
1487: UPDATE pn_space_assign_cust_all cust
1488: SET cust.allocated_area_pct = (cust.allocated_area_pct + l_diff_pct),
1489: cust.allocated_area = (cust.allocated_area + l_diff_area)
1490: WHERE cust.location_id = x_location_id
1491: AND (cust.cust_assign_start_date <= x_end_date AND

Line 1525: -- pn_space_assign_cust, pn_locations with _ALL table.

1521: -- 16-ARP-02 MMisra o Created
1522: -- 20-OCT-03 DThota o bug 3234403 - Copied this procedure from PNTSPACE.pld
1523: -- 07-MAR-05 ftanudja o Used subquery referencing for performance. #4199297.
1524: -- 21-JUN-05 hrodda o Bug 4284035 - Replaced pn_space_assign_emp,
1525: -- pn_space_assign_cust, pn_locations with _ALL table.
1526: +============================================================================*/
1527:
1528: FUNCTION assignment_count(x_location_id IN NUMBER,
1529: x_start_date IN DATE,

Line 1555: FROM pn_space_assign_cust_all cust

1551: AND loc.location_id = emp.location_id);
1552:
1553: SELECT COUNT(*)
1554: INTO l_utilized_cust
1555: FROM pn_space_assign_cust_all cust
1556: WHERE cust.location_id = x_location_id
1557: AND (cust.cust_assign_start_date <= NVL(x_end_date,to_date('12/31/4712','mm/dd/yyyy')) AND
1558: NVL(cust.cust_assign_end_date,to_date('12/31/4712','mm/dd/yyyy')) >= x_start_date)
1559: AND EXISTS (SELECT '1'

Line 1673: -- pn_space_assign_cust with _ALL table.

1669: -- Update_Row in Correct mode, and other changes.
1670: -- 30-SEP-04 STripathi o Modified for Update and Delete for Emp_Tab.
1671: -- Update i+1 row BUT DELETE i th row.
1672: -- 21-JUN-05 hrodda o Bug 4284035 - Replaced pn_space_assign_emp,
1673: -- pn_space_assign_cust with _ALL table.
1674: -------------------------------------------------------------------------------
1675:
1676: PROCEDURE Defrag_Contig_Assign (
1677: p_location_id IN pn_locations_all.location_id%TYPE )

Line 1726: FROM pn_space_assign_cust_all

1722: ,RECOVERY_SPACE_STD_CODE
1723: ,RECOVERY_TYPE_CODE
1724: ,FIN_OBLIG_END_DATE
1725: ,TENANCY_ID
1726: FROM pn_space_assign_cust_all
1727: WHERE location_id = p_location_id
1728: ORDER BY cust_account_id,tenancy_id,lease_id,cust_assign_start_date,cust_assign_end_date
1729: ;
1730:

Line 1777: CUST_SPACE_ASSIGN_ID pn_space_assign_cust_all.CUST_SPACE_ASSIGN_ID%TYPE

1773: -- Define a record of PN_SPACE_CUST_ASSIGN_ALL and PN_SPACE_ASSIGN_EMP_ALL
1774: --------------------------------------------------------------------------
1775:
1776: TYPE cust_rec_type IS RECORD(
1777: CUST_SPACE_ASSIGN_ID pn_space_assign_cust_all.CUST_SPACE_ASSIGN_ID%TYPE
1778: ,LOCATION_ID pn_space_assign_cust_all.LOCATION_ID%TYPE
1779: ,CUST_ACCOUNT_ID pn_space_assign_cust_all.CUST_ACCOUNT_ID%TYPE
1780: ,SITE_USE_ID pn_space_assign_cust_all.SITE_USE_ID%TYPE
1781: ,EXPENSE_ACCOUNT_ID pn_space_assign_cust_all.EXPENSE_ACCOUNT_ID%TYPE

Line 1778: ,LOCATION_ID pn_space_assign_cust_all.LOCATION_ID%TYPE

1774: --------------------------------------------------------------------------
1775:
1776: TYPE cust_rec_type IS RECORD(
1777: CUST_SPACE_ASSIGN_ID pn_space_assign_cust_all.CUST_SPACE_ASSIGN_ID%TYPE
1778: ,LOCATION_ID pn_space_assign_cust_all.LOCATION_ID%TYPE
1779: ,CUST_ACCOUNT_ID pn_space_assign_cust_all.CUST_ACCOUNT_ID%TYPE
1780: ,SITE_USE_ID pn_space_assign_cust_all.SITE_USE_ID%TYPE
1781: ,EXPENSE_ACCOUNT_ID pn_space_assign_cust_all.EXPENSE_ACCOUNT_ID%TYPE
1782: ,PROJECT_ID pn_space_assign_cust_all.PROJECT_ID%TYPE

Line 1779: ,CUST_ACCOUNT_ID pn_space_assign_cust_all.CUST_ACCOUNT_ID%TYPE

1775:
1776: TYPE cust_rec_type IS RECORD(
1777: CUST_SPACE_ASSIGN_ID pn_space_assign_cust_all.CUST_SPACE_ASSIGN_ID%TYPE
1778: ,LOCATION_ID pn_space_assign_cust_all.LOCATION_ID%TYPE
1779: ,CUST_ACCOUNT_ID pn_space_assign_cust_all.CUST_ACCOUNT_ID%TYPE
1780: ,SITE_USE_ID pn_space_assign_cust_all.SITE_USE_ID%TYPE
1781: ,EXPENSE_ACCOUNT_ID pn_space_assign_cust_all.EXPENSE_ACCOUNT_ID%TYPE
1782: ,PROJECT_ID pn_space_assign_cust_all.PROJECT_ID%TYPE
1783: ,TASK_ID pn_space_assign_cust_all.TASK_ID%TYPE

Line 1780: ,SITE_USE_ID pn_space_assign_cust_all.SITE_USE_ID%TYPE

1776: TYPE cust_rec_type IS RECORD(
1777: CUST_SPACE_ASSIGN_ID pn_space_assign_cust_all.CUST_SPACE_ASSIGN_ID%TYPE
1778: ,LOCATION_ID pn_space_assign_cust_all.LOCATION_ID%TYPE
1779: ,CUST_ACCOUNT_ID pn_space_assign_cust_all.CUST_ACCOUNT_ID%TYPE
1780: ,SITE_USE_ID pn_space_assign_cust_all.SITE_USE_ID%TYPE
1781: ,EXPENSE_ACCOUNT_ID pn_space_assign_cust_all.EXPENSE_ACCOUNT_ID%TYPE
1782: ,PROJECT_ID pn_space_assign_cust_all.PROJECT_ID%TYPE
1783: ,TASK_ID pn_space_assign_cust_all.TASK_ID%TYPE
1784: ,CUST_ASSIGN_START_DATE pn_space_assign_cust_all.CUST_ASSIGN_START_DATE%TYPE

Line 1781: ,EXPENSE_ACCOUNT_ID pn_space_assign_cust_all.EXPENSE_ACCOUNT_ID%TYPE

1777: CUST_SPACE_ASSIGN_ID pn_space_assign_cust_all.CUST_SPACE_ASSIGN_ID%TYPE
1778: ,LOCATION_ID pn_space_assign_cust_all.LOCATION_ID%TYPE
1779: ,CUST_ACCOUNT_ID pn_space_assign_cust_all.CUST_ACCOUNT_ID%TYPE
1780: ,SITE_USE_ID pn_space_assign_cust_all.SITE_USE_ID%TYPE
1781: ,EXPENSE_ACCOUNT_ID pn_space_assign_cust_all.EXPENSE_ACCOUNT_ID%TYPE
1782: ,PROJECT_ID pn_space_assign_cust_all.PROJECT_ID%TYPE
1783: ,TASK_ID pn_space_assign_cust_all.TASK_ID%TYPE
1784: ,CUST_ASSIGN_START_DATE pn_space_assign_cust_all.CUST_ASSIGN_START_DATE%TYPE
1785: ,CUST_ASSIGN_END_DATE pn_space_assign_cust_all.CUST_ASSIGN_END_DATE%TYPE

Line 1782: ,PROJECT_ID pn_space_assign_cust_all.PROJECT_ID%TYPE

1778: ,LOCATION_ID pn_space_assign_cust_all.LOCATION_ID%TYPE
1779: ,CUST_ACCOUNT_ID pn_space_assign_cust_all.CUST_ACCOUNT_ID%TYPE
1780: ,SITE_USE_ID pn_space_assign_cust_all.SITE_USE_ID%TYPE
1781: ,EXPENSE_ACCOUNT_ID pn_space_assign_cust_all.EXPENSE_ACCOUNT_ID%TYPE
1782: ,PROJECT_ID pn_space_assign_cust_all.PROJECT_ID%TYPE
1783: ,TASK_ID pn_space_assign_cust_all.TASK_ID%TYPE
1784: ,CUST_ASSIGN_START_DATE pn_space_assign_cust_all.CUST_ASSIGN_START_DATE%TYPE
1785: ,CUST_ASSIGN_END_DATE pn_space_assign_cust_all.CUST_ASSIGN_END_DATE%TYPE
1786: ,ALLOCATED_AREA_PCT pn_space_assign_cust_all.ALLOCATED_AREA_PCT%TYPE

Line 1783: ,TASK_ID pn_space_assign_cust_all.TASK_ID%TYPE

1779: ,CUST_ACCOUNT_ID pn_space_assign_cust_all.CUST_ACCOUNT_ID%TYPE
1780: ,SITE_USE_ID pn_space_assign_cust_all.SITE_USE_ID%TYPE
1781: ,EXPENSE_ACCOUNT_ID pn_space_assign_cust_all.EXPENSE_ACCOUNT_ID%TYPE
1782: ,PROJECT_ID pn_space_assign_cust_all.PROJECT_ID%TYPE
1783: ,TASK_ID pn_space_assign_cust_all.TASK_ID%TYPE
1784: ,CUST_ASSIGN_START_DATE pn_space_assign_cust_all.CUST_ASSIGN_START_DATE%TYPE
1785: ,CUST_ASSIGN_END_DATE pn_space_assign_cust_all.CUST_ASSIGN_END_DATE%TYPE
1786: ,ALLOCATED_AREA_PCT pn_space_assign_cust_all.ALLOCATED_AREA_PCT%TYPE
1787: ,ALLOCATED_AREA pn_space_assign_cust_all.ALLOCATED_AREA%TYPE

Line 1784: ,CUST_ASSIGN_START_DATE pn_space_assign_cust_all.CUST_ASSIGN_START_DATE%TYPE

1780: ,SITE_USE_ID pn_space_assign_cust_all.SITE_USE_ID%TYPE
1781: ,EXPENSE_ACCOUNT_ID pn_space_assign_cust_all.EXPENSE_ACCOUNT_ID%TYPE
1782: ,PROJECT_ID pn_space_assign_cust_all.PROJECT_ID%TYPE
1783: ,TASK_ID pn_space_assign_cust_all.TASK_ID%TYPE
1784: ,CUST_ASSIGN_START_DATE pn_space_assign_cust_all.CUST_ASSIGN_START_DATE%TYPE
1785: ,CUST_ASSIGN_END_DATE pn_space_assign_cust_all.CUST_ASSIGN_END_DATE%TYPE
1786: ,ALLOCATED_AREA_PCT pn_space_assign_cust_all.ALLOCATED_AREA_PCT%TYPE
1787: ,ALLOCATED_AREA pn_space_assign_cust_all.ALLOCATED_AREA%TYPE
1788: ,UTILIZED_AREA pn_space_assign_cust_all.UTILIZED_AREA%TYPE

Line 1785: ,CUST_ASSIGN_END_DATE pn_space_assign_cust_all.CUST_ASSIGN_END_DATE%TYPE

1781: ,EXPENSE_ACCOUNT_ID pn_space_assign_cust_all.EXPENSE_ACCOUNT_ID%TYPE
1782: ,PROJECT_ID pn_space_assign_cust_all.PROJECT_ID%TYPE
1783: ,TASK_ID pn_space_assign_cust_all.TASK_ID%TYPE
1784: ,CUST_ASSIGN_START_DATE pn_space_assign_cust_all.CUST_ASSIGN_START_DATE%TYPE
1785: ,CUST_ASSIGN_END_DATE pn_space_assign_cust_all.CUST_ASSIGN_END_DATE%TYPE
1786: ,ALLOCATED_AREA_PCT pn_space_assign_cust_all.ALLOCATED_AREA_PCT%TYPE
1787: ,ALLOCATED_AREA pn_space_assign_cust_all.ALLOCATED_AREA%TYPE
1788: ,UTILIZED_AREA pn_space_assign_cust_all.UTILIZED_AREA%TYPE
1789: ,CUST_SPACE_COMMENTS pn_space_assign_cust_all.CUST_SPACE_COMMENTS%TYPE

Line 1786: ,ALLOCATED_AREA_PCT pn_space_assign_cust_all.ALLOCATED_AREA_PCT%TYPE

1782: ,PROJECT_ID pn_space_assign_cust_all.PROJECT_ID%TYPE
1783: ,TASK_ID pn_space_assign_cust_all.TASK_ID%TYPE
1784: ,CUST_ASSIGN_START_DATE pn_space_assign_cust_all.CUST_ASSIGN_START_DATE%TYPE
1785: ,CUST_ASSIGN_END_DATE pn_space_assign_cust_all.CUST_ASSIGN_END_DATE%TYPE
1786: ,ALLOCATED_AREA_PCT pn_space_assign_cust_all.ALLOCATED_AREA_PCT%TYPE
1787: ,ALLOCATED_AREA pn_space_assign_cust_all.ALLOCATED_AREA%TYPE
1788: ,UTILIZED_AREA pn_space_assign_cust_all.UTILIZED_AREA%TYPE
1789: ,CUST_SPACE_COMMENTS pn_space_assign_cust_all.CUST_SPACE_COMMENTS%TYPE
1790: ,LAST_UPDATE_DATE pn_space_assign_cust_all.LAST_UPDATE_DATE%TYPE

Line 1787: ,ALLOCATED_AREA pn_space_assign_cust_all.ALLOCATED_AREA%TYPE

1783: ,TASK_ID pn_space_assign_cust_all.TASK_ID%TYPE
1784: ,CUST_ASSIGN_START_DATE pn_space_assign_cust_all.CUST_ASSIGN_START_DATE%TYPE
1785: ,CUST_ASSIGN_END_DATE pn_space_assign_cust_all.CUST_ASSIGN_END_DATE%TYPE
1786: ,ALLOCATED_AREA_PCT pn_space_assign_cust_all.ALLOCATED_AREA_PCT%TYPE
1787: ,ALLOCATED_AREA pn_space_assign_cust_all.ALLOCATED_AREA%TYPE
1788: ,UTILIZED_AREA pn_space_assign_cust_all.UTILIZED_AREA%TYPE
1789: ,CUST_SPACE_COMMENTS pn_space_assign_cust_all.CUST_SPACE_COMMENTS%TYPE
1790: ,LAST_UPDATE_DATE pn_space_assign_cust_all.LAST_UPDATE_DATE%TYPE
1791: ,LAST_UPDATED_BY pn_space_assign_cust_all.LAST_UPDATED_BY%TYPE

Line 1788: ,UTILIZED_AREA pn_space_assign_cust_all.UTILIZED_AREA%TYPE

1784: ,CUST_ASSIGN_START_DATE pn_space_assign_cust_all.CUST_ASSIGN_START_DATE%TYPE
1785: ,CUST_ASSIGN_END_DATE pn_space_assign_cust_all.CUST_ASSIGN_END_DATE%TYPE
1786: ,ALLOCATED_AREA_PCT pn_space_assign_cust_all.ALLOCATED_AREA_PCT%TYPE
1787: ,ALLOCATED_AREA pn_space_assign_cust_all.ALLOCATED_AREA%TYPE
1788: ,UTILIZED_AREA pn_space_assign_cust_all.UTILIZED_AREA%TYPE
1789: ,CUST_SPACE_COMMENTS pn_space_assign_cust_all.CUST_SPACE_COMMENTS%TYPE
1790: ,LAST_UPDATE_DATE pn_space_assign_cust_all.LAST_UPDATE_DATE%TYPE
1791: ,LAST_UPDATED_BY pn_space_assign_cust_all.LAST_UPDATED_BY%TYPE
1792: ,CREATION_DATE pn_space_assign_cust_all.CREATION_DATE%TYPE

Line 1789: ,CUST_SPACE_COMMENTS pn_space_assign_cust_all.CUST_SPACE_COMMENTS%TYPE

1785: ,CUST_ASSIGN_END_DATE pn_space_assign_cust_all.CUST_ASSIGN_END_DATE%TYPE
1786: ,ALLOCATED_AREA_PCT pn_space_assign_cust_all.ALLOCATED_AREA_PCT%TYPE
1787: ,ALLOCATED_AREA pn_space_assign_cust_all.ALLOCATED_AREA%TYPE
1788: ,UTILIZED_AREA pn_space_assign_cust_all.UTILIZED_AREA%TYPE
1789: ,CUST_SPACE_COMMENTS pn_space_assign_cust_all.CUST_SPACE_COMMENTS%TYPE
1790: ,LAST_UPDATE_DATE pn_space_assign_cust_all.LAST_UPDATE_DATE%TYPE
1791: ,LAST_UPDATED_BY pn_space_assign_cust_all.LAST_UPDATED_BY%TYPE
1792: ,CREATION_DATE pn_space_assign_cust_all.CREATION_DATE%TYPE
1793: ,CREATED_BY pn_space_assign_cust_all.CREATED_BY%TYPE

Line 1790: ,LAST_UPDATE_DATE pn_space_assign_cust_all.LAST_UPDATE_DATE%TYPE

1786: ,ALLOCATED_AREA_PCT pn_space_assign_cust_all.ALLOCATED_AREA_PCT%TYPE
1787: ,ALLOCATED_AREA pn_space_assign_cust_all.ALLOCATED_AREA%TYPE
1788: ,UTILIZED_AREA pn_space_assign_cust_all.UTILIZED_AREA%TYPE
1789: ,CUST_SPACE_COMMENTS pn_space_assign_cust_all.CUST_SPACE_COMMENTS%TYPE
1790: ,LAST_UPDATE_DATE pn_space_assign_cust_all.LAST_UPDATE_DATE%TYPE
1791: ,LAST_UPDATED_BY pn_space_assign_cust_all.LAST_UPDATED_BY%TYPE
1792: ,CREATION_DATE pn_space_assign_cust_all.CREATION_DATE%TYPE
1793: ,CREATED_BY pn_space_assign_cust_all.CREATED_BY%TYPE
1794: ,LAST_UPDATE_LOGIN pn_space_assign_cust_all.LAST_UPDATE_LOGIN%TYPE

Line 1791: ,LAST_UPDATED_BY pn_space_assign_cust_all.LAST_UPDATED_BY%TYPE

1787: ,ALLOCATED_AREA pn_space_assign_cust_all.ALLOCATED_AREA%TYPE
1788: ,UTILIZED_AREA pn_space_assign_cust_all.UTILIZED_AREA%TYPE
1789: ,CUST_SPACE_COMMENTS pn_space_assign_cust_all.CUST_SPACE_COMMENTS%TYPE
1790: ,LAST_UPDATE_DATE pn_space_assign_cust_all.LAST_UPDATE_DATE%TYPE
1791: ,LAST_UPDATED_BY pn_space_assign_cust_all.LAST_UPDATED_BY%TYPE
1792: ,CREATION_DATE pn_space_assign_cust_all.CREATION_DATE%TYPE
1793: ,CREATED_BY pn_space_assign_cust_all.CREATED_BY%TYPE
1794: ,LAST_UPDATE_LOGIN pn_space_assign_cust_all.LAST_UPDATE_LOGIN%TYPE
1795: ,ATTRIBUTE_CATEGORY pn_space_assign_cust_all.ATTRIBUTE_CATEGORY%TYPE

Line 1792: ,CREATION_DATE pn_space_assign_cust_all.CREATION_DATE%TYPE

1788: ,UTILIZED_AREA pn_space_assign_cust_all.UTILIZED_AREA%TYPE
1789: ,CUST_SPACE_COMMENTS pn_space_assign_cust_all.CUST_SPACE_COMMENTS%TYPE
1790: ,LAST_UPDATE_DATE pn_space_assign_cust_all.LAST_UPDATE_DATE%TYPE
1791: ,LAST_UPDATED_BY pn_space_assign_cust_all.LAST_UPDATED_BY%TYPE
1792: ,CREATION_DATE pn_space_assign_cust_all.CREATION_DATE%TYPE
1793: ,CREATED_BY pn_space_assign_cust_all.CREATED_BY%TYPE
1794: ,LAST_UPDATE_LOGIN pn_space_assign_cust_all.LAST_UPDATE_LOGIN%TYPE
1795: ,ATTRIBUTE_CATEGORY pn_space_assign_cust_all.ATTRIBUTE_CATEGORY%TYPE
1796: ,ATTRIBUTE1 pn_space_assign_cust_all.ATTRIBUTE1%TYPE

Line 1793: ,CREATED_BY pn_space_assign_cust_all.CREATED_BY%TYPE

1789: ,CUST_SPACE_COMMENTS pn_space_assign_cust_all.CUST_SPACE_COMMENTS%TYPE
1790: ,LAST_UPDATE_DATE pn_space_assign_cust_all.LAST_UPDATE_DATE%TYPE
1791: ,LAST_UPDATED_BY pn_space_assign_cust_all.LAST_UPDATED_BY%TYPE
1792: ,CREATION_DATE pn_space_assign_cust_all.CREATION_DATE%TYPE
1793: ,CREATED_BY pn_space_assign_cust_all.CREATED_BY%TYPE
1794: ,LAST_UPDATE_LOGIN pn_space_assign_cust_all.LAST_UPDATE_LOGIN%TYPE
1795: ,ATTRIBUTE_CATEGORY pn_space_assign_cust_all.ATTRIBUTE_CATEGORY%TYPE
1796: ,ATTRIBUTE1 pn_space_assign_cust_all.ATTRIBUTE1%TYPE
1797: ,ATTRIBUTE2 pn_space_assign_cust_all.ATTRIBUTE2%TYPE

Line 1794: ,LAST_UPDATE_LOGIN pn_space_assign_cust_all.LAST_UPDATE_LOGIN%TYPE

1790: ,LAST_UPDATE_DATE pn_space_assign_cust_all.LAST_UPDATE_DATE%TYPE
1791: ,LAST_UPDATED_BY pn_space_assign_cust_all.LAST_UPDATED_BY%TYPE
1792: ,CREATION_DATE pn_space_assign_cust_all.CREATION_DATE%TYPE
1793: ,CREATED_BY pn_space_assign_cust_all.CREATED_BY%TYPE
1794: ,LAST_UPDATE_LOGIN pn_space_assign_cust_all.LAST_UPDATE_LOGIN%TYPE
1795: ,ATTRIBUTE_CATEGORY pn_space_assign_cust_all.ATTRIBUTE_CATEGORY%TYPE
1796: ,ATTRIBUTE1 pn_space_assign_cust_all.ATTRIBUTE1%TYPE
1797: ,ATTRIBUTE2 pn_space_assign_cust_all.ATTRIBUTE2%TYPE
1798: ,ATTRIBUTE3 pn_space_assign_cust_all.ATTRIBUTE3%TYPE

Line 1795: ,ATTRIBUTE_CATEGORY pn_space_assign_cust_all.ATTRIBUTE_CATEGORY%TYPE

1791: ,LAST_UPDATED_BY pn_space_assign_cust_all.LAST_UPDATED_BY%TYPE
1792: ,CREATION_DATE pn_space_assign_cust_all.CREATION_DATE%TYPE
1793: ,CREATED_BY pn_space_assign_cust_all.CREATED_BY%TYPE
1794: ,LAST_UPDATE_LOGIN pn_space_assign_cust_all.LAST_UPDATE_LOGIN%TYPE
1795: ,ATTRIBUTE_CATEGORY pn_space_assign_cust_all.ATTRIBUTE_CATEGORY%TYPE
1796: ,ATTRIBUTE1 pn_space_assign_cust_all.ATTRIBUTE1%TYPE
1797: ,ATTRIBUTE2 pn_space_assign_cust_all.ATTRIBUTE2%TYPE
1798: ,ATTRIBUTE3 pn_space_assign_cust_all.ATTRIBUTE3%TYPE
1799: ,ATTRIBUTE4 pn_space_assign_cust_all.ATTRIBUTE4%TYPE

Line 1796: ,ATTRIBUTE1 pn_space_assign_cust_all.ATTRIBUTE1%TYPE

1792: ,CREATION_DATE pn_space_assign_cust_all.CREATION_DATE%TYPE
1793: ,CREATED_BY pn_space_assign_cust_all.CREATED_BY%TYPE
1794: ,LAST_UPDATE_LOGIN pn_space_assign_cust_all.LAST_UPDATE_LOGIN%TYPE
1795: ,ATTRIBUTE_CATEGORY pn_space_assign_cust_all.ATTRIBUTE_CATEGORY%TYPE
1796: ,ATTRIBUTE1 pn_space_assign_cust_all.ATTRIBUTE1%TYPE
1797: ,ATTRIBUTE2 pn_space_assign_cust_all.ATTRIBUTE2%TYPE
1798: ,ATTRIBUTE3 pn_space_assign_cust_all.ATTRIBUTE3%TYPE
1799: ,ATTRIBUTE4 pn_space_assign_cust_all.ATTRIBUTE4%TYPE
1800: ,ATTRIBUTE5 pn_space_assign_cust_all.ATTRIBUTE5%TYPE

Line 1797: ,ATTRIBUTE2 pn_space_assign_cust_all.ATTRIBUTE2%TYPE

1793: ,CREATED_BY pn_space_assign_cust_all.CREATED_BY%TYPE
1794: ,LAST_UPDATE_LOGIN pn_space_assign_cust_all.LAST_UPDATE_LOGIN%TYPE
1795: ,ATTRIBUTE_CATEGORY pn_space_assign_cust_all.ATTRIBUTE_CATEGORY%TYPE
1796: ,ATTRIBUTE1 pn_space_assign_cust_all.ATTRIBUTE1%TYPE
1797: ,ATTRIBUTE2 pn_space_assign_cust_all.ATTRIBUTE2%TYPE
1798: ,ATTRIBUTE3 pn_space_assign_cust_all.ATTRIBUTE3%TYPE
1799: ,ATTRIBUTE4 pn_space_assign_cust_all.ATTRIBUTE4%TYPE
1800: ,ATTRIBUTE5 pn_space_assign_cust_all.ATTRIBUTE5%TYPE
1801: ,ATTRIBUTE6 pn_space_assign_cust_all.ATTRIBUTE6%TYPE

Line 1798: ,ATTRIBUTE3 pn_space_assign_cust_all.ATTRIBUTE3%TYPE

1794: ,LAST_UPDATE_LOGIN pn_space_assign_cust_all.LAST_UPDATE_LOGIN%TYPE
1795: ,ATTRIBUTE_CATEGORY pn_space_assign_cust_all.ATTRIBUTE_CATEGORY%TYPE
1796: ,ATTRIBUTE1 pn_space_assign_cust_all.ATTRIBUTE1%TYPE
1797: ,ATTRIBUTE2 pn_space_assign_cust_all.ATTRIBUTE2%TYPE
1798: ,ATTRIBUTE3 pn_space_assign_cust_all.ATTRIBUTE3%TYPE
1799: ,ATTRIBUTE4 pn_space_assign_cust_all.ATTRIBUTE4%TYPE
1800: ,ATTRIBUTE5 pn_space_assign_cust_all.ATTRIBUTE5%TYPE
1801: ,ATTRIBUTE6 pn_space_assign_cust_all.ATTRIBUTE6%TYPE
1802: ,ATTRIBUTE7 pn_space_assign_cust_all.ATTRIBUTE7%TYPE

Line 1799: ,ATTRIBUTE4 pn_space_assign_cust_all.ATTRIBUTE4%TYPE

1795: ,ATTRIBUTE_CATEGORY pn_space_assign_cust_all.ATTRIBUTE_CATEGORY%TYPE
1796: ,ATTRIBUTE1 pn_space_assign_cust_all.ATTRIBUTE1%TYPE
1797: ,ATTRIBUTE2 pn_space_assign_cust_all.ATTRIBUTE2%TYPE
1798: ,ATTRIBUTE3 pn_space_assign_cust_all.ATTRIBUTE3%TYPE
1799: ,ATTRIBUTE4 pn_space_assign_cust_all.ATTRIBUTE4%TYPE
1800: ,ATTRIBUTE5 pn_space_assign_cust_all.ATTRIBUTE5%TYPE
1801: ,ATTRIBUTE6 pn_space_assign_cust_all.ATTRIBUTE6%TYPE
1802: ,ATTRIBUTE7 pn_space_assign_cust_all.ATTRIBUTE7%TYPE
1803: ,ATTRIBUTE8 pn_space_assign_cust_all.ATTRIBUTE8%TYPE

Line 1800: ,ATTRIBUTE5 pn_space_assign_cust_all.ATTRIBUTE5%TYPE

1796: ,ATTRIBUTE1 pn_space_assign_cust_all.ATTRIBUTE1%TYPE
1797: ,ATTRIBUTE2 pn_space_assign_cust_all.ATTRIBUTE2%TYPE
1798: ,ATTRIBUTE3 pn_space_assign_cust_all.ATTRIBUTE3%TYPE
1799: ,ATTRIBUTE4 pn_space_assign_cust_all.ATTRIBUTE4%TYPE
1800: ,ATTRIBUTE5 pn_space_assign_cust_all.ATTRIBUTE5%TYPE
1801: ,ATTRIBUTE6 pn_space_assign_cust_all.ATTRIBUTE6%TYPE
1802: ,ATTRIBUTE7 pn_space_assign_cust_all.ATTRIBUTE7%TYPE
1803: ,ATTRIBUTE8 pn_space_assign_cust_all.ATTRIBUTE8%TYPE
1804: ,ATTRIBUTE9 pn_space_assign_cust_all.ATTRIBUTE9%TYPE

Line 1801: ,ATTRIBUTE6 pn_space_assign_cust_all.ATTRIBUTE6%TYPE

1797: ,ATTRIBUTE2 pn_space_assign_cust_all.ATTRIBUTE2%TYPE
1798: ,ATTRIBUTE3 pn_space_assign_cust_all.ATTRIBUTE3%TYPE
1799: ,ATTRIBUTE4 pn_space_assign_cust_all.ATTRIBUTE4%TYPE
1800: ,ATTRIBUTE5 pn_space_assign_cust_all.ATTRIBUTE5%TYPE
1801: ,ATTRIBUTE6 pn_space_assign_cust_all.ATTRIBUTE6%TYPE
1802: ,ATTRIBUTE7 pn_space_assign_cust_all.ATTRIBUTE7%TYPE
1803: ,ATTRIBUTE8 pn_space_assign_cust_all.ATTRIBUTE8%TYPE
1804: ,ATTRIBUTE9 pn_space_assign_cust_all.ATTRIBUTE9%TYPE
1805: ,ATTRIBUTE10 pn_space_assign_cust_all.ATTRIBUTE10%TYPE

Line 1802: ,ATTRIBUTE7 pn_space_assign_cust_all.ATTRIBUTE7%TYPE

1798: ,ATTRIBUTE3 pn_space_assign_cust_all.ATTRIBUTE3%TYPE
1799: ,ATTRIBUTE4 pn_space_assign_cust_all.ATTRIBUTE4%TYPE
1800: ,ATTRIBUTE5 pn_space_assign_cust_all.ATTRIBUTE5%TYPE
1801: ,ATTRIBUTE6 pn_space_assign_cust_all.ATTRIBUTE6%TYPE
1802: ,ATTRIBUTE7 pn_space_assign_cust_all.ATTRIBUTE7%TYPE
1803: ,ATTRIBUTE8 pn_space_assign_cust_all.ATTRIBUTE8%TYPE
1804: ,ATTRIBUTE9 pn_space_assign_cust_all.ATTRIBUTE9%TYPE
1805: ,ATTRIBUTE10 pn_space_assign_cust_all.ATTRIBUTE10%TYPE
1806: ,ATTRIBUTE11 pn_space_assign_cust_all.ATTRIBUTE11%TYPE

Line 1803: ,ATTRIBUTE8 pn_space_assign_cust_all.ATTRIBUTE8%TYPE

1799: ,ATTRIBUTE4 pn_space_assign_cust_all.ATTRIBUTE4%TYPE
1800: ,ATTRIBUTE5 pn_space_assign_cust_all.ATTRIBUTE5%TYPE
1801: ,ATTRIBUTE6 pn_space_assign_cust_all.ATTRIBUTE6%TYPE
1802: ,ATTRIBUTE7 pn_space_assign_cust_all.ATTRIBUTE7%TYPE
1803: ,ATTRIBUTE8 pn_space_assign_cust_all.ATTRIBUTE8%TYPE
1804: ,ATTRIBUTE9 pn_space_assign_cust_all.ATTRIBUTE9%TYPE
1805: ,ATTRIBUTE10 pn_space_assign_cust_all.ATTRIBUTE10%TYPE
1806: ,ATTRIBUTE11 pn_space_assign_cust_all.ATTRIBUTE11%TYPE
1807: ,ATTRIBUTE12 pn_space_assign_cust_all.ATTRIBUTE12%TYPE

Line 1804: ,ATTRIBUTE9 pn_space_assign_cust_all.ATTRIBUTE9%TYPE

1800: ,ATTRIBUTE5 pn_space_assign_cust_all.ATTRIBUTE5%TYPE
1801: ,ATTRIBUTE6 pn_space_assign_cust_all.ATTRIBUTE6%TYPE
1802: ,ATTRIBUTE7 pn_space_assign_cust_all.ATTRIBUTE7%TYPE
1803: ,ATTRIBUTE8 pn_space_assign_cust_all.ATTRIBUTE8%TYPE
1804: ,ATTRIBUTE9 pn_space_assign_cust_all.ATTRIBUTE9%TYPE
1805: ,ATTRIBUTE10 pn_space_assign_cust_all.ATTRIBUTE10%TYPE
1806: ,ATTRIBUTE11 pn_space_assign_cust_all.ATTRIBUTE11%TYPE
1807: ,ATTRIBUTE12 pn_space_assign_cust_all.ATTRIBUTE12%TYPE
1808: ,ATTRIBUTE13 pn_space_assign_cust_all.ATTRIBUTE13%TYPE

Line 1805: ,ATTRIBUTE10 pn_space_assign_cust_all.ATTRIBUTE10%TYPE

1801: ,ATTRIBUTE6 pn_space_assign_cust_all.ATTRIBUTE6%TYPE
1802: ,ATTRIBUTE7 pn_space_assign_cust_all.ATTRIBUTE7%TYPE
1803: ,ATTRIBUTE8 pn_space_assign_cust_all.ATTRIBUTE8%TYPE
1804: ,ATTRIBUTE9 pn_space_assign_cust_all.ATTRIBUTE9%TYPE
1805: ,ATTRIBUTE10 pn_space_assign_cust_all.ATTRIBUTE10%TYPE
1806: ,ATTRIBUTE11 pn_space_assign_cust_all.ATTRIBUTE11%TYPE
1807: ,ATTRIBUTE12 pn_space_assign_cust_all.ATTRIBUTE12%TYPE
1808: ,ATTRIBUTE13 pn_space_assign_cust_all.ATTRIBUTE13%TYPE
1809: ,ATTRIBUTE14 pn_space_assign_cust_all.ATTRIBUTE14%TYPE

Line 1806: ,ATTRIBUTE11 pn_space_assign_cust_all.ATTRIBUTE11%TYPE

1802: ,ATTRIBUTE7 pn_space_assign_cust_all.ATTRIBUTE7%TYPE
1803: ,ATTRIBUTE8 pn_space_assign_cust_all.ATTRIBUTE8%TYPE
1804: ,ATTRIBUTE9 pn_space_assign_cust_all.ATTRIBUTE9%TYPE
1805: ,ATTRIBUTE10 pn_space_assign_cust_all.ATTRIBUTE10%TYPE
1806: ,ATTRIBUTE11 pn_space_assign_cust_all.ATTRIBUTE11%TYPE
1807: ,ATTRIBUTE12 pn_space_assign_cust_all.ATTRIBUTE12%TYPE
1808: ,ATTRIBUTE13 pn_space_assign_cust_all.ATTRIBUTE13%TYPE
1809: ,ATTRIBUTE14 pn_space_assign_cust_all.ATTRIBUTE14%TYPE
1810: ,ATTRIBUTE15 pn_space_assign_cust_all.ATTRIBUTE15%TYPE

Line 1807: ,ATTRIBUTE12 pn_space_assign_cust_all.ATTRIBUTE12%TYPE

1803: ,ATTRIBUTE8 pn_space_assign_cust_all.ATTRIBUTE8%TYPE
1804: ,ATTRIBUTE9 pn_space_assign_cust_all.ATTRIBUTE9%TYPE
1805: ,ATTRIBUTE10 pn_space_assign_cust_all.ATTRIBUTE10%TYPE
1806: ,ATTRIBUTE11 pn_space_assign_cust_all.ATTRIBUTE11%TYPE
1807: ,ATTRIBUTE12 pn_space_assign_cust_all.ATTRIBUTE12%TYPE
1808: ,ATTRIBUTE13 pn_space_assign_cust_all.ATTRIBUTE13%TYPE
1809: ,ATTRIBUTE14 pn_space_assign_cust_all.ATTRIBUTE14%TYPE
1810: ,ATTRIBUTE15 pn_space_assign_cust_all.ATTRIBUTE15%TYPE
1811: ,ORG_ID pn_space_assign_cust_all.ORG_ID%TYPE

Line 1808: ,ATTRIBUTE13 pn_space_assign_cust_all.ATTRIBUTE13%TYPE

1804: ,ATTRIBUTE9 pn_space_assign_cust_all.ATTRIBUTE9%TYPE
1805: ,ATTRIBUTE10 pn_space_assign_cust_all.ATTRIBUTE10%TYPE
1806: ,ATTRIBUTE11 pn_space_assign_cust_all.ATTRIBUTE11%TYPE
1807: ,ATTRIBUTE12 pn_space_assign_cust_all.ATTRIBUTE12%TYPE
1808: ,ATTRIBUTE13 pn_space_assign_cust_all.ATTRIBUTE13%TYPE
1809: ,ATTRIBUTE14 pn_space_assign_cust_all.ATTRIBUTE14%TYPE
1810: ,ATTRIBUTE15 pn_space_assign_cust_all.ATTRIBUTE15%TYPE
1811: ,ORG_ID pn_space_assign_cust_all.ORG_ID%TYPE
1812: ,LEASE_ID pn_space_assign_cust_all.LEASE_ID%TYPE

Line 1809: ,ATTRIBUTE14 pn_space_assign_cust_all.ATTRIBUTE14%TYPE

1805: ,ATTRIBUTE10 pn_space_assign_cust_all.ATTRIBUTE10%TYPE
1806: ,ATTRIBUTE11 pn_space_assign_cust_all.ATTRIBUTE11%TYPE
1807: ,ATTRIBUTE12 pn_space_assign_cust_all.ATTRIBUTE12%TYPE
1808: ,ATTRIBUTE13 pn_space_assign_cust_all.ATTRIBUTE13%TYPE
1809: ,ATTRIBUTE14 pn_space_assign_cust_all.ATTRIBUTE14%TYPE
1810: ,ATTRIBUTE15 pn_space_assign_cust_all.ATTRIBUTE15%TYPE
1811: ,ORG_ID pn_space_assign_cust_all.ORG_ID%TYPE
1812: ,LEASE_ID pn_space_assign_cust_all.LEASE_ID%TYPE
1813: ,RECOVERY_SPACE_STD_CODE pn_space_assign_cust_all.RECOVERY_SPACE_STD_CODE%TYPE

Line 1810: ,ATTRIBUTE15 pn_space_assign_cust_all.ATTRIBUTE15%TYPE

1806: ,ATTRIBUTE11 pn_space_assign_cust_all.ATTRIBUTE11%TYPE
1807: ,ATTRIBUTE12 pn_space_assign_cust_all.ATTRIBUTE12%TYPE
1808: ,ATTRIBUTE13 pn_space_assign_cust_all.ATTRIBUTE13%TYPE
1809: ,ATTRIBUTE14 pn_space_assign_cust_all.ATTRIBUTE14%TYPE
1810: ,ATTRIBUTE15 pn_space_assign_cust_all.ATTRIBUTE15%TYPE
1811: ,ORG_ID pn_space_assign_cust_all.ORG_ID%TYPE
1812: ,LEASE_ID pn_space_assign_cust_all.LEASE_ID%TYPE
1813: ,RECOVERY_SPACE_STD_CODE pn_space_assign_cust_all.RECOVERY_SPACE_STD_CODE%TYPE
1814: ,RECOVERY_TYPE_CODE pn_space_assign_cust_all.RECOVERY_TYPE_CODE%TYPE

Line 1811: ,ORG_ID pn_space_assign_cust_all.ORG_ID%TYPE

1807: ,ATTRIBUTE12 pn_space_assign_cust_all.ATTRIBUTE12%TYPE
1808: ,ATTRIBUTE13 pn_space_assign_cust_all.ATTRIBUTE13%TYPE
1809: ,ATTRIBUTE14 pn_space_assign_cust_all.ATTRIBUTE14%TYPE
1810: ,ATTRIBUTE15 pn_space_assign_cust_all.ATTRIBUTE15%TYPE
1811: ,ORG_ID pn_space_assign_cust_all.ORG_ID%TYPE
1812: ,LEASE_ID pn_space_assign_cust_all.LEASE_ID%TYPE
1813: ,RECOVERY_SPACE_STD_CODE pn_space_assign_cust_all.RECOVERY_SPACE_STD_CODE%TYPE
1814: ,RECOVERY_TYPE_CODE pn_space_assign_cust_all.RECOVERY_TYPE_CODE%TYPE
1815: ,FIN_OBLIG_END_DATE pn_space_assign_cust_all.FIN_OBLIG_END_DATE%TYPE

Line 1812: ,LEASE_ID pn_space_assign_cust_all.LEASE_ID%TYPE

1808: ,ATTRIBUTE13 pn_space_assign_cust_all.ATTRIBUTE13%TYPE
1809: ,ATTRIBUTE14 pn_space_assign_cust_all.ATTRIBUTE14%TYPE
1810: ,ATTRIBUTE15 pn_space_assign_cust_all.ATTRIBUTE15%TYPE
1811: ,ORG_ID pn_space_assign_cust_all.ORG_ID%TYPE
1812: ,LEASE_ID pn_space_assign_cust_all.LEASE_ID%TYPE
1813: ,RECOVERY_SPACE_STD_CODE pn_space_assign_cust_all.RECOVERY_SPACE_STD_CODE%TYPE
1814: ,RECOVERY_TYPE_CODE pn_space_assign_cust_all.RECOVERY_TYPE_CODE%TYPE
1815: ,FIN_OBLIG_END_DATE pn_space_assign_cust_all.FIN_OBLIG_END_DATE%TYPE
1816: ,TENANCY_ID pn_space_assign_cust_all.TENANCY_ID%TYPE

Line 1813: ,RECOVERY_SPACE_STD_CODE pn_space_assign_cust_all.RECOVERY_SPACE_STD_CODE%TYPE

1809: ,ATTRIBUTE14 pn_space_assign_cust_all.ATTRIBUTE14%TYPE
1810: ,ATTRIBUTE15 pn_space_assign_cust_all.ATTRIBUTE15%TYPE
1811: ,ORG_ID pn_space_assign_cust_all.ORG_ID%TYPE
1812: ,LEASE_ID pn_space_assign_cust_all.LEASE_ID%TYPE
1813: ,RECOVERY_SPACE_STD_CODE pn_space_assign_cust_all.RECOVERY_SPACE_STD_CODE%TYPE
1814: ,RECOVERY_TYPE_CODE pn_space_assign_cust_all.RECOVERY_TYPE_CODE%TYPE
1815: ,FIN_OBLIG_END_DATE pn_space_assign_cust_all.FIN_OBLIG_END_DATE%TYPE
1816: ,TENANCY_ID pn_space_assign_cust_all.TENANCY_ID%TYPE
1817: );

Line 1814: ,RECOVERY_TYPE_CODE pn_space_assign_cust_all.RECOVERY_TYPE_CODE%TYPE

1810: ,ATTRIBUTE15 pn_space_assign_cust_all.ATTRIBUTE15%TYPE
1811: ,ORG_ID pn_space_assign_cust_all.ORG_ID%TYPE
1812: ,LEASE_ID pn_space_assign_cust_all.LEASE_ID%TYPE
1813: ,RECOVERY_SPACE_STD_CODE pn_space_assign_cust_all.RECOVERY_SPACE_STD_CODE%TYPE
1814: ,RECOVERY_TYPE_CODE pn_space_assign_cust_all.RECOVERY_TYPE_CODE%TYPE
1815: ,FIN_OBLIG_END_DATE pn_space_assign_cust_all.FIN_OBLIG_END_DATE%TYPE
1816: ,TENANCY_ID pn_space_assign_cust_all.TENANCY_ID%TYPE
1817: );
1818:

Line 1815: ,FIN_OBLIG_END_DATE pn_space_assign_cust_all.FIN_OBLIG_END_DATE%TYPE

1811: ,ORG_ID pn_space_assign_cust_all.ORG_ID%TYPE
1812: ,LEASE_ID pn_space_assign_cust_all.LEASE_ID%TYPE
1813: ,RECOVERY_SPACE_STD_CODE pn_space_assign_cust_all.RECOVERY_SPACE_STD_CODE%TYPE
1814: ,RECOVERY_TYPE_CODE pn_space_assign_cust_all.RECOVERY_TYPE_CODE%TYPE
1815: ,FIN_OBLIG_END_DATE pn_space_assign_cust_all.FIN_OBLIG_END_DATE%TYPE
1816: ,TENANCY_ID pn_space_assign_cust_all.TENANCY_ID%TYPE
1817: );
1818:
1819: TYPE emp_rec_type IS RECORD(

Line 1816: ,TENANCY_ID pn_space_assign_cust_all.TENANCY_ID%TYPE

1812: ,LEASE_ID pn_space_assign_cust_all.LEASE_ID%TYPE
1813: ,RECOVERY_SPACE_STD_CODE pn_space_assign_cust_all.RECOVERY_SPACE_STD_CODE%TYPE
1814: ,RECOVERY_TYPE_CODE pn_space_assign_cust_all.RECOVERY_TYPE_CODE%TYPE
1815: ,FIN_OBLIG_END_DATE pn_space_assign_cust_all.FIN_OBLIG_END_DATE%TYPE
1816: ,TENANCY_ID pn_space_assign_cust_all.TENANCY_ID%TYPE
1817: );
1818:
1819: TYPE emp_rec_type IS RECORD(
1820: EMP_SPACE_ASSIGN_ID pn_space_assign_emp_all.EMP_SPACE_ASSIGN_ID%TYPE

Line 1880: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Defrag_Contig_Assign (+) Loc Id: '||p_location_id);

1876:
1877:
1878: BEGIN
1879:
1880: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Defrag_Contig_Assign (+) Loc Id: '||p_location_id);
1881:
1882: cust_tab.delete;
1883: l_rec_num := 0;
1884:

Line 1952: UPDATE pn_space_assign_cust_all

1948: -- If stepping thru cust PL/SQL table records finds contigous records with
1949: -- consecutive dates update the (i+1) record with the start date of the ith
1950: -- record and .......
1951: ---------------------------------------------------------------------------
1952: UPDATE pn_space_assign_cust_all
1953: SET cust_assign_start_date = cust_tab(i).cust_assign_start_date
1954: ,last_update_date = SYSDATE
1955: ,last_updated_by = NVL(FND_GLOBAL.USER_ID,'-1')
1956: ,last_update_login = NVL(FND_GLOBAL.LOGIN_ID,'-1')

Line 1964: pn_space_assign_cust_pkg.delete_row(cust_tab(i).cust_space_assign_id);

1960: -- ....... update the (i+1) record with the start date of the ith record
1961: -- in the PL/SQL table as well and delete the ith record from the DB
1962: ---------------------------------------------------------------------------
1963: cust_tab(i+1).cust_assign_start_date := cust_tab(i).cust_assign_start_date;
1964: pn_space_assign_cust_pkg.delete_row(cust_tab(i).cust_space_assign_id);
1965:
1966: END IF;
1967: END IF;
1968: pnp_debug_pkg.debug('Defrag_Contig_Assign Cust_Tab... l_rec_num>1 End_LOOP i= '||i);

Line 2056: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Defrag_Contig_Assign (-) Loc Id: '||p_location_id);

2052: pnp_debug_pkg.debug('Defrag_Contig_Assign Emp_Tab... l_rec_num>1 End_LOOP i= '||i);
2053: END LOOP;
2054: END IF;
2055:
2056: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Defrag_Contig_Assign (-) Loc Id: '||p_location_id);
2057:
2058: END Defrag_Contig_Assign;
2059:
2060: -------------------------------------------------------------------------------

Line 2077: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.merge_tables (+)');

2073: l_exists BOOLEAN;
2074:
2075: BEGIN
2076:
2077: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.merge_tables (+)');
2078:
2079: -- do simple bubble search to identify new tables.
2080: FOR i IN 1..p_new_table.COUNT LOOP
2081:

Line 2094: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.merge_tables (-)');

2090: END IF;
2091:
2092: END LOOP;
2093:
2094: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.merge_tables (-)');
2095:
2096: END;
2097:
2098: -------------------------------------------------------------------------------

Line 2138: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_emp (+)');

2134: l_result_tbl loc_id_tbl;
2135:
2136: BEGIN
2137:
2138: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_emp (+)');
2139:
2140: IF x_emp_space_assign_id IS NULL THEN
2141:
2142: UPDATE pn_space_assign_emp_all

Line 2181: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_emp (-)');

2177: merge_tables(p_base_table => l_result_tbl, p_new_table => l_loc_tbl_conc_cc);
2178:
2179: x_loc_id_tbl := l_result_tbl;
2180:
2181: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_emp (-)');
2182:
2183: END delete_other_assignments_emp;
2184:
2185:

Line 2194: -- 06-FEB-01 dthota o bug # 1609377 - Added code to update PN_SPACE_ASSIGN_CUST.

2190: -- ARGUMENTS : IN : x_cust_account_id, x_cust_assign_start_date,
2191: -- x_cust_space_assign_id, x_loc_id_tbl
2192: -- REFERENCE : PN_COMMON.debug()
2193: -- HISTORY :
2194: -- 06-FEB-01 dthota o bug # 1609377 - Added code to update PN_SPACE_ASSIGN_CUST.
2195: -- cust_assign_end_date of all customer assignments whose
2196: -- start date is less than the start date of the assignmemnt
2197: -- record being entered with (cust_assign_start_date -1) and
2198: -- all customer assignments whose start date is equal to the

Line 2204: -- 21-JUN-05 hrodda o Bug 4284035 - Replaced pn_space_assign_cust

2200: -- (cust_assign_start_date)
2201: -- 09-MAR-04 ftanudj o added parameter x_cust_space_assign_id.
2202: -- 06-APR-05 ftanudja o Moved from PNTSPACE library. #4270051.
2203: -- o Added parameter x_loc_id_tbl
2204: -- 21-JUN-05 hrodda o Bug 4284035 - Replaced pn_space_assign_cust
2205: -- with _ALL table.
2206: -------------------------------------------------------------------------------
2207:
2208: PROCEDURE delete_other_assignments_cust(

Line 2209: x_cust_account_id IN pn_space_assign_cust.cust_account_id%TYPE,

2205: -- with _ALL table.
2206: -------------------------------------------------------------------------------
2207:
2208: PROCEDURE delete_other_assignments_cust(
2209: x_cust_account_id IN pn_space_assign_cust.cust_account_id%TYPE,
2210: x_cust_assign_start_date IN pn_space_assign_cust.cust_assign_start_date%TYPE,
2211: x_cust_space_assign_id IN pn_space_assign_cust.cust_space_assign_id%TYPE,
2212: x_loc_id_tbl OUT NOCOPY LOC_ID_TBL
2213: ) IS

Line 2210: x_cust_assign_start_date IN pn_space_assign_cust.cust_assign_start_date%TYPE,

2206: -------------------------------------------------------------------------------
2207:
2208: PROCEDURE delete_other_assignments_cust(
2209: x_cust_account_id IN pn_space_assign_cust.cust_account_id%TYPE,
2210: x_cust_assign_start_date IN pn_space_assign_cust.cust_assign_start_date%TYPE,
2211: x_cust_space_assign_id IN pn_space_assign_cust.cust_space_assign_id%TYPE,
2212: x_loc_id_tbl OUT NOCOPY LOC_ID_TBL
2213: ) IS
2214:

Line 2211: x_cust_space_assign_id IN pn_space_assign_cust.cust_space_assign_id%TYPE,

2207:
2208: PROCEDURE delete_other_assignments_cust(
2209: x_cust_account_id IN pn_space_assign_cust.cust_account_id%TYPE,
2210: x_cust_assign_start_date IN pn_space_assign_cust.cust_assign_start_date%TYPE,
2211: x_cust_space_assign_id IN pn_space_assign_cust.cust_space_assign_id%TYPE,
2212: x_loc_id_tbl OUT NOCOPY LOC_ID_TBL
2213: ) IS
2214:
2215: l_loc_tbl_past loc_id_tbl;

Line 2222: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_cust (+)');

2218: l_result_tbl loc_id_tbl;
2219:
2220: BEGIN
2221:
2222: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_cust (+)');
2223:
2224: IF x_cust_space_assign_id IS NULL THEN
2225:
2226: UPDATE pn_space_assign_cust_all

Line 2226: UPDATE pn_space_assign_cust_all

2222: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_cust (+)');
2223:
2224: IF x_cust_space_assign_id IS NULL THEN
2225:
2226: UPDATE pn_space_assign_cust_all
2227: SET cust_assign_end_date = (TRUNC(x_cust_assign_start_date) - 1)
2228: WHERE cust_account_id = x_cust_account_id
2229: AND cust_assign_start_date < TRUNC(x_cust_assign_start_date)
2230: AND NVL(cust_assign_end_date,TO_DATE('12/31/4712','MM/DD/YYYY')) >= TRUNC(x_cust_assign_start_date)

Line 2233: UPDATE pn_space_assign_cust_all

2229: AND cust_assign_start_date < TRUNC(x_cust_assign_start_date)
2230: AND NVL(cust_assign_end_date,TO_DATE('12/31/4712','MM/DD/YYYY')) >= TRUNC(x_cust_assign_start_date)
2231: RETURNING location_id BULK COLLECT INTO l_loc_tbl_past;
2232:
2233: UPDATE pn_space_assign_cust_all
2234: SET cust_assign_end_date = TRUNC(x_cust_assign_start_date)
2235: WHERE cust_account_id = x_cust_account_id
2236: AND cust_assign_start_date = TRUNC(x_cust_assign_start_date)
2237: RETURNING location_id BULK COLLECT INTO l_loc_tbl_conc;

Line 2241: UPDATE pn_space_assign_cust_all

2237: RETURNING location_id BULK COLLECT INTO l_loc_tbl_conc;
2238:
2239: ELSE
2240:
2241: UPDATE pn_space_assign_cust_all
2242: SET cust_assign_end_date = (TRUNC(x_cust_assign_start_date) - 1)
2243: WHERE cust_account_id = x_cust_account_id
2244: AND cust_space_assign_id <> x_cust_space_assign_id
2245: AND cust_assign_start_date < TRUNC(x_cust_assign_start_date)

Line 2249: UPDATE pn_space_assign_cust_all

2245: AND cust_assign_start_date < TRUNC(x_cust_assign_start_date)
2246: AND NVL(cust_assign_end_date,TO_DATE('12/31/4712','MM/DD/YYYY')) >= TRUNC(x_cust_assign_start_date)
2247: RETURNING location_id BULK COLLECT INTO l_loc_tbl_past;
2248:
2249: UPDATE pn_space_assign_cust_all
2250: SET cust_assign_end_date = TRUNC(x_cust_assign_start_date)
2251: WHERE cust_account_id = x_cust_account_id
2252: AND cust_space_assign_id <> x_cust_space_assign_id
2253: AND cust_assign_start_date = TRUNC(x_cust_assign_start_date)

Line 2263: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_cust (+)');

2259: merge_tables(p_base_table => l_result_tbl, p_new_table => l_loc_tbl_conc);
2260:
2261: x_loc_id_tbl := l_result_tbl;
2262:
2263: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_cust (+)');
2264:
2265: END delete_other_assignments_cust;
2266:
2267:

Line 2268: END PN_SPACE_ASSIGN_CUST_PKG;

2264:
2265: END delete_other_assignments_cust;
2266:
2267:
2268: END PN_SPACE_ASSIGN_CUST_PKG;