eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_GLOBAL_UPDATE_PKG SQL Statements

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

Line: 7


g_module_prefix CONSTANT VARCHAR2(40) := 'pon.plsql.pon_global_update_pkg.';

Line: 9


PROCEDURE GLOBAL_LINE_UPDATE
(
p_auction_header_id IN NUMBER,
p_src_line_number       IN NUMBER ,
p_dest_line_ids_tbl IN PO_TBL_NUMBER,
p_option_from_date IN DATE,
p_option_to_date IN DATE,
p_clm_need_by_date IN DATE,
p_pop_start_date IN DATE,
p_pop_end_date IN DATE,
p_ship_to_loc_id IN NUMBER,
p_note_to_suppliers IN VARCHAR2 ,
x_result OUT NOCOPY VARCHAR2
)

IS

l_module VARCHAR2(100) := 'GLOBAL_LINE_UPDATE';

Line: 43


  SAVEPOINT global_update;

Line: 50


    UPDATE pon_auction_item_prices_all
    SET
    clm_option_from_date = Decode(clm_option_indicator,'O',Nvl(p_option_from_date,clm_option_from_date),NULL),
    clm_option_to_date = Decode(clm_option_indicator,'O',Nvl(p_option_to_date,clm_option_to_date),NULL),
    note_to_bidders = Nvl(p_note_to_suppliers,note_to_bidders),
	  last_update_date  = SYSDATE,
    last_updated_by = fnd_global.user_id,
    last_update_login = fnd_global.login_id
    WHERE auction_header_id = p_auction_header_id
    AND line_Number in (select column_value from table(p_dest_line_ids_tbl));

Line: 62


    UPDATE pon_auction_item_prices_all
    SET
    ship_to_location_id = Decode(Nvl(clm_info_flag,'N'),'N',
                              Nvl(p_ship_to_loc_id,ship_to_location_id),NULL)
    WHERE auction_header_id = p_auction_header_id
    AND line_Number in (select column_value from table(p_dest_line_ids_tbl))
    AND Nvl(LINE_ORIGINATION_CODE,'NO') <> 'REQUISITION';

Line: 74


    * This condition is enforced in Global update process
    * as below
    */
    IF p_clm_need_by_date IS NOT NULL THEN
      UPDATE pon_auction_item_prices_all
      SET
      clm_need_by_date = Decode(Nvl(clm_info_flag,'N'),'N', p_clm_need_by_date,NULL),
      need_by_start_date = NULL,
      need_by_date = NULL
      WHERE auction_header_id = p_auction_header_id
      AND line_Number in (select column_value from table(p_dest_line_ids_tbl));

Line: 86


      UPDATE pon_auction_item_prices_all paip
      SET
      need_by_start_date =Decode(Nvl(clm_info_flag,'N'),'N', p_pop_start_date,NULL),
      need_by_date = Decode(Nvl(clm_info_flag,'N'),'N', p_pop_end_date,NULL),
      clm_need_by_date = NULL
      WHERE auction_header_id = p_auction_header_id
      AND line_Number in (select column_value from table(p_dest_line_ids_tbl))
      AND NOT EXISTS -- clm_need_by_date is mandatory for planned items
      (SELECT 'x'
        FROM   mtl_system_items_kfv msi, financials_system_params_all fsp
        WHERE  nvl(fsp.org_id, -9999) = nvl(paip.org_id,-9999) and
                msi.organization_id = fsp.inventory_organization_id and
        msi.inventory_item_id = paip.item_id and
        (msi.INVENTORY_PLANNING_CODE in (1, 2) or msi.MRP_PLANNING_CODE in
        (3, 4, 7, 8, 9)));

Line: 103


    LOG_MESSAGE(l_module,'Named attributes updated ');

