APPS.OE_GENESIS_UTIL SQL Statements

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

Line: 10

    SELECT  order_source_id
    FROM  oe_order_sources
    WHERE aia_enabled_flag = 'Y';

Line: 52

        SELECT  organization_name
          INTO    l_inventory_org
        FROM    org_organization_definitions
        WHERE   organization_id = p_inventory_org_id;

Line: 77

    SELECT  flow_status_code, object_level, sync_reqd_flag
      FROM    oe_flow_status_aia_sync
      WHERE   sync_reqd_flag  = 'Y'
    ;

Line: 245

  x_hdr_rec25.LAST_UPDATED_BY:= p_header_rec.LAST_UPDATED_BY;

Line: 246

  x_hdr_rec25.LAST_UPDATE_DATE:= p_header_rec.LAST_UPDATE_DATE;

Line: 247

  x_hdr_rec25.LAST_UPDATE_LOGIN:= p_header_rec.LAST_UPDATE_LOGIN;

Line: 265

  x_hdr_rec25.PROGRAM_UPDATE_DATE:= p_header_rec.PROGRAM_UPDATE_DATE;

Line: 476

  x_line_rec25.AUTO_SELECTED_QUANTITY := p_line_rec.AUTO_SELECTED_QUANTITY ;

Line: 593

  x_line_rec25.LAST_UPDATED_BY := p_line_rec.LAST_UPDATED_BY ;

Line: 594

  x_line_rec25.LAST_UPDATE_DATE := p_line_rec.LAST_UPDATE_DATE ;

Line: 595

  x_line_rec25.LAST_UPDATE_LOGIN := p_line_rec.LAST_UPDATE_LOGIN ;

Line: 654

  x_line_rec25.PROGRAM_UPDATE_DATE := p_line_rec.PROGRAM_UPDATE_DATE ;

Line: 1176

    x_hdr_ack_rec25.PROGRAM_UPDATE_DATE := p_hdr_ack_rec.PROGRAM_UPDATE_DATE ;

Line: 1205

    x_hdr_ack_rec25.LAST_UPDATE_DATE := p_hdr_ack_rec.LAST_UPDATE_DATE ;

Line: 1206

    x_hdr_ack_rec25.LAST_UPDATE_LOGIN := p_hdr_ack_rec.LAST_UPDATE_LOGIN ;

Line: 1207

    x_hdr_ack_rec25.LAST_UPDATED_BY := p_hdr_ack_rec.LAST_UPDATED_BY ;

Line: 1490

    x_line_ack_rec25.AUTO_SELECTED_QUANTITY := p_line_ack_rec.AUTO_SELECTED_QUANTITY ;

Line: 1684

    x_line_ack_rec25.PROGRAM_UPDATE_DATE := p_line_ack_rec.PROGRAM_UPDATE_DATE ;

Line: 1838

    x_line_ack_rec25.LAST_UPDATE_DATE := p_line_ack_rec.LAST_UPDATE_DATE ;

Line: 1839

    x_line_ack_rec25.LAST_UPDATE_LOGIN := p_line_ack_rec.LAST_UPDATE_LOGIN ;

Line: 1840

    x_line_ack_rec25.LAST_UPDATED_BY := p_line_ack_rec.LAST_UPDATED_BY ;

Line: 2240

    IF p_x_header_rec.last_updated_by IS NULL THEN
        p_x_header_rec.last_updated_by :=  FND_API.G_MISS_NUM;

Line: 2244

    IF p_x_header_rec.last_update_date IS NULL THEN
        p_x_header_rec.last_update_date := FND_API.G_MISS_DATE;

Line: 2248

    IF p_x_header_rec.last_update_login IS NULL THEN
        p_x_header_rec.last_update_login :=  FND_API.G_MISS_NUM;

Line: 2324

    IF p_x_header_rec.program_update_date IS NULL THEN
        p_x_header_rec.program_update_date := FND_API.G_MISS_DATE;

Line: 2686

    IF p_x_Header_Payment_rec.last_updated_by IS NULL THEN
        p_x_Header_Payment_rec.last_updated_by :=  FND_API.G_MISS_NUM;

Line: 2690

    IF p_x_Header_Payment_rec.last_update_date IS NULL THEN
        p_x_Header_Payment_rec.last_update_date := FND_API.G_MISS_DATE;

Line: 2694

    IF p_x_Header_Payment_rec.last_update_login IS NULL THEN
        p_x_Header_Payment_rec.last_update_login :=  FND_API.G_MISS_NUM;

