APPS.AHL_RM_RT_OPER_PANEL_PVT dependencies on AHL_RT_OPER_ACCESS_PANELS

Line 307: FROM AHL_RT_OPER_ACCESS_PANELS

303: attribute12,
304: attribute13,
305: attribute14,
306: attribute15
307: FROM AHL_RT_OPER_ACCESS_PANELS
308: WHERE rt_oper_panel_id = c_rt_oper_panel_id;
309:
310: BEGIN
311:

Line 312: -- Get the old record from AHL_RT_OPER_ACCESS_PANELS.

308: WHERE rt_oper_panel_id = c_rt_oper_panel_id;
309:
310: BEGIN
311:
312: -- Get the old record from AHL_RT_OPER_ACCESS_PANELS.
313: OPEN get_old_rec( p_x_rt_oper_panel_rec.rt_oper_panel_id );
314:
315: FETCH get_old_rec INTO
316: l_old_rt_oper_panel_rec.panel_type_id,

Line 522: FROM AHL_RT_OPER_ACCESS_PANELS_V

518: CURSOR get_dup_rec ( c_object_id NUMBER, c_association_type_code VARCHAR2 )
519: IS
520: SELECT panel_type_id,
521: panel_type
522: FROM AHL_RT_OPER_ACCESS_PANELS_V
523: WHERE object_id = c_object_id
524: AND association_type_code = c_association_type_code
525: GROUP BY panel_type_id,
526: panel_type

Line 844: INSERT INTO AHL_RT_OPER_ACCESS_PANELS

840: IF ( p_x_rt_oper_panel_tbl(i).dml_operation = 'C' ) THEN
841:
842: BEGIN
843: -- Insert the record
844: INSERT INTO AHL_RT_OPER_ACCESS_PANELS
845: (
846: rt_oper_panel_id,
847: OBJECT_VERSION_NUMBER,
848: LAST_UPDATE_DATE,

Line 874: AHL_RT_OPER_ACCESS_PANELS_S.NEXTVAL,

870: ATTRIBUTE14,
871: ATTRIBUTE15
872: ) VALUES
873: (
874: AHL_RT_OPER_ACCESS_PANELS_S.NEXTVAL,
875: 1,
876: G_LAST_UPDATE_DATE,
877: G_LAST_UPDATED_BY,
878: G_CREATION_DATE,

Line 917: 'AHL_RT_OPER_ACCESS_PANELS insert error = ['||SQLERRM||']'

913: fnd_log.string
914: (
915: fnd_log.level_unexpected,
916: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME1,
917: 'AHL_RT_OPER_ACCESS_PANELS insert error = ['||SQLERRM||']'
918: );
919: END IF;
920: END IF;
921: END;

Line 927: UPDATE AHL_RT_OPER_ACCESS_PANELS SET

923: ELSIF ( p_x_rt_oper_panel_tbl(i).dml_operation = 'U' ) THEN
924:
925: BEGIN
926: -- Update the record
927: UPDATE AHL_RT_OPER_ACCESS_PANELS SET
928: object_version_number = object_version_number + 1,
929: last_update_date = G_LAST_UPDATE_DATE,
930: last_updated_by = G_LAST_UPDATED_BY,
931: last_update_login = G_LAST_UPDATE_LOGIN,

Line 974: 'AHL_RT_OPER_ACCESS_PANELS update error = ['||SQLERRM||']'

970: fnd_log.string
971: (
972: fnd_log.level_unexpected,
973: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME1,
974: 'AHL_RT_OPER_ACCESS_PANELS update error = ['||SQLERRM||']'
975: );
976: END IF;
977: END IF;
978: END;

Line 983: DELETE FROM AHL_RT_OPER_ACCESS_PANELS

979:
980: ELSIF ( p_x_rt_oper_panel_tbl(i).dml_operation = 'D' ) THEN
981:
982: -- Delete the record
983: DELETE FROM AHL_RT_OPER_ACCESS_PANELS
984: WHERE rt_oper_panel_id = p_x_rt_oper_panel_tbl(i).rt_oper_panel_id
985: AND object_version_number = p_x_rt_oper_panel_tbl(i).object_version_number;
986:
987: -- If the record does not exist, then, abort API.