APPS.HR_JP_ID_PKG dependencies on PER_POSITIONS

Line 1009: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_POSITIONS%ROWTYPE

1005: --------------------------------------------------------------------------------
1006: FUNCTION position_rec(
1007: p_concatenated_segments IN VARCHAR2,
1008: p_business_group_id IN NUMBER,
1009: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_POSITIONS%ROWTYPE
1010: --------------------------------------------------------------------------------
1011: IS
1012: l_id_flex_num NUMBER;
1013: l_position_definition_id NUMBER;

Line 1015: l_rec PER_POSITIONS%ROWTYPE;

1011: IS
1012: l_id_flex_num NUMBER;
1013: l_position_definition_id NUMBER;
1014: l_csr RefCsr;
1015: l_rec PER_POSITIONS%ROWTYPE;
1016: BEGIN
1017: l_id_flex_num := id_flex_num(p_business_group_id,'POS');
1018: l_position_definition_id := keyflex_combination_id('PER','POS',l_id_flex_num,p_concatenated_segments,p_error_when_not_exist);
1019:

Line 1023: l_csr := csr_with_bus('PER_POSITIONS','POSITION_DEFINITION_ID','N',to_char(l_position_definition_id),p_business_group_id);

1019:
1020: if l_position_definition_id is NULL then
1021: l_rec := NULL;
1022: else
1023: l_csr := csr_with_bus('PER_POSITIONS','POSITION_DEFINITION_ID','N',to_char(l_position_definition_id),p_business_group_id);
1024: fetch l_csr into l_rec;
1025: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1026: l_rec := NULL;
1027: end if;