APPS.AHL_LTP_SPACE_CAPB_PVT dependencies on AHL_SPACE_CAPABILITIES

Line 1672: DELETE FROM AHL_SPACE_CAPABILITIES

1668: AHL_SPACES_PKG.DELETE_ROW (
1669: X_SPACE_ID => l_space_id
1670: );
1671: --
1672: DELETE FROM AHL_SPACE_CAPABILITIES
1673: WHERE SPACE_ID = l_space_id;
1674:
1675: END IF;
1676: ---------------------------End of Body---------------------------------------

Line 1876: FROM ahl_space_capabilities

1872: ATTRIBUTE12,
1873: ATTRIBUTE13,
1874: ATTRIBUTE14,
1875: ATTRIBUTE15
1876: FROM ahl_space_capabilities
1877: WHERE space_capability_id = p_space_capbl_rec.space_capability_id
1878: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1879: --
1880: -- This is the only exception for using %ROWTYPE.

Line 2038: FROM AHL_SPACE_CAPABILITIES

2034: c_inventory_item_code IN VARCHAR2,
2035: c_space_id IN NUMBER)
2036: IS
2037: SELECT 'X'
2038: FROM AHL_SPACE_CAPABILITIES
2039: WHERE ORGANIZATION_ID = c_organization_id
2040: AND VISIT_TYPE = c_visit_type
2041: AND INVENTORY_ITEM_ID = c_inventory_item_code
2042: AND SPACE_ID = c_space_id;

Line 2103: 'ahl_space_capabilities',

2099: /* IF p_validation_mode = Jtf_Plsql_Api.g_create
2100: AND p_space_capbl_rec.visit_type_code IS NOT NULL
2101: THEN
2102: IF Ahl_Utility_Pvt.check_uniqueness(
2103: 'ahl_space_capabilities',
2104: 'visit_type = ' || p_space_capbl_rec.visit_type_code ||
2105: ''' AND inventory_item_id = ''' || p_space_capbl_rec.inventory_item_id
2106: ) = Fnd_Api.g_false
2107: THEN

Line 2289: -- p_x_space_capblts_rec: the record representing AHL_SPACE_CAPABILITIES table..

2285: -- PURPOSE
2286: -- Create Space Capabilities Record
2287: --
2288: -- PARAMETERS
2289: -- p_x_space_capblts_rec: the record representing AHL_SPACE_CAPABILITIES table..
2290: --
2291: -- NOTES
2292: --------------------------------------------------------------------
2293: PROCEDURE Create_Space_Capblts (

Line 2321: SELECT AHL_SPACE_CAPABILITIES_S.NEXTVAL

2317: l_space_capblts_rec Space_Capbl_Rec;
2318: --
2319: CURSOR c_seq
2320: IS
2321: SELECT AHL_SPACE_CAPABILITIES_S.NEXTVAL
2322: FROM dual;
2323: --
2324: CURSOR c_id_exists (x_id IN NUMBER) IS
2325: SELECT 1

Line 2328: FROM ahl_space_capabilities

2324: CURSOR c_id_exists (x_id IN NUMBER) IS
2325: SELECT 1
2326: FROM dual
2327: WHERE EXISTS (SELECT 1
2328: FROM ahl_space_capabilities
2329: WHERE space_capability_id = x_id);
2330: --Get organization id
2331: CURSOR get_org_cur (c_space_id IN NUMBER)
2332: IS

Line 2694: INSERT INTO AHL_SPACE_CAPABILITIES

2690:
2691: ----------------------------DML Operation---------------------------------
2692: --insert space capabilities record
2693:
2694: INSERT INTO AHL_SPACE_CAPABILITIES
2695: (
2696: SPACE_CAPABILITY_ID,
2697: VISIT_TYPE,
2698: INVENTORY_ITEM_ID,

Line 3053: UPDATE AHL_SPACE_CAPABILITIES

3049:
3050: ----------------------------DML Operation---------------------------------
3051: --Call table handler generated package to update a record
3052:
3053: UPDATE AHL_SPACE_CAPABILITIES
3054: SET organization_id = l_space_capblts_rec.organization_id,
3055: space_id = l_space_capblts_rec.space_id,
3056: visit_type = l_space_capblts_rec.visit_type_code,
3057: inventory_item_id = l_space_capblts_rec.inventory_item_id,

Line 3165: -- p_space_capblts_rec: the record representing AHL_SPACE_CAPABILITIES table

3161: -- PURPOSE
3162: -- Delete Space Capabilities Record.
3163: --
3164: -- PARAMETERS
3165: -- p_space_capblts_rec: the record representing AHL_SPACE_CAPABILITIES table
3166: --
3167: -- ISSUES
3168: --
3169: -- NOTES

Line 3190: FROM ahl_space_capabilities

3186: (c_space_capability_id IN NUMBER)
3187: IS
3188: SELECT space_capability_id,object_version_number,
3189: visit_type,inventory_item_id
3190: FROM ahl_space_capabilities
3191: WHERE space_capability_id = c_space_capability_id
3192: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3193: -- Get space assignment
3194: CURSOR space_assign_cur (c_space_id IN NUMBER)

Line 3295: DELETE FROM AHL_SPACE_CAPABILITIES

3291: IF G_DEBUG='Y' THEN
3292: AHL_DEBUG_PUB.debug( 'before delete capabilities');
3293: END IF;
3294: -------------------Remove the reocrd from space capabilities------------
3295: DELETE FROM AHL_SPACE_CAPABILITIES
3296: WHERE SPACE_CAPABILITY_ID = l_space_capability_id;
3297:
3298: ---------------------------End of Body---------------------------------------
3299: --Standard check to count messages