Line: 2786

    IF p_x_Header_Payment_rec.program_update_date IS NULL THEN
        p_x_Header_Payment_rec.program_update_date := FND_API.G_MISS_DATE;

Line: 2868

    IF p_x_line_rec.operation = Oe_Globals.G_Opr_Update THEN
      oe_debug_pub.ADD(' cnv line null to miss: Operation is.... UPDATE on line: '
                           || p_x_line_rec.line_id);

Line: 2875

        SELECT  l.arrival_set_id
            INTO  l_old_arrival_set_id
        FROM    oe_order_lines_all l
        WHERE   l.line_id = p_x_line_rec.line_id;

Line: 2899

            SELECT  DISTINCT set_id INTO l_old_arrival_set_id
            FROM    oe_sets
            WHERE   set_type  = 'ARRIVAL_SET'
            AND     header_id = p_x_line_rec.header_id
            AND     set_name  = p_x_line_rec.arrival_set;

Line: 2908

          ELSE -- that is, when p_x_line_rec.arrival_set is null in update mode.
            p_x_line_rec.arrival_set := Fnd_Api.G_Miss_Char;

Line: 2926

    ELSE  -- For entity operations other than UPDATE.
      oe_debug_pub.ADD(' cnv line null to miss: Location 15...');

Line: 2938

    END IF; -- Operation code check for UPDATE.

Line: 2946

    IF p_x_line_rec.operation = Oe_Globals.G_Opr_Update THEN
      DECLARE
        l_old_arrival_set oe_sets.set_name%TYPE := null;

Line: 2951

        SELECT  set_name
        INTO    l_old_arrival_set
        FROM    oe_sets s,
                oe_order_lines_all l
        WHERE   s.set_type  = 'ARRIVAL_SET'
        AND     l.arrival_set_id = s.set_id
        AND     l.line_id = p_x_line_rec.line_id;

Line: 2972

    END IF; -- Additional operation code check for UPDATE.

Line: 3064

    IF p_x_line_rec.auto_selected_quantity IS NULL THEN
        p_x_line_rec.auto_selected_quantity :=  FND_API.G_MISS_NUM;

Line: 3532

    IF p_x_line_rec.last_updated_by IS NULL THEN
        p_x_line_rec.last_updated_by :=  FND_API.G_MISS_NUM;

Line: 3536

    IF p_x_line_rec.last_update_date IS NULL THEN
        p_x_line_rec.last_update_date := FND_API.G_MISS_DATE;

Line: 3540

    IF p_x_line_rec.last_update_login IS NULL THEN
        p_x_line_rec.last_update_login :=  FND_API.G_MISS_NUM;

Line: 3727

    IF p_x_line_rec.program_update_date IS NULL THEN
        p_x_line_rec.program_update_date := FND_API.G_MISS_DATE;

Line: 3909

    IF p_x_line_rec.operation = Oe_Globals.G_Opr_Update THEN
      oe_debug_pub.ADD(' cnv line null to miss: Operation is.... UPDATE on line: '
                           || p_x_line_rec.line_id);

Line: 3916

        SELECT  l.ship_set_id
            INTO  l_old_ship_set_id
        FROM    oe_order_lines_all l
        WHERE   l.line_id = p_x_line_rec.line_id;

Line: 3938

            SELECT  DISTINCT set_id INTO l_old_ship_set_id
            FROM    oe_sets
            WHERE   set_type  = 'SHIP_SET'
            AND     header_id = p_x_line_rec.header_id
            AND     set_name  = p_x_line_rec.ship_set;

Line: 3964

    ELSE  -- For entity operations other than UPDATE.
      oe_debug_pub.ADD(' cnv line null to miss: Location 5...');

Line: 3974

    END IF; -- Operation code check for UPDATE.

Line: 3983

    IF p_x_line_rec.operation = Oe_Globals.G_Opr_Update THEN
      DECLARE
        l_old_ship_set oe_sets.set_name%TYPE := null;

Line: 3988

        SELECT  set_name
        INTO    l_old_ship_set
        FROM    oe_sets s,
                oe_order_lines_all l
        WHERE   s.set_type  = 'SHIP_SET'
        AND     l.ship_set_id = s.set_id
        AND     l.line_id = p_x_line_rec.line_id;

Line: 4009

    END IF; -- Additional operation code check for UPDATE.