DBA Data[Home] [Help]

APPS.AHL_RM_OPERATION_PVT dependencies on AHL_ROUTE_OPERATIONS

Line 1883: DELETE AHL_ROUTE_OPERATIONS

1879: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Reference Documents' );
1880: END IF;
1881:
1882: -- 4.Delete Associated Operations
1883: DELETE AHL_ROUTE_OPERATIONS
1884: WHERE OPERATION_ID = p_operation_id;
1885:
1886: -- If no records exist, then, Continue.
1887: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 2537: INSERT INTO AHL_ROUTE_OPERATIONS

2533: );
2534: END LOOP;
2535:
2536: -- 4.Copy Associated Routes
2537: INSERT INTO AHL_ROUTE_OPERATIONS
2538: (
2539: ROUTE_OPERATION_ID,
2540: OBJECT_VERSION_NUMBER,
2541: ROUTE_ID,

Line 2568: AHL_ROUTE_OPERATIONS_S.NEXTVAL,

2564: CREATED_BY,
2565: LAST_UPDATE_LOGIN
2566: )
2567: SELECT
2568: AHL_ROUTE_OPERATIONS_S.NEXTVAL,
2569: 1,
2570: ROUTE_ID,
2571: l_operation_id,
2572: STEP,

Line 2595: FROM AHL_ROUTE_OPERATIONS

2591: G_LAST_UPDATED_BY,
2592: G_CREATION_DATE,
2593: G_CREATED_BY,
2594: G_LAST_UPDATE_LOGIN
2595: FROM AHL_ROUTE_OPERATIONS
2596: WHERE operation_id = p_operation_id;
2597:
2598: -- Adithya added to fix bug# 6525763
2599: -- 5.Copy Access Panels