Line: 107


    SELECT
    attr_group_id,
    LINE_NUMBER,
    data_level_id,
    last_update_date,
    last_updated_by,
    last_update_login,
    creation_date,
    created_by,
    pk1_value,
    pk2_value,
    pk3_value,
    pk4_value,
    pk5_value,
    c_ext_attr1,
    c_ext_attr2,
    c_ext_attr3,
    c_ext_attr4,
    c_ext_attr5,
    c_ext_attr6,
    c_ext_attr7,
    c_ext_attr8,
    c_ext_attr9,
    c_ext_attr10,
    c_ext_attr11,
    c_ext_attr12,
    c_ext_attr13,
    c_ext_attr14,
    c_ext_attr15,
    c_ext_attr16,
    c_ext_attr17,
    c_ext_attr18,
    c_ext_attr19,
    c_ext_attr20,
    c_ext_attr21,
    c_ext_attr22,
    c_ext_attr23,
    c_ext_attr24,
    c_ext_attr25,
    c_ext_attr26,
    c_ext_attr27,
    c_ext_attr28,
    c_ext_attr29,
    c_ext_attr30,
    c_ext_attr31,
    c_ext_attr32,
    c_ext_attr33,
    c_ext_attr34,
    c_ext_attr35,
    c_ext_attr36,
    c_ext_attr37,
    c_ext_attr38,
    c_ext_attr39,
    c_ext_attr40,
    n_ext_attr1,
    n_ext_attr2,
    n_ext_attr3,
    n_ext_attr4,
    n_ext_attr5,
    n_ext_attr6,
    n_ext_attr7,
    n_ext_attr8,
    n_ext_attr9,
    n_ext_attr10,
    n_ext_attr11,
    n_ext_attr12,
    n_ext_attr13,
    n_ext_attr14,
    n_ext_attr15,
    n_ext_attr16,
    n_ext_attr17,
    n_ext_attr18,
    n_ext_attr19,
    n_ext_attr20,
    uom_ext_attr1,
    uom_ext_attr2,
    uom_ext_attr3,
    uom_ext_attr4,
    uom_ext_attr5,
    uom_ext_attr6,
    uom_ext_attr7,
    uom_ext_attr8,
    uom_ext_attr9,
    uom_ext_attr10,
    uom_ext_attr11,
    uom_ext_attr12,
    uom_ext_attr13,
    uom_ext_attr14,
    uom_ext_attr15,
    uom_ext_attr16,
    uom_ext_attr17,
    uom_ext_attr18,
    uom_ext_attr19,
    uom_ext_attr20,
    d_ext_attr1,
    d_ext_attr2,
    d_ext_attr3,
    d_ext_attr4,
    d_ext_attr5,
    d_ext_attr6,
    d_ext_attr7,
    d_ext_attr8,
    d_ext_attr9,
    d_ext_attr10,
    uda_template_id,
    auctioN_header_id
    FROM pon_auction_item_prices_ext_b WHERE AUCTION_HEADER_ID =  p_auction_header_id
    and LINE_NUMBER = p_src_line_number) SRCLINE
    ON
    (DESTLINE.LINE_NUMBER IN (select column_value from table(p_dest_line_ids_tbl))  AND DESTLINE.attr_group_id = SRCLINE.attr_group_id AND  SRCLINE.AUCTION_HEADER_ID =  p_auction_header_id )
    WHEN MATCHED THEN
    UPDATE
    SET
    DESTLINE.last_update_date = SYSDATE ,
    DESTLINE.last_updated_by = SRCLINE.last_updated_by,
    DESTLINE.last_update_login = SRCLINE.last_update_login,
    DESTLINE.created_by = SRCLINE.created_by,
    DESTLINE.creation_date = SYSDATE,
    DESTLINE.c_ext_attr1 = nvl(SRCLINE.c_ext_attr1 , DESTLINE.c_ext_attr1),
    DESTLINE.c_ext_attr2 = nvl(SRCLINE.c_ext_attr2 , DESTLINE.c_ext_attr2),
    DESTLINE.c_ext_attr3 = nvl(SRCLINE.c_ext_attr3 , DESTLINE.c_ext_attr3),
    DESTLINE.c_ext_attr4 = nvl(SRCLINE.c_ext_attr4 , DESTLINE.c_ext_attr4),
    DESTLINE.c_ext_attr5 = nvl(SRCLINE.c_ext_attr5 , DESTLINE.c_ext_attr5),
    DESTLINE.c_ext_attr6 = nvl(SRCLINE.c_ext_attr6 , DESTLINE.c_ext_attr6),
    DESTLINE.c_ext_attr7 = nvl(SRCLINE.c_ext_attr7 , DESTLINE.c_ext_attr7),
    DESTLINE.c_ext_attr8 = nvl(SRCLINE.c_ext_attr8 , DESTLINE.c_ext_attr8),
    DESTLINE.c_ext_attr9 = nvl(SRCLINE.c_ext_attr9 , DESTLINE.c_ext_attr9),
    DESTLINE.c_ext_attr10 = nvl(SRCLINE.c_ext_attr10 , DESTLINE.c_ext_attr10),
    DESTLINE.c_ext_attr11 = nvl(SRCLINE.c_ext_attr11 , DESTLINE.c_ext_attr11),
    DESTLINE.c_ext_attr12 = nvl(SRCLINE.c_ext_attr12 , DESTLINE.c_ext_attr12),
    DESTLINE.c_ext_attr13 = nvl(SRCLINE.c_ext_attr13 , DESTLINE.c_ext_attr13),
    DESTLINE.c_ext_attr14 = nvl(SRCLINE.c_ext_attr14 , DESTLINE.c_ext_attr14),
    DESTLINE.c_ext_attr15 = nvl(SRCLINE.c_ext_attr15 , DESTLINE.c_ext_attr15),
    DESTLINE.c_ext_attr16 = nvl(SRCLINE.c_ext_attr16 , DESTLINE.c_ext_attr16),
    DESTLINE.c_ext_attr17 = nvl(SRCLINE.c_ext_attr17 , DESTLINE.c_ext_attr17),
    DESTLINE.c_ext_attr18 = nvl(SRCLINE.c_ext_attr18 , DESTLINE.c_ext_attr18),
    DESTLINE.c_ext_attr19 = nvl(SRCLINE.c_ext_attr19 , DESTLINE.c_ext_attr19),
    DESTLINE.c_ext_attr20 = nvl(SRCLINE.c_ext_attr20 , DESTLINE.c_ext_attr20),
    DESTLINE.c_ext_attr21 = nvl(SRCLINE.c_ext_attr21 , DESTLINE.c_ext_attr21),
    DESTLINE.c_ext_attr22 = nvl(SRCLINE.c_ext_attr22 , DESTLINE.c_ext_attr22),
    DESTLINE.c_ext_attr23 = nvl(SRCLINE.c_ext_attr23 , DESTLINE.c_ext_attr23),
    DESTLINE.c_ext_attr24 = nvl(SRCLINE.c_ext_attr24 , DESTLINE.c_ext_attr24),
    DESTLINE.c_ext_attr25 = nvl(SRCLINE.c_ext_attr25 , DESTLINE.c_ext_attr25),
    DESTLINE.c_ext_attr26 = nvl(SRCLINE.c_ext_attr26 , DESTLINE.c_ext_attr26),
    DESTLINE.c_ext_attr27 = nvl(SRCLINE.c_ext_attr27 , DESTLINE.c_ext_attr27),
    DESTLINE.c_ext_attr28 = nvl(SRCLINE.c_ext_attr28 , DESTLINE.c_ext_attr28),
    DESTLINE.c_ext_attr29 = nvl(SRCLINE.c_ext_attr29 , DESTLINE.c_ext_attr29),
    DESTLINE.c_ext_attr30 = nvl(SRCLINE.c_ext_attr30 , DESTLINE.c_ext_attr30),
    DESTLINE.c_ext_attr31 = nvl(SRCLINE.c_ext_attr31 , DESTLINE.c_ext_attr31),
    DESTLINE.c_ext_attr32 = nvl(SRCLINE.c_ext_attr32 , DESTLINE.c_ext_attr32),
    DESTLINE.c_ext_attr33 = nvl(SRCLINE.c_ext_attr33 , DESTLINE.c_ext_attr33),
    DESTLINE.c_ext_attr34 = nvl(SRCLINE.c_ext_attr34 , DESTLINE.c_ext_attr34),
    DESTLINE.c_ext_attr35 = nvl(SRCLINE.c_ext_attr35 , DESTLINE.c_ext_attr35),
    DESTLINE.c_ext_attr36 = nvl(SRCLINE.c_ext_attr36 , DESTLINE.c_ext_attr36),
    DESTLINE.c_ext_attr37 = nvl(SRCLINE.c_ext_attr37 , DESTLINE.c_ext_attr37),
    DESTLINE.c_ext_attr38 = nvl(SRCLINE.c_ext_attr38 , DESTLINE.c_ext_attr38),
    DESTLINE.c_ext_attr39 = nvl(SRCLINE.c_ext_attr39 , DESTLINE.c_ext_attr39),
    DESTLINE.c_ext_attr40 = nvl(SRCLINE.c_ext_attr40 , DESTLINE.c_ext_attr40),
    DESTLINE.n_ext_attr1 = nvl(SRCLINE.n_ext_attr1 , DESTLINE.n_ext_attr1),
    DESTLINE.n_ext_attr2 = nvl(SRCLINE.n_ext_attr2 , DESTLINE.n_ext_attr2),
    DESTLINE.n_ext_attr3 = nvl(SRCLINE.n_ext_attr3 , DESTLINE.n_ext_attr3),
    DESTLINE.n_ext_attr4 = nvl(SRCLINE.n_ext_attr4 , DESTLINE.n_ext_attr4),
    DESTLINE.n_ext_attr5 = nvl(SRCLINE.n_ext_attr5 , DESTLINE.n_ext_attr5),
    DESTLINE.n_ext_attr6 = nvl(SRCLINE.n_ext_attr6 , DESTLINE.n_ext_attr6),
    DESTLINE.n_ext_attr7 = nvl(SRCLINE.n_ext_attr7 , DESTLINE.n_ext_attr7),
    DESTLINE.n_ext_attr8 = nvl(SRCLINE.n_ext_attr8 , DESTLINE.n_ext_attr8),
    DESTLINE.n_ext_attr9 = nvl(SRCLINE.n_ext_attr9 , DESTLINE.n_ext_attr9),
    DESTLINE.n_ext_attr10 = nvl(SRCLINE.n_ext_attr10 , DESTLINE.n_ext_attr10),
    DESTLINE.n_ext_attr11 = nvl(SRCLINE.n_ext_attr11 , DESTLINE.n_ext_attr11),
    DESTLINE.n_ext_attr12 = nvl(SRCLINE.n_ext_attr12 , DESTLINE.n_ext_attr12),
    DESTLINE.n_ext_attr13 = nvl(SRCLINE.n_ext_attr13 , DESTLINE.n_ext_attr13),
    DESTLINE.n_ext_attr14 = nvl(SRCLINE.n_ext_attr14 , DESTLINE.n_ext_attr14),
    DESTLINE.n_ext_attr15 = nvl(SRCLINE.n_ext_attr15 , DESTLINE.n_ext_attr15),
    DESTLINE.n_ext_attr16 = nvl(SRCLINE.n_ext_attr16 , DESTLINE.n_ext_attr16),
    DESTLINE.n_ext_attr17 = nvl(SRCLINE.n_ext_attr17 , DESTLINE.n_ext_attr17),
    DESTLINE.n_ext_attr18 = nvl(SRCLINE.n_ext_attr18 , DESTLINE.n_ext_attr18),
    DESTLINE.n_ext_attr19 = nvl(SRCLINE.n_ext_attr19 , DESTLINE.n_ext_attr19),
    DESTLINE.n_ext_attr20 = nvl(SRCLINE.n_ext_attr20 , DESTLINE.n_ext_attr20),
    DESTLINE.uom_ext_attr1 = nvl(SRCLINE.uom_ext_attr1 , DESTLINE.uom_ext_attr1),
    DESTLINE.uom_ext_attr2 = nvl(SRCLINE.uom_ext_attr2 , DESTLINE.uom_ext_attr2),
    DESTLINE.uom_ext_attr3 = nvl(SRCLINE.uom_ext_attr3 , DESTLINE.uom_ext_attr3),
    DESTLINE.uom_ext_attr4 = nvl(SRCLINE.uom_ext_attr4 , DESTLINE.uom_ext_attr4),
    DESTLINE.uom_ext_attr5 = nvl(SRCLINE.uom_ext_attr5 , DESTLINE.uom_ext_attr5),
    DESTLINE.uom_ext_attr6 = nvl(SRCLINE.uom_ext_attr6 , DESTLINE.uom_ext_attr6),
    DESTLINE.uom_ext_attr7 = nvl(SRCLINE.uom_ext_attr7 , DESTLINE.uom_ext_attr7),
    DESTLINE.uom_ext_attr8 = nvl(SRCLINE.uom_ext_attr8 , DESTLINE.uom_ext_attr8),
    DESTLINE.uom_ext_attr9 = nvl(SRCLINE.uom_ext_attr9 , DESTLINE.uom_ext_attr9),
    DESTLINE.uom_ext_attr10 = nvl(SRCLINE.uom_ext_attr10 , DESTLINE.uom_ext_attr10),
    DESTLINE.uom_ext_attr11 = nvl(SRCLINE.uom_ext_attr11 , DESTLINE.uom_ext_attr11),
    DESTLINE.uom_ext_attr12 = nvl(SRCLINE.uom_ext_attr12 , DESTLINE.uom_ext_attr12),
    DESTLINE.uom_ext_attr13 = nvl(SRCLINE.uom_ext_attr13 , DESTLINE.uom_ext_attr13),
    DESTLINE.uom_ext_attr14 = nvl(SRCLINE.uom_ext_attr14 , DESTLINE.uom_ext_attr14),
    DESTLINE.uom_ext_attr15 = nvl(SRCLINE.uom_ext_attr15 , DESTLINE.uom_ext_attr15),
    DESTLINE.uom_ext_attr16 = nvl(SRCLINE.uom_ext_attr16 , DESTLINE.uom_ext_attr16),
    DESTLINE.uom_ext_attr17 = nvl(SRCLINE.uom_ext_attr17 , DESTLINE.uom_ext_attr17),
    DESTLINE.uom_ext_attr18 = nvl(SRCLINE.uom_ext_attr18 , DESTLINE.uom_ext_attr18),
    DESTLINE.uom_ext_attr19 = nvl(SRCLINE.uom_ext_attr19 , DESTLINE.uom_ext_attr19),
    DESTLINE.uom_ext_attr20 = nvl(SRCLINE.uom_ext_attr20 , DESTLINE.uom_ext_attr20),
    DESTLINE.d_ext_attr1 = nvl(SRCLINE.d_ext_attr1 , DESTLINE.d_ext_attr1),
    DESTLINE.d_ext_attr2 = nvl(SRCLINE.d_ext_attr2 , DESTLINE.d_ext_attr2),
    DESTLINE.d_ext_attr3 = nvl(SRCLINE.d_ext_attr3 , DESTLINE.d_ext_attr3),
    DESTLINE.d_ext_attr4 = nvl(SRCLINE.d_ext_attr4 , DESTLINE.d_ext_attr4),
    DESTLINE.d_ext_attr5 = nvl(SRCLINE.d_ext_attr5 , DESTLINE.d_ext_attr5),
    DESTLINE.d_ext_attr6 = nvl(SRCLINE.d_ext_attr6 , DESTLINE.d_ext_attr6),
    DESTLINE.d_ext_attr7 = nvl(SRCLINE.d_ext_attr7 , DESTLINE.d_ext_attr7),
    DESTLINE.d_ext_attr8 = nvl(SRCLINE.d_ext_attr8 , DESTLINE.d_ext_attr8),
    DESTLINE.d_ext_attr9 = nvl(SRCLINE.d_ext_attr9 , DESTLINE.d_ext_attr9),
    DESTLINE.d_ext_attr10 = nvl(SRCLINE.d_ext_attr10 , DESTLINE.d_ext_attr10) ;

