The following lines contain the word 'select', 'insert', 'update' or 'delete':
AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
OR p_operation = OE_PC_GLOBALS.CREATE_OP)
AND p_column_name IS NOT NULL THEN
SELECT column_name
INTO l_column_name
FROM oe_pc_constraints
WHERE constraint_id = l_constraint_id;
oe_debug_pub.add('Constraint on UPDATE of all columns!');
( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
, p_record IN OE_AK_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_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_BLANKET_LINES_V%ROWTYPE
, x_on_operation_action OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result NUMBER;
ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
l_operation := OE_PC_GLOBALS.UPDATE_OP;
ELSIF p_LINE_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_LINE
,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_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
l_operation := OE_PC_GLOBALS.UPDATE_OP;