11: V_VERSION_END_DATE DATE;
12: BEGIN
13: --HR_STANDARD.EVENT('AFTER REPORT');
14: C_END_OF_TIME := HR_GENERAL.END_OF_TIME;
15: C_BUSINESS_GROUP_NAME := HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
16: V_ORGANIZATION_NAME := C_BUSINESS_GROUP_NAME;
17: IF P_PARENT_ORGANIZATION_ID IS NOT NULL THEN
18: HR_REPORTS.GET_ORGANIZATION(P_PARENT_ORGANIZATION_ID
19: ,V_ORGANIZATION_NAME
14: C_END_OF_TIME := HR_GENERAL.END_OF_TIME;
15: C_BUSINESS_GROUP_NAME := HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
16: V_ORGANIZATION_NAME := C_BUSINESS_GROUP_NAME;
17: IF P_PARENT_ORGANIZATION_ID IS NOT NULL THEN
18: HR_REPORTS.GET_ORGANIZATION(P_PARENT_ORGANIZATION_ID
19: ,V_ORGANIZATION_NAME
20: ,V_ORGANIZATION_TYPE);
21: C_PARENT_ORGANIZATION_NAME := V_ORGANIZATION_NAME;
22: ELSE
22: ELSE
23: C_PARENT_ORGANIZATION_NAME := '';
24: END IF;
25: IF P_ORG_STRUCTURE_VERSION_ID IS NOT NULL THEN
26: HR_REPORTS.GET_ORGANIZATION_HIERARCHY(NULL
27: ,P_ORG_STRUCTURE_VERSION_ID
28: ,V_ORG_STRUCTURE_NAME
29: ,V_ORG_VERSION
30: ,V_VERSION_START_DATE