Line: 320


    INSERT INTO pon_auction_item_prices_ext_b DESTlINE
    (DESTLINE.extension_id,
    DESTLINE.attr_group_id,
    DESTLINE.LINE_NUMBER,
    DESTLINE.data_level_id,
    DESTLINE.pk1_value,
    DESTLINE.pk2_value,
    DESTLINE.pk3_value,
    DESTLINE.pk4_value,
    DESTLINE.pk5_value,
    DESTLINE.last_update_date,
    DESTLINE.last_updated_by,
    DESTLINE.last_update_login,
    DESTLINE.created_by,
    DESTLINE.creation_date,
    DESTLINE.c_ext_attr1,
    DESTLINE.c_ext_attr2,
    DESTLINE.c_ext_attr3,
    DESTLINE.c_ext_attr4,
    DESTLINE.c_ext_attr5,
    DESTLINE.c_ext_attr6,
    DESTLINE.c_ext_attr7,
    DESTLINE.c_ext_attr8,
    DESTLINE.c_ext_attr9,
    DESTLINE.c_ext_attr10,
    DESTLINE.c_ext_attr11,
    DESTLINE.c_ext_attr12,
    DESTLINE.c_ext_attr13,
    DESTLINE.c_ext_attr14,
    DESTLINE.c_ext_attr15,
    DESTLINE.c_ext_attr16,
    DESTLINE.c_ext_attr17,
    DESTLINE.c_ext_attr18,
    DESTLINE.c_ext_attr19,
    DESTLINE.c_ext_attr20,
    DESTLINE.c_ext_attr21,
    DESTLINE.c_ext_attr22,
    DESTLINE.c_ext_attr23,
    DESTLINE.c_ext_attr24,
    DESTLINE.c_ext_attr25,
    DESTLINE.c_ext_attr26,
    DESTLINE.c_ext_attr27,
    DESTLINE.c_ext_attr28,
    DESTLINE.c_ext_attr29,
    DESTLINE.c_ext_attr30,
    DESTLINE.c_ext_attr31,
    DESTLINE.c_ext_attr32,
    DESTLINE.c_ext_attr33,
    DESTLINE.c_ext_attr34,
    DESTLINE.c_ext_attr35,
    DESTLINE.c_ext_attr36,
    DESTLINE.c_ext_attr37,
    DESTLINE.c_ext_attr38,
    DESTLINE.c_ext_attr39,
    DESTLINE.c_ext_attr40,
    DESTLINE.n_ext_attr1,
    DESTLINE.n_ext_attr2,
    DESTLINE.n_ext_attr3,
    DESTLINE.n_ext_attr4,
    DESTLINE.n_ext_attr5,
    DESTLINE.n_ext_attr6,
    DESTLINE.n_ext_attr7,
    DESTLINE.n_ext_attr8,
    DESTLINE.n_ext_attr9,
    DESTLINE.n_ext_attr10,
    DESTLINE.n_ext_attr11,
    DESTLINE.n_ext_attr12,
    DESTLINE.n_ext_attr13,
    DESTLINE.n_ext_attr14,
    DESTLINE.n_ext_attr15,
    DESTLINE.n_ext_attr16,
    DESTLINE.n_ext_attr17,
    DESTLINE.n_ext_attr18,
    DESTLINE.n_ext_attr19,
    DESTLINE.n_ext_attr20,
    DESTLINE.uom_ext_attr1,
    DESTLINE.uom_ext_attr2,
    DESTLINE.uom_ext_attr3,
    DESTLINE.uom_ext_attr4,
    DESTLINE.uom_ext_attr5,
    DESTLINE.uom_ext_attr6,
    DESTLINE.uom_ext_attr7,
    DESTLINE.uom_ext_attr8,
    DESTLINE.uom_ext_attr9,
    DESTLINE.uom_ext_attr10,
    DESTLINE.uom_ext_attr11,
    DESTLINE.uom_ext_attr12,
    DESTLINE.uom_ext_attr13,
    DESTLINE.uom_ext_attr14,
    DESTLINE.uom_ext_attr15,
    DESTLINE.uom_ext_attr16,
    DESTLINE.uom_ext_attr17,
    DESTLINE.uom_ext_attr18,
    DESTLINE.uom_ext_attr19,
    DESTLINE.uom_ext_attr20,
    DESTLINE.d_ext_attr1,
    DESTLINE.d_ext_attr2,
    DESTLINE.d_ext_attr3,
    DESTLINE.d_ext_attr4,
    DESTLINE.d_ext_attr5,
    DESTLINE.d_ext_attr6,
    DESTLINE.d_ext_attr7,
    DESTLINE.d_ext_attr8,
    DESTLINE.d_ext_attr9,
    DESTLINE.d_ext_attr10,
    DESTLINE.uda_template_id,
    DESTLINE.auctioN_header_id)
    SELECT
    EGO_EXTFWK_S.NEXTVAL,
    SRCLINE.attr_group_id,
    p_dest_line_ids_tbl(i),
    SRCLINE.data_level_id,
    SRCLINE.pk1_value,
    SRCLINE.pk2_value,
    SRCLINE.pk3_value,
    SRCLINE.pk4_value,
    SRCLINE.pk5_value,
    SRCLINE.last_update_date,
    SRCLINE.last_updated_by,
    SRCLINE.last_update_login,
    SRCLINE.created_by,
    SRCLINE.creation_date,
    SRCLINE.c_ext_attr1,
    SRCLINE.c_ext_attr2,
    SRCLINE.c_ext_attr3,
    SRCLINE.c_ext_attr4,
    SRCLINE.c_ext_attr5,
    SRCLINE.c_ext_attr6,
    SRCLINE.c_ext_attr7,
    SRCLINE.c_ext_attr8,
    SRCLINE.c_ext_attr9,
    SRCLINE.c_ext_attr10,
    SRCLINE.c_ext_attr11,
    SRCLINE.c_ext_attr12,
    SRCLINE.c_ext_attr13,
    SRCLINE.c_ext_attr14,
    SRCLINE.c_ext_attr15,
    SRCLINE.c_ext_attr16,
    SRCLINE.c_ext_attr17,
    SRCLINE.c_ext_attr18,
    SRCLINE.c_ext_attr19,
    SRCLINE.c_ext_attr20,
    SRCLINE.c_ext_attr21,
    SRCLINE.c_ext_attr22,
    SRCLINE.c_ext_attr23,
    SRCLINE.c_ext_attr24,
    SRCLINE.c_ext_attr25,
    SRCLINE.c_ext_attr26,
    SRCLINE.c_ext_attr27,
    SRCLINE.c_ext_attr28,
    SRCLINE.c_ext_attr29,
    SRCLINE.c_ext_attr30,
    SRCLINE.c_ext_attr31,
    SRCLINE.c_ext_attr32,
    SRCLINE.c_ext_attr33,
    SRCLINE.c_ext_attr34,
    SRCLINE.c_ext_attr35,
    SRCLINE.c_ext_attr36,
    SRCLINE.c_ext_attr37,
    SRCLINE.c_ext_attr38,
    SRCLINE.c_ext_attr39,
    SRCLINE.c_ext_attr40,
    SRCLINE.n_ext_attr1,
    SRCLINE.n_ext_attr2,
    SRCLINE.n_ext_attr3,
    SRCLINE.n_ext_attr4,
    SRCLINE.n_ext_attr5,
    SRCLINE.n_ext_attr6,
    SRCLINE.n_ext_attr7,
    SRCLINE.n_ext_attr8,
    SRCLINE.n_ext_attr9,
    SRCLINE.n_ext_attr10,
    SRCLINE.n_ext_attr11,
    SRCLINE.n_ext_attr12,
    SRCLINE.n_ext_attr13,
    SRCLINE.n_ext_attr14,
    SRCLINE.n_ext_attr15,
    SRCLINE.n_ext_attr16,
    SRCLINE.n_ext_attr17,
    SRCLINE.n_ext_attr18,
    SRCLINE.n_ext_attr19,
    SRCLINE.n_ext_attr20,
    SRCLINE.uom_ext_attr1,
    SRCLINE.uom_ext_attr2,
    SRCLINE.uom_ext_attr3,
    SRCLINE.uom_ext_attr4,
    SRCLINE.uom_ext_attr5,
    SRCLINE.uom_ext_attr6,
    SRCLINE.uom_ext_attr7,
    SRCLINE.uom_ext_attr8,
    SRCLINE.uom_ext_attr9,
    SRCLINE.uom_ext_attr10,
    SRCLINE.uom_ext_attr11,
    SRCLINE.uom_ext_attr12,
    SRCLINE.uom_ext_attr13,
    SRCLINE.uom_ext_attr14,
    SRCLINE.uom_ext_attr15,
    SRCLINE.uom_ext_attr16,
    SRCLINE.uom_ext_attr17,
    SRCLINE.uom_ext_attr18,
    SRCLINE.uom_ext_attr19,
    SRCLINE.uom_ext_attr20,
    SRCLINE.d_ext_attr1,
    SRCLINE.d_ext_attr2,
    SRCLINE.d_ext_attr3,
    SRCLINE.d_ext_attr4,
    SRCLINE.d_ext_attr5,
    SRCLINE.d_ext_attr6,
    SRCLINE.d_ext_attr7,
    SRCLINE.d_ext_attr8,
    SRCLINE.d_ext_attr9,
    SRCLINE.d_ext_attr10,
    SRCLINE.uda_template_id,
    SRCLINE.auction_header_id
  FROM pon_auction_item_prices_ext_b SRCLINE WHERE SRCLINE.LINE_NUMBER = p_src_line_number
  AND auction_header_id = p_auction_header_id
  AND NOT EXISTS (SELECT 1 FROM  pon_auction_item_prices_ext_b   pleb WHERE
                 pleb.line_Number =p_dest_line_ids_tbl(i) AND
                 pleb.attr_group_id = SRCLINE.attr_group_id AND
                 pleb.auction_header_id = SRCLINE.auction_header_id);

