[Home] [Help]
1590: FUNCTION org_information_rec(
1591: p_organization_id IN NUMBER,
1592: p_org_information_context IN VARCHAR2,
1593: p_org_information1 IN VARCHAR2 DEFAULT NULL,
1594: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN HR_ORGANIZATION_INFORMATION%ROWTYPE
1595: --------------------------------------------------------------------------------
1596: IS
1597: l_unique_column_tbl UniColTbl;
1598: l_csr RefCsr;
1595: --------------------------------------------------------------------------------
1596: IS
1597: l_unique_column_tbl UniColTbl;
1598: l_csr RefCsr;
1599: l_rec HR_ORGANIZATION_INFORMATION%ROWTYPE;
1600: BEGIN
1601: unique_tbl_constructor('ORGANIZATION_ID','N',to_char(p_organization_id),l_unique_column_tbl);
1602: unique_tbl_constructor('ORG_INFORMATION_CONTEXT','T',p_org_information_context,l_unique_column_tbl);
1603: if p_org_information_context = 'CLASS' then
1603: if p_org_information_context = 'CLASS' then
1604: unique_tbl_constructor('ORG_INFORMATION1','T',p_org_information1,l_unique_column_tbl);
1605: end if;
1606:
1607: l_csr := csr('HR_ORGANIZATION_INFORMATION',l_unique_column_tbl);
1608: fetch l_csr into l_rec;
1609: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1610: l_rec := NULL;
1611: end if;
1628: p_name IN VARCHAR2,
1629: p_org_information_context IN VARCHAR2,
1630: p_org_information1 IN VARCHAR2 DEFAULT NULL,
1631: p_business_group_id IN VARCHAR2,
1632: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN HR_ORGANIZATION_INFORMATION%ROWTYPE
1633: --------------------------------------------------------------------------------
1634: IS
1635: l_organization_id NUMBER;
1636: BEGIN