APPS.CSP_CREATE_PARTS_REQ_PKG SQL Statements

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

Line: 45

    , p_last_updated_by  NUMBER
    , p_last_update_date  date
    , p_last_update_login  NUMBER)  RETURN reqmt_hdr_cur AS
    requirement_header_rec csp_requirement_headers_pub.RQH_Rec_Type;

Line: 88

    requirement_header_rec.last_updated_by := fnd_global.user_id; --p_last_updated_by;

Line: 89

    requirement_header_rec.last_update_date := sysdate; ---p_last_update_date;

Line: 90

    requirement_header_rec.last_update_login := fnd_global.conc_login_id; --p_last_update_login;

Line: 101

  select x_requirement_header_id,x_return_status,x_msg_count,x_msg_data from DUAL;

Line: 108

       ,p_last_updated_by number
       ,p_last_update_date date
       ,p_last_update_login number
       ,p_requirement_header_id number
       ,p_inventory_item_id number
       ,p_uom_code varchar2
       ,p_required_quantity number
       ,p_ship_complete_flag varchar2
       ,p_likelihood number
       ,p_revision varchar2
       ,p_source_organization_id number
       ,p_source_subinventory varchar2
       ,p_ordered_quantity number
       ,p_order_line_id number
       ,p_reservation_id number
       ,p_order_by_date date
       ,p_attribute_category varchar2
       ,p_attribute1 varchar2
       ,p_attribute2 varchar2
       ,p_attribute3 varchar2
       ,p_attribute4 varchar2
       ,p_attribute5 varchar2
       ,p_attribute6 varchar2
       ,p_attribute7 varchar2
       ,p_attribute8 varchar2
       ,p_attribute9 varchar2
       ,p_attribute10 varchar2
       ,p_attribute11 varchar2
       ,p_attribute12 varchar2
       ,p_attribute13 varchar2
       ,p_attribute14 varchar2
       ,p_attribute15 varchar2
       ,p_arrival_date date
       ,p_item_scratchpad varchar2
       ,p_shipping_method_code varchar2
       ,p_local_reservation_id number
       ,p_sourced_from VARCHAR2) return reqmt_lines_cur as
     requirement_lines_rec csp_requirement_lines_pub.rql_rec_type;

Line: 158

        reqmt_lines_tbl(1).last_updated_by := fnd_global.user_id; --p_LAST_UpDATED_BY;

Line: 159

        reqmt_lines_tbl(1).last_update_date := sysdate; --p_LAST_UpDATE_DATE;

Line: 160

        reqmt_lines_tbl(1).LAST_UpDATE_LOGIN := fnd_global.conc_login_id; --p_LAST_UpDATE_LOGIN;

Line: 206

  select x_requirement_line_id,x_return_status,x_msg_count,x_msg_data from dual;