721: procedure create_cert_enrollment_tt
722: (p_validate IN BOOLEAN, p_transaction_step_id IN NUMBER)
723: is
724:
725: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
726: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
727: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
728: l_cert_enrollment_id number;
729: l_object_version_number number;
722: (p_validate IN BOOLEAN, p_transaction_step_id IN NUMBER)
723: is
724:
725: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
726: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
727: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
728: l_cert_enrollment_id number;
729: l_object_version_number number;
730: l_effective_date date := trunc(sysdate);
723: is
724:
725: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
726: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
727: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
728: l_cert_enrollment_id number;
729: l_object_version_number number;
730: l_effective_date date := trunc(sysdate);
731:
953: l_effective_date date := trunc(sysdate);
954: l_certification_status varchar2(100);
955:
956: l_certification_id ota_cert_enrollments.certification_id%type;
957: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE := itemtype;
958: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE := itemkey;
959: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
960:
961: l_IS_HISTORY_FLAG ota_cert_enrollments.is_history_flag%type;
954: l_certification_status varchar2(100);
955:
956: l_certification_id ota_cert_enrollments.certification_id%type;
957: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE := itemtype;
958: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE := itemkey;
959: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
960:
961: l_IS_HISTORY_FLAG ota_cert_enrollments.is_history_flag%type;
962: l_person_id ota_cert_enrollments.person_id%type;
955:
956: l_certification_id ota_cert_enrollments.certification_id%type;
957: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE := itemtype;
958: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE := itemkey;
959: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
960:
961: l_IS_HISTORY_FLAG ota_cert_enrollments.is_history_flag%type;
962: l_person_id ota_cert_enrollments.person_id%type;
963: l_certification_status_code varchar2(100);
1225: if (p_validate = true) then
1226: rollback to validate_enrollment;
1227: else
1228: -- update p_from in transaction table
1229: update hr_api_transaction_values
1230: set varchar2_value = 'APPROVE'
1231: where transaction_step_id = p_transaction_step_id
1232: and name = 'P_FROM';
1233: end if;