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_ALL

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 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 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 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 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 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 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 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 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 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 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 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 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 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)