The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL(BOOKED_FLAG,'N')
FROM OE_ORDER_HEADERS_ALL
WHERE HEADER_ID = x_header_id;
AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
OR p_operation = OE_PC_GLOBALS.CREATE_OP)
AND x_on_operation_action = 0
AND p_column_name IS NOT NULL THEN
SELECT column_name
INTO l_constrained_column
FROM oe_pc_constraints
WHERE constraint_id = l_constraint_id;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
FUNCTION LAST_UPDATED_BY
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
,p_column_name => 'LAST_UPDATED_BY'
,p_record => p_record
,x_on_operation_action => x_on_operation_action
);
END LAST_UPDATED_BY;
FUNCTION LAST_UPDATE_DATE
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
,p_column_name => 'LAST_UPDATE_DATE'
,p_record => p_record
,x_on_operation_action => x_on_operation_action
);
END LAST_UPDATE_DATE;
FUNCTION LAST_UPDATE_LOGIN
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
,p_column_name => 'LAST_UPDATE_LOGIN'
,p_record => p_record
,x_on_operation_action => x_on_operation_action
);
END LAST_UPDATE_LOGIN;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
FUNCTION PROGRAM_UPDATE_DATE
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
,p_column_name => 'PROGRAM_UPDATE_DATE'
,p_record => p_record
,x_on_operation_action => x_on_operation_action
);
END PROGRAM_UPDATE_DATE;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
FUNCTION updated_flag
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
,p_column_name => 'UPDATED_FLAG'
,p_record => p_record
,x_on_operation_action => x_on_operation_action
);
END updated_flag;
FUNCTION update_allowed
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
,p_column_name => 'UPDATE_ALLOWED'
,p_record => p_record
,x_on_operation_action => x_on_operation_action
);
END update_allowed;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
l_operation := OE_PC_GLOBALS.UPDATE_OP;
ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
l_operation := OE_PC_GLOBALS.DELETE_OP;
IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
(p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_ADJ
,p_responsibility_id => nvl(fnd_global.resp_id, -1)
,p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
)
THEN
RETURN;
ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
l_operation := OE_PC_GLOBALS.UPDATE_OP;
x_result := Is_OP_constrained ( p_operation => OE_PC_GLOBALS.DELETE_OP
, p_record => l_rowtype_rec
, x_on_operation_action => l_on_operation_action
);
IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
l_check_all_cols_constraint := g_check_all_cols_constraint;
IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;