APPS.HR_JP_ID_PKG dependencies on PER_JOBS

Line 972: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_JOBS%ROWTYPE

968: --------------------------------------------------------------------------------
969: FUNCTION job_rec(
970: p_concatenated_segments IN VARCHAR2,
971: p_business_group_id IN NUMBER,
972: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_JOBS%ROWTYPE
973: --------------------------------------------------------------------------------
974: IS
975: l_id_flex_num NUMBER;
976: l_job_definition_id NUMBER;

Line 978: l_rec PER_JOBS%ROWTYPE;

974: IS
975: l_id_flex_num NUMBER;
976: l_job_definition_id NUMBER;
977: l_csr RefCsr;
978: l_rec PER_JOBS%ROWTYPE;
979: BEGIN
980: l_id_flex_num := id_flex_num(p_business_group_id,'JOB');
981: l_job_definition_id := keyflex_combination_id('PER','JOB',l_id_flex_num,p_concatenated_segments,p_error_when_not_exist);
982:

Line 986: l_csr := csr_with_bus('PER_JOBS','JOB_DEFINITION_ID','N',to_char(l_job_definition_id),p_business_group_id);

982:
983: if l_job_definition_id is NULL then
984: l_rec := NULL;
985: else
986: l_csr := csr_with_bus('PER_JOBS','JOB_DEFINITION_ID','N',to_char(l_job_definition_id),p_business_group_id);
987: fetch l_csr into l_rec;
988: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
989: l_rec := NULL;
990: end if;