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

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

Line: 98


SELECT no_fee_flag,waive_subsidiary_fee_flag
FROM pv_partner_program_b
WHERE program_id = p_prg_id;

Line: 103


SELECT order_header_id
FROM   PV_PG_INVITE_HEADERS_b
WHERE  invite_header_id=p_inv_id;

Line: 108


SELECT attr_value
FROM   pv_enty_attr_values
WHERE  entity='PARTNER'
AND    entity_id=p_ptr_id
AND    attribute_id=6
AND    latest_flag='Y';

Line: 311


      SELECT pv_pg_enrl_requests_s.NEXTVAL
      FROM dual;

Line: 315


      SELECT 1
      FROM PV_PG_ENRL_REQUESTS
      WHERE enrl_request_id = l_id;

Line: 420


      Pv_Pg_Enrl_Requests_Pkg.Insert_Row(
          px_enrl_request_id  => l_enrl_request_id,
          px_object_version_number  => l_object_version_number,
          p_program_id  => p_enrl_request_rec.program_id,
          p_partner_id  => p_enrl_request_rec.partner_id,
          p_custom_setup_id  => l_custom_setup_id,
          p_requestor_resource_id  => p_enrl_request_rec.requestor_resource_id,
          p_request_status_code  => p_enrl_request_rec.request_status_code,
          p_enrollment_type_code  => p_enrl_request_rec.enrollment_type_code,
          p_request_submission_date  => p_enrl_request_rec.request_submission_date,
          p_order_header_id  => l_enrl_request_rec.order_header_id,
          p_contract_id  => p_enrl_request_rec.contract_id,
          p_request_initiated_by_code  => p_enrl_request_rec.request_initiated_by_code,
          p_invite_header_id  => p_enrl_request_rec.invite_header_id,
          p_tentative_start_date  => p_enrl_request_rec.tentative_start_date,
          p_tentative_end_date  => p_enrl_request_rec.tentative_end_date,
          p_contract_status_code  => p_enrl_request_rec.contract_status_code,
          p_payment_status_code  => l_enrl_request_rec.payment_status_code,
          p_score_result_code  => l_score_result_code,
          p_created_by  => Fnd_Global.USER_ID,
          p_creation_date  => SYSDATE,
          p_last_updated_by  => Fnd_Global.USER_ID,
          p_last_update_date  => SYSDATE,
          p_last_update_login  => Fnd_Global.conc_login_id,
          p_membership_fee  => p_enrl_request_rec.membership_fee,
          p_dependent_program_id  => p_enrl_request_rec.dependent_program_id,
          p_trans_curr_code  => p_enrl_request_rec.trans_curr_code,
          p_contract_binding_contact_id  => p_enrl_request_rec.contract_binding_contact_id,
          p_contract_signed_date  => p_enrl_request_rec.contract_signed_date,
          p_trxn_extension_id  => p_enrl_request_rec.trxn_extension_id,
	  p_attribute1 => p_enrl_request_rec.attribute1,
	  p_attribute2 => p_enrl_request_rec.attribute2,
	  p_attribute3 => p_enrl_request_rec.attribute3,
	  p_attribute4 => p_enrl_request_rec.attribute4,
	  p_attribute5 => p_enrl_request_rec.attribute5,
	  p_attribute6 => p_enrl_request_rec.attribute6,
	  p_attribute7 => p_enrl_request_rec.attribute7,
	  p_attribute8 => p_enrl_request_rec.attribute8,
	  p_attribute9 => p_enrl_request_rec.attribute9,
	  p_attribute10 => p_enrl_request_rec.attribute10,
	  p_attribute11 => p_enrl_request_rec.attribute11,
	  p_attribute12 => p_enrl_request_rec.attribute12,
	  p_attribute13 => p_enrl_request_rec.attribute13,
	  p_attribute14 => p_enrl_request_rec.attribute14,
	  p_attribute15 => p_enrl_request_rec.attribute15
);

Line: 587


PROCEDURE Update_Pg_Enrl_Requests(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := Fnd_Api.G_FALSE,
    p_commit                     IN   VARCHAR2     := Fnd_Api.G_FALSE,
    p_validation_level           IN  NUMBER       := Fnd_Api.G_VALID_LEVEL_FULL,

    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,

    p_enrl_request_rec               IN    enrl_request_rec_type
    )

 IS


CURSOR c_get_pg_enrl_requests(enrl_request_id NUMBER) IS
    SELECT *
    FROM  PV_PG_ENRL_REQUESTS
    WHERE  enrl_request_id = p_enrl_request_rec.enrl_request_id;

Line: 610


L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Pg_Enrl_Requests';

Line: 621


      SAVEPOINT update_pg_enrl_requests_pvt;

Line: 655


      Pvx_Utility_Pvt.debug_message('PRIVATE API: - OPEN CURSOR TO SELECT');

Line: 663


         FND_MESSAGE.Set_Name ('PV', 'API_MISSING_UPDATE_TARGET');

Line: 705


            p_validation_mode => Jtf_Plsql_Api.g_update,
            p_enrl_request_rec  =>  p_enrl_request_rec,
            x_return_status    => x_return_status,
            x_msg_count        => x_msg_count,
            x_msg_data         => x_msg_data);

