APPS.OE_LINE_SECURITY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 68

       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_column_name
          FROM oe_pc_constraints
          WHERE constraint_id = l_constraint_id;

Line: 78

             oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);

Line: 520

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 540

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 559

FUNCTION calculate_price_flag(p_operation           IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
                             ,p_record              IN  oe_ak_order_lines_v%ROWTYPE
                             ,x_on_operation_action OUT NOCOPY NUMBER)
RETURN NUMBER IS
   l_result   NUMBER := 0;

Line: 577

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result        NUMBER :=0;

Line: 596

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 616

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 638

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 659

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 679

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 699

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 719

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 739

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 760

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 781

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 801

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 821

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 841

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 861

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 881

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 901

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 921

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 941

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 961

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 981

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 1001

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 1021

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 1041

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 1062

 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
 ) RETURN NUMBER
 IS
 l_result  NUMBER;

Line: 1081

 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
 ) RETURN NUMBER
 IS
 l_result  NUMBER;

Line: 1101

 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
 ) RETURN NUMBER
 IS
 l_result  NUMBER;

Line: 1126

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1147

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1168

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1189

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1210

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1231

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result        NUMBER;

Line: 1252

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1273

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1294

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1315

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1336

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1357

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1377

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1398

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1419

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1440

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1461

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1483

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1504

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1524

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1545

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1565

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1585

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1606

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1627

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1648

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1669

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1690

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1711

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1723

IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN
   SELECT Ordered_Quantity
   INTO l_old_qty
   FROM OE_ORDER_LINES
   WHERE line_id = p_record.line_id;

Line: 1740

   AND p_operation = OE_PC_GLOBALS.UPDATE_OP
   AND nvl(p_record.ordered_quantity,0) < nvl(l_old_qty,0)
   AND NOT(p_record.split_action_code IS NOT NULL AND
		p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN
    l_result := ORDERED_QUANTITY
        (p_operation	=> OE_PC_GLOBALS.CANCEL_OP
        ,p_record	=> p_record
        ,x_on_operation_action => x_on_operation_action
        );

Line: 1749

ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP
   AND (p_record.split_action_code IS NOT NULL AND
		p_record.split_action_code <> FND_API.G_MISS_CHAR AND
		p_record.split_action_code = 'SPLIT') THEN
    l_result := ORDERED_QUANTITY
        (p_operation	=> OE_PC_GLOBALS.SPLIT_OP
        ,p_record	=> p_record
        ,x_on_operation_action => x_on_operation_action
        );

Line: 1774

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1783

IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN
    SELECT Ordered_Quantity2
    INTO l_old_qty2
    FROM OE_ORDER_LINES
    WHERE line_id = p_record.line_id;

Line: 1791

IF p_operation = OE_PC_GLOBALS.UPDATE_OP
   AND nvl(p_record.ordered_quantity2,0) < nvl(l_old_qty2,0)
   AND NOT(p_record.split_action_code IS NOT NULL AND
		p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN
    l_result := ORDERED_QUANTITY2
        (p_operation	=> OE_PC_GLOBALS.CANCEL_OP
        ,p_record	=> p_record
        ,x_on_operation_action => x_on_operation_action
        );

Line: 1800

ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP
   AND (p_record.split_action_code IS NOT NULL AND
		p_record.split_action_code <> FND_API.G_MISS_CHAR AND
		p_record.split_action_code = 'SPLIT') THEN
    l_result := ORDERED_QUANTITY2
        (p_operation	=> OE_PC_GLOBALS.SPLIT_OP
        ,p_record	=> p_record
        ,x_on_operation_action => x_on_operation_action
        );

Line: 1826

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1847

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1868

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1889

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1910

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1930

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 1952

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1972

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 1993

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2014

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2035

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2056

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2077

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2098

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2118

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2138

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2159

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2180

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2201

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2221

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2241

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2262

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2282

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2303

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2324

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2345

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2367

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2388

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 2409

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 2430

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2452

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2472

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2496

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2517

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2537

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result  NUMBER;

Line: 2557

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2578

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2599

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2620

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2641

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2662

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2683

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2704

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2725

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2746

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2767

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2788

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2809

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2830

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2853

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2875

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2896

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2916

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2936

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2958

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2978

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 2998

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 3018

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 3038

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 3058

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 3078

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 3098

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 3115

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 3132

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 3149

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 3166

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 3185

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 3207

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 3227

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 3247

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 3267

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER /* file.sql.39 change */
) RETURN NUMBER
IS
l_result        NUMBER;

Line: 3325

	SELECT flow_status_code
	INTO l_flow_status_code
	FROM oe_order_lines
	WHERE line_id = p_line_rec.service_reference_line_id;

Line: 3361

ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_operation := OE_PC_GLOBALS.UPDATE_OP;

Line: 3363

ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
    l_operation := OE_PC_GLOBALS.DELETE_OP;

Line: 3386

	ELSIF ( p_line_rec.operation = 'UPDATE' and p_line_rec.split_action_code='SPLIT' ) THEN
		IF l_debug_level  > 0 THEN
			oe_debug_pub.add('resetting operation from Update to SPLIT before Is_OP_constrained');

Line: 3465

    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;

Line: 3474

ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_operation := OE_PC_GLOBALS.UPDATE_OP;

Line: 5153

	   SELECT active_flag
	   INTO l_active_flag
	   FROM qp_List_headers_vl
	   WHERE list_header_id = p_line_rec.price_list_id;

Line: 5216

    IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
       l_check_all_cols_constraint := g_check_all_cols_constraint;

Line: 5662

    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);

Line: 5695

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 5715

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 5734

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 5753

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 5774

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 5795

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
) RETURN NUMBER
IS
l_result 	NUMBER;

Line: 5857

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result        NUMBER;

Line: 5875

(   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
,   x_on_operation_action           OUT NOCOPY NUMBER
) RETURN NUMBER
IS
l_result        NUMBER;