APPS.PN_CAD_IMPORT dependencies on PN_SPACE_ASSIGN_EMP_PKG

Line 1644: | o Removed all references to pn_space_assign_emp_pkg.

1640: | is -99. In this case error out indicating that
1641: | the location is a common space.
1642: | Bug #3598315
1643: | 16-JUN-04 ftanudja o Created variable tlempinfo.
1644: | o Removed all references to pn_space_assign_emp_pkg.
1645: | tlempinfo.
1646: | o Added validation for allocated_area for manual
1647: | spc assignments.
1648: | o Fixed id validation for entry type 'U','R'.

Line 1769: -- Using variables and Row Handlers from PN_SPACE_ASSIGN_EMP_PKG

1765:
1766: /*--------------------------------------------------------------
1767: -- NOTE: If we are here, it means we are handling INSERT/UPDATE
1768: -- get the old record if this is an update/replace --
1769: -- Using variables and Row Handlers from PN_SPACE_ASSIGN_EMP_PKG
1770: -- for insert and update into pn_space_assign_emp.
1771: --------------------------------------------------------------*/
1772:
1773: put_log( 'Validating emp_space_assign_id and getting the old record for UPDATE/REPLACE' );

Line 2100: PN_SPACE_ASSIGN_EMP_PKG.insert_row

2096: raise INVALID_RECORD; --Bug5515198
2097: END IF;
2098:
2099:
2100: PN_SPACE_ASSIGN_EMP_PKG.insert_row
2101: (
2102: X_ROWID => l_rowid_dummy,
2103: X_org_id => l_org_id,
2104: X_EMP_SPACE_ASSIGN_ID => space.EMP_SPACE_ASSIGN_ID,

Line 2184: PN_SPACE_ASSIGN_EMP_PKG.update_row

2180: raise INVALID_RECORD; --Bug5515198
2181: END IF;
2182:
2183:
2184: PN_SPACE_ASSIGN_EMP_PKG.update_row
2185: (
2186: X_EMP_SPACE_ASSIGN_ID => space.EMP_SPACE_ASSIGN_ID,
2187: X_ATTRIBUTE1 => space.ATTRIBUTE1,
2188: X_ATTRIBUTE2 => space.ATTRIBUTE2,

Line 2247: PN_SPACE_ASSIGN_EMP_PKG.update_row

2243: raise INVALID_RECORD; --Bug5515198
2244: END IF;
2245:
2246:
2247: PN_SPACE_ASSIGN_EMP_PKG.update_row
2248: (
2249: X_EMP_SPACE_ASSIGN_ID => NVL(space.EMP_SPACE_ASSIGN_ID,tlempinfo.EMP_SPACE_ASSIGN_ID),
2250: X_ATTRIBUTE1 => NVL(space.ATTRIBUTE1,tlempinfo.ATTRIBUTE1),
2251: X_ATTRIBUTE2 => NVL(space.ATTRIBUTE2,tlempinfo.ATTRIBUTE2),