APPS.MTL_BILLING_LINES_PKG SQL Statements

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

Line: 4

  procedure INSERT_ROW(
       x_billing_rule_line_id IN NUMBER ,
       x_billing_rule_header_id IN NUMBER ,
       x_client_code IN VARCHAR2 ,
       x_client_number IN VARCHAR2 ,
       x_service_agreement_line_id IN NUMBER ,
       x_inventory_item_id IN NUMBER ,
       x_billing_source_id IN NUMBER ,
       x_creation_date IN DATE ,
       x_created_by IN NUMBER,
       x_last_update_date IN DATE,
       x_last_updated_by IN NUMBER ,
       x_last_update_login IN NUMBER
  ) AS

  BEGIN

         INSERT INTO mtl_billing_rule_lines
          (   billing_rule_line_id,
              billing_rule_header_id ,
              client_code ,
              client_number  ,
              service_agreement_line_id ,
              inventory_item_id,
              billing_source_id ,
              creation_date ,
              created_by ,
              last_update_date ,
              last_updated_by ,
              last_update_login
          )
          VALUES
          (  x_billing_rule_line_id,
              x_billing_rule_header_id ,
              x_client_code ,
              x_client_number  ,
              x_service_agreement_line_id ,
              x_inventory_item_id ,
              x_billing_source_id ,
              x_last_update_date , -- x_creation_date ,
              x_last_updated_by ,--x_created_by ,
              x_last_update_date ,
              x_last_updated_by ,
              x_last_update_login
          );

Line: 52

  END INSERT_ROW;

Line: 54

procedure UPDATE_ROW(
       x_billing_rule_line_id IN NUMBER ,
       x_billing_rule_header_id IN NUMBER ,
       x_client_code IN VARCHAR2 ,
       x_client_number IN VARCHAR2 ,
       x_service_agreement_line_id IN NUMBER ,
       x_inventory_item_id IN NUMBER ,
       x_billing_source_id IN NUMBER ,
       x_creation_date IN DATE ,
       x_created_by IN NUMBER,
       x_last_update_date IN DATE,
       x_last_updated_by IN NUMBER ,
       x_last_update_login IN NUMBER

  ) AS

  l_billing_rule_line_id NUMBER;

Line: 78

       INSERT INTO mtl_billing_rule_lines
          (   billing_rule_line_id,
              billing_rule_header_id ,
              client_code ,
              client_number  ,
              service_agreement_line_id ,
              inventory_item_id,
              billing_source_id ,
              creation_date ,
              created_by ,
              last_update_date ,
              last_updated_by ,
              last_update_login
          )
          VALUES
          (   x_billing_rule_line_id,
              x_billing_rule_header_id ,
              x_client_code ,
              x_client_number  ,
              x_service_agreement_line_id ,
              x_inventory_item_id,
              x_billing_source_id,
              x_last_update_date, -- x_creation_date ,
              x_last_updated_by, --x_created_by ,
              x_last_update_date ,
              x_last_updated_by ,
              x_last_update_login
          );

Line: 112

  update mtl_billing_rule_lines set
             billing_rule_header_id = x_billing_rule_header_id,
             client_code = x_client_code,
             client_number = x_client_number,
             service_agreement_line_id = x_service_agreement_line_id,
             billing_source_id = x_billing_source_id,
             last_update_date = x_last_update_date,
             last_updated_by = x_last_updated_by,
             last_update_login = x_last_update_login
    where billing_rule_line_id = x_billing_rule_line_id;

Line: 128

END UPDATE_ROW;

Line: 131

procedure DELETE_ROW (
  x_billing_rule_line_id in NUMBER
) is
BEGIN

  delete from mtl_billing_rule_lines
  where billing_rule_line_id = x_billing_rule_line_id;

Line: 143

end DELETE_ROW;

Line: 156

       x_last_update_date IN DATE,
       x_last_updated_by IN NUMBER ,
       x_last_update_login IN NUMBER
  ) AS

   l_billing_rule_line_id NUMBER;

Line: 163

  cursor c is SELECT
              billing_rule_line_id,
              billing_rule_header_id ,
              client_code ,
              client_number  ,
              service_agreement_line_id ,
              inventory_item_id,
              billing_source_id  ,
              creation_date ,
              created_by ,
              last_update_date ,
              last_updated_by ,
              last_update_login
    from mtl_billing_rule_lines
    where billing_rule_line_id = x_billing_rule_line_id
    for update of billing_rule_line_id nowait;

Line: 192

        fnd_message.set_name('FND', 'FORM_RECORD_DELETED');