APPS.AHL_RM_OPERATION_PVT dependencies on AHL_RT_OPER_ACCESS_PANELS

Line 1897: DELETE AHL_RT_OPER_ACCESS_PANELS

1893: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Associated Operations' );
1894: END IF;
1895:
1896: -- 5.Delete Access Panels associated
1897: DELETE AHL_RT_OPER_ACCESS_PANELS
1898: WHERE OBJECT_ID = p_operation_id
1899: AND ASSOCIATION_TYPE_CODE = 'OPERATION';
1900:
1901: -- If no records exist, then, Continue.

Line 2600: INSERT INTO AHL_RT_OPER_ACCESS_PANELS

2596: WHERE operation_id = p_operation_id;
2597:
2598: -- Adithya added to fix bug# 6525763
2599: -- 5.Copy Access Panels
2600: INSERT INTO AHL_RT_OPER_ACCESS_PANELS
2601: (
2602: RT_OPER_PANEL_ID,
2603: OBJECT_VERSION_NUMBER,
2604: OBJECT_ID,

Line 2630: AHL_RT_OPER_ACCESS_PANELS_S.NEXTVAL,

2626: CREATED_BY,
2627: LAST_UPDATE_LOGIN
2628: )
2629: SELECT
2630: AHL_RT_OPER_ACCESS_PANELS_S.NEXTVAL,
2631: 1,
2632: l_operation_id,
2633: ASSOCIATION_TYPE_CODE,
2634: PANEL_TYPE_ID,

Line 2656: FROM AHL_RT_OPER_ACCESS_PANELS

2652: FND_GLOBAL.user_id,
2653: SYSDATE,
2654: FND_GLOBAL.user_id,
2655: FND_GLOBAL.login_id
2656: FROM AHL_RT_OPER_ACCESS_PANELS
2657: WHERE object_id = p_operation_id
2658: AND association_type_code = 'OPERATION';
2659:
2660: -- Set the Out values.