Line: 542


  LOG_MESSAGE(l_module,'Insert statement executed ');

Line: 544


  SELECT  extension_id,attr_group_id,line_number,data_level_id,uda_template_id
  BULK COLLECT INTO  extension_id_tbl,attr_group_id_tbl,sol_line_num_tbl,
  data_level_id_tbl,uda_template_id_tbl
    FROM pon_auction_item_prices_ext_b
    WHERE line_Number IN ( select column_value from table(p_dest_line_ids_tbl))
     AND auction_header_id = p_auction_header_id;

Line: 551


   LOG_MESSAGE(l_module,'About to insert into pon_auction_item_prices_ext_tl ');

Line: 554


   INSERT INTO pon_auction_item_prices_ext_tl
   (
      EXTENSION_ID,
      ATTR_GROUP_ID,
      line_number,
      DATA_LEVEL_ID,
      SOURCE_LANG,
      LANGUAGE,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      CREATION_DATE,
      UDA_TEMPLATE_ID,
      AUCTION_HEADER_ID
   )
   SELECT

      extension_id_tbl(i),
      attr_group_id_tbl(i),
      sol_line_num_tbl(i),
      data_level_id_tbl(i),
      USERENV('LANG'),
      L.LANGUAGE_CODE,
      SYSDATE,
      0,
      0,
      0,
      SYSDATE,
      uda_template_id_tbl(i),
      p_auction_header_id

   FROM FND_LANGUAGES L
   WHERE L.INSTALLED_FLAG in ('I', 'B')
   AND NOT EXISTS
   (SELECT 1 FROM pon_auction_item_prices_ext_tl pltl WHERE
    pltl.extension_id = extension_id_tbl(i)
    AND pltl.LANGUAGE = L.LANGUAGE_CODE);

Line: 593


    LOG_MESSAGE(l_module,'Inserted into pon_auction_item_prices_ext_tl ');

Line: 595


  DELETE FROM pon_auction_item_prices_ext_b  WHERE line_Number = p_src_line_number
  AND auction_header_id = p_auction_header_id;

Line: 598


  LOG_MESSAGE(l_module,'Deleted temporary record from pon_auction_item_prices_ext_b');

Line: 603


     ROLLBACK TO global_update;

Line: 606


END  global_line_update;