Line: 720


      Pvx_Utility_Pvt.debug_message('PRIVATE API: Calling UPDATE TABLE handler');

Line: 730


      Pv_Pg_Enrl_Requests_Pkg.Update_Row(
          p_enrl_request_id  => p_enrl_request_rec.enrl_request_id,
          p_object_version_number  => p_enrl_request_rec.object_version_number,
          p_program_id  => p_enrl_request_rec.program_id,
          p_partner_id  => p_enrl_request_rec.partner_id,
          p_custom_setup_id  => p_enrl_request_rec.custom_setup_id,
          p_requestor_resource_id  => p_enrl_request_rec.requestor_resource_id,
          p_request_status_code  => p_enrl_request_rec.request_status_code,
          p_enrollment_type_code  => p_enrl_request_rec.enrollment_type_code,
          p_request_submission_date  => p_enrl_request_rec.request_submission_date,
          p_contract_id  => p_enrl_request_rec.contract_id,
          p_request_initiated_by_code  => p_enrl_request_rec.request_initiated_by_code,
          p_invite_header_id  => p_enrl_request_rec.invite_header_id,
          p_tentative_start_date  => p_enrl_request_rec.tentative_start_date,
          p_tentative_end_date  => p_enrl_request_rec.tentative_end_date,
          p_contract_status_code  => p_enrl_request_rec.contract_status_code,
          p_payment_status_code  => p_enrl_request_rec.payment_status_code,
          p_score_result_code  => p_enrl_request_rec.score_result_code,
          p_last_updated_by  => Fnd_Global.USER_ID,
          p_last_update_date  => SYSDATE,
          p_last_update_login  => Fnd_Global.conc_login_id,
          p_order_header_id  => p_enrl_request_rec.order_header_id,
          p_membership_fee  => p_enrl_request_rec.membership_fee,
          p_dependent_program_id  => p_enrl_request_rec.dependent_program_id,
          p_trans_curr_code  => p_enrl_request_rec.trans_curr_code,
          p_contract_binding_contact_id  => p_enrl_request_rec.contract_binding_contact_id,
          p_contract_signed_date  => p_enrl_request_rec.contract_signed_date,
          p_trxn_extension_id  => p_enrl_request_rec.trxn_extension_id,
	  p_attribute1 => p_enrl_request_rec.attribute1,
	  p_attribute2 => p_enrl_request_rec.attribute2,
	  p_attribute3 => p_enrl_request_rec.attribute3,
	  p_attribute4 => p_enrl_request_rec.attribute4,
	  p_attribute5 => p_enrl_request_rec.attribute5,
	  p_attribute6 => p_enrl_request_rec.attribute6,
	  p_attribute7 => p_enrl_request_rec.attribute7,
	  p_attribute8 => p_enrl_request_rec.attribute8,
	  p_attribute9 => p_enrl_request_rec.attribute9,
	  p_attribute10 => p_enrl_request_rec.attribute10,
	  p_attribute11 => p_enrl_request_rec.attribute11,
	  p_attribute12 => p_enrl_request_rec.attribute12,
	  p_attribute13 => p_enrl_request_rec.attribute13,
	  p_attribute14 => p_enrl_request_rec.attribute14,
	  p_attribute15 => p_enrl_request_rec.attribute15
);

Line: 806


         FND_MESSAGE.Set_Name ('PV', 'API_MISSING_UPDATE_TARGET');

Line: 832


     ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;

Line: 842


     ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;

Line: 852


     ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;

Line: 864


END Update_Pg_Enrl_Requests;

Line: 901


PROCEDURE Delete_Pg_Enrl_Requests(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := Fnd_Api.G_FALSE,
    p_commit                     IN   VARCHAR2     := Fnd_Api.G_FALSE,
    p_validation_level           IN   NUMBER       := Fnd_Api.G_VALID_LEVEL_FULL,
    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,
    p_enrl_request_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Pg_Enrl_Requests';

Line: 920


      SAVEPOINT delete_pg_enrl_requests_pvt;

Line: 957


      Pvx_Utility_Pvt.debug_message( 'PRIVATE API: Calling DELETE TABLE handler');

Line: 961


      Pv_Pg_Enrl_Requests_Pkg.Delete_Row(
          p_enrl_request_id  => p_enrl_request_id,
          p_object_version_number => p_object_version_number     );

Line: 995


     ROLLBACK TO DELETE_Pg_Enrl_Requests_PVT;

Line: 1005


     ROLLBACK TO DELETE_Pg_Enrl_Requests_PVT;

Line: 1015


     ROLLBACK TO DELETE_Pg_Enrl_Requests_PVT;

Line: 1027


END Delete_Pg_Enrl_Requests;

Line: 1427


      SELECT *
      FROM pv_pg_enrl_requests
      WHERE enrl_request_id = p_enrl_request_rec.enrl_request_id;

Line: 1535


   IF p_enrl_request_rec.last_updated_by IS NULL THEN
      x_complete_rec.last_updated_by := l_enrl_request_rec.last_updated_by;

Line: 1540


   IF p_enrl_request_rec.last_update_date IS NULL THEN
      x_complete_rec.last_update_date := l_enrl_request_rec.last_update_date;

Line: 1545


   IF p_enrl_request_rec.last_update_login IS NULL THEN
      x_complete_rec.last_update_login := l_enrl_request_rec.last_update_login;