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: 518

(   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: 538

(   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: 557

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: 575

(   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: 594

(   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: 614

(   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: 636

(   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: 657

(   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: 677

(   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: 697

(   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: 717

(   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: 737

(   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: 758

(   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: 779

(   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: 799

(   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: 819

(   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: 839

(   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: 859

(   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: 879

(   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: 899

(   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: 919

(   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: 939

(   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: 959

(   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: 979

(   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: 999

(   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: 1019

(   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: 1039

(   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: 1061

(   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: 1082

(   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: 1103

(   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: 1124

(   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: 1145

(   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: 1166

(   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: 1187

(   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: 1208

(   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: 1229

(   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: 1250

(   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: 1271

(   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: 1291

(   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: 1312

(   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: 1333

(   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: 1354

(   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: 1375

(   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: 1397

(   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: 1418

(   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: 1438

(   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: 1459

(   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: 1479

(   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: 1499

(   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: 1520

(   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: 1541

(   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: 1562

(   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: 1583

(   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: 1604

(   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: 1625

(   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: 1637

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: 1654

   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: 1663

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: 1688

(   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: 1697

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: 1705

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: 1714

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: 1740

(   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: 1761

(   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: 1782

(   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: 1803

(   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: 1824

(   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: 1844

(   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: 1866

(   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: 1886

(   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: 1907

(   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: 1928

(   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: 1949

(   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: 1970

(   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: 1991

(   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: 2012

(   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: 2032

(   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: 2052

(   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: 2073

(   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: 2094

(   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: 2115

(   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: 2135

(   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: 2155

(   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: 2176

(   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: 2196

(   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: 2217

(   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: 2238

(   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: 2259

(   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: 2281

(   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: 2302

(   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: 2323

(   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: 2344

(   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: 2366

(   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: 2386

(   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: 2410

(   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: 2431

(   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: 2451

(   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: 2471

(   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: 2492

(   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: 2513

(   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: 2534

(   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: 2555

(   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: 2576

(   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: 2597

(   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: 2618

(   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: 2639

(   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: 2660

(   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: 2681

(   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: 2702

(   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: 2723

(   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: 2744

(   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: 2789

(   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: 2810

(   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: 2850

(   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: 2872

(   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: 2892

(   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: 2912

(   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: 2932

(   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: 2952

(   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: 2972

(   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: 2992

(   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: 3013

(   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: 3035

(   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: 3055

(   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: 3075

(   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: 3095

(   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: 3153

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

Line: 3189

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

Line: 3191

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

Line: 3287

    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: 3296

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

Line: 4886

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

Line: 4949

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

Line: 5345

    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: 5378

(   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: 5398

(   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: 5417

(   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: 5436

(   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: 5457

(   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: 5478

(   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: 5540

(   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: 5558

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