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.CS_CONTINTF_PVT SQL Statements

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

Line: 5


      SELECT CS_CONT_BILL_IFACE_S.nextval FROM SYS.DUAL;

Line: 151


  PROCEDURE insert_row
  (
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    p_validation_level             IN NUMBER,
    p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    x_return_status                OUT VARCHAR2,
    x_msg_count                    OUT NUMBER,
    x_msg_data                     OUT VARCHAR2,
    p_contintf_rec                 IN ContIntf_Rec_Type := G_MISS_CONTINTF_REC,
    x_contracts_interface_id       OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 217


    INSERT INTO CS_CONT_BILL_IFACE(
        contracts_interface_id,
        cp_service_transaction_id,
        cp_service_id,
        contract_id,
        ar_trx_type,
        trx_start_date,
        trx_end_date,
        trx_date,
        trx_amount,
        reason_code,
        reason_comments,
        contract_billing_id,
        cp_quantity,
        concurrent_process_id,
        created_by,
        creation_date,
        object_version_number)
      VALUES (
        l_def_contintf_rec.contracts_interface_id,
        l_def_contintf_rec.cp_service_transaction_id,
        l_def_contintf_rec.cp_service_id,
        l_def_contintf_rec.contract_id,
        l_def_contintf_rec.ar_trx_type,
        l_def_contintf_rec.trx_start_date,
        l_def_contintf_rec.trx_end_date,
        l_def_contintf_rec.trx_date,
        l_def_contintf_rec.trx_amount,
        l_def_contintf_rec.reason_code,
        l_def_contintf_rec.reason_comments,
        l_def_contintf_rec.contract_billing_id,
        l_def_contintf_rec.cp_quantity,
        l_def_contintf_rec.concurrent_process_id,
        l_def_contintf_rec.created_by,
        l_def_contintf_rec.creation_date,
        l_def_contintf_rec.object_version_number);

Line: 291


  END insert_row;

Line: 292


  PROCEDURE insert_row
  (
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    p_validation_level             IN NUMBER,
    p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    x_return_status                OUT VARCHAR2,
    x_msg_count                    OUT NUMBER,
    x_msg_data                     OUT VARCHAR2,
    p_cp_service_transaction_id    IN NUMBER := NULL,
    p_cp_service_id                IN NUMBER := NULL,
    p_contract_id                  IN NUMBER := NULL,
    p_ar_trx_type                  IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := NULL,
    p_trx_start_date               IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := NULL,
    p_trx_end_date                 IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := NULL,
    p_trx_date                     IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := NULL,
    p_trx_amount                   IN NUMBER := NULL,
    p_reason_code                  IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := NULL,
    p_reason_comments              IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := NULL,
    p_contract_billing_id          IN NUMBER := NULL,
    p_cp_quantity                  IN NUMBER := NULL,
    p_concurrent_process_id        IN NUMBER := NULL,
    p_created_by                   IN NUMBER := NULL,
    p_creation_date                IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := NULL,
    p_object_version_number        IN NUMBER := NULL,
    x_contracts_interface_id       OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 352


    insert_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_contintf_rec,
      x_contracts_interface_id,
      x_object_version_number
    );

Line: 399


  END insert_row;

Line: 414


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_CONT_BILL_IFACE
    WHERE
      CONTRACTS_INTERFACE_ID = p_contracts_interface_id AND
      OBJECT_VERSION_NUMBER = p_object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 422


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_CONT_BILL_IFACE
    WHERE
      CONTRACTS_INTERFACE_ID = p_contracts_interface_id
      ;

Line: 468


      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 477


      TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 516


  Procedure update_row
  (
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    p_validation_level             IN NUMBER,
    p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    x_return_status                OUT VARCHAR2,
    x_msg_count                    OUT NUMBER,
    x_msg_data                     OUT VARCHAR2,
    p_contintf_val_rec             IN ContIntf_Val_Rec_Type := G_MISS_CONTINTF_VAL_REC,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_row';

Line: 537


      SELECT *
        FROM Cs_Cont_Bill_Iface
       WHERE cs_cont_bill_iface.contracts_interface_id = p_contracts_interface_id;

Line: 676


    UPDATE  CS_CONT_BILL_IFACE
    SET
        CONTRACTS_INTERFACE_ID = l_def_contintf_rec.contracts_interface_id ,
        CP_SERVICE_TRANSACTION_ID = l_def_contintf_rec.cp_service_transaction_id ,
        CP_SERVICE_ID = l_def_contintf_rec.cp_service_id ,
        CONTRACT_ID = l_def_contintf_rec.contract_id ,
        AR_TRX_TYPE = l_def_contintf_rec.ar_trx_type ,
        TRX_START_DATE = l_def_contintf_rec.trx_start_date ,
        TRX_END_DATE = l_def_contintf_rec.trx_end_date ,
        TRX_DATE = l_def_contintf_rec.trx_date ,
        TRX_AMOUNT = l_def_contintf_rec.trx_amount ,
        REASON_CODE = l_def_contintf_rec.reason_code ,
        REASON_COMMENTS = l_def_contintf_rec.reason_comments ,
        CONTRACT_BILLING_ID = l_def_contintf_rec.contract_billing_id ,
        CP_QUANTITY = l_def_contintf_rec.cp_quantity ,
        CONCURRENT_PROCESS_ID = l_def_contintf_rec.concurrent_process_id ,
        CREATED_BY = l_def_contintf_rec.created_by ,
        CREATION_DATE = l_def_contintf_rec.creation_date ,
        OBJECT_VERSION_NUMBER = l_def_contintf_rec.object_version_number
        WHERE
          CONTRACTS_INTERFACE_ID = l_def_contintf_rec.contracts_interface_id
          ;

Line: 734


  END update_row;

Line: 735


  Procedure update_row
  (
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    p_validation_level             IN NUMBER,
    p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    x_return_status                OUT VARCHAR2,
    x_msg_count                    OUT NUMBER,
    x_msg_data                     OUT VARCHAR2,
    p_contracts_interface_id       IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_cp_service_transaction_id    IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_cp_service_id                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_contract_id                  IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_ar_trx_type                  IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_trx_start_date               IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_trx_end_date                 IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_trx_date                     IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_trx_amount                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_reason_code                  IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_reason_comments              IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_contract_billing_id          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_cp_quantity                  IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_concurrent_process_id        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_created_by                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_creation_date                IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_object_version_number        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_row';

Line: 796


    update_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_contintf_rec,
      x_object_version_number
    );

Line: 842


  END update_row;

Line: 843


  Procedure delete_row
  (
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    p_validation_level             IN NUMBER,
    p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    x_return_status                OUT VARCHAR2,
    x_msg_count                    OUT NUMBER,
    x_msg_data                     OUT VARCHAR2,
    p_contracts_interface_id       IN NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_row';

Line: 869


    DELETE  FROM CS_CONT_BILL_IFACE
    WHERE
      CONTRACTS_INTERFACE_ID = p_contracts_interface_id
      ;

Line: 908


  END delete_row;