APPS.HR_EDW_WRK_CMPSTN_F_C dependencies on HRI_EDW_DAILY_SALARY_DETAILS

Line 10: -- Populate the hri_edw_daily_salary_details performace

6: g_row_count Number:=0;
7: g_exception_msg varchar2(2000):=Null;
8: g_local_same_as_remote BOOLEAN:=FALSE;
9: --
10: -- Populate the hri_edw_daily_salary_details performace
11: -- weith pre calculated salary information
12: --
13: --
14: FUNCTION LOCAL_SAME_AS_REMOTE RETURN BOOLEAN

Line 29: l_stmt := 'DROP INDEX hri_edw_daily_salary_details_u';

25: --
26: l_stmt VARCHAR2(240);
27: --
28: BEGIN
29: l_stmt := 'DROP INDEX hri_edw_daily_salary_details_u';
30: EXECUTE IMMEDIATE l_stmt;
31: EXCEPTION WHEN OTHERS THEN
32: null; -- Do nothing if no index error occurs
33: END drop_index;

Line 506: l_stmt := 'TRUNCATE TABLE hri_edw_daily_salary_details';

502: Begin
503: --
504: -- Push the Composition data
505: --
506: l_stmt := 'TRUNCATE TABLE hri_edw_daily_salary_details';
507: BEGIN
508: EXECUTE IMMEDIATE l_stmt;
509: EXCEPTION
510: WHEN OTHERS THEN

Line 511: DELETE FROM hri_edw_daily_salary_details;

507: BEGIN
508: EXECUTE IMMEDIATE l_stmt;
509: EXCEPTION
510: WHEN OTHERS THEN
511: DELETE FROM hri_edw_daily_salary_details;
512: END;
513: --
514: INSERT INTO hri_edw_daily_salary_details
515: (salary,

Line 514: INSERT INTO hri_edw_daily_salary_details

510: WHEN OTHERS THEN
511: DELETE FROM hri_edw_daily_salary_details;
512: END;
513: --
514: INSERT INTO hri_edw_daily_salary_details
515: (salary,
516: salary_currency_code,
517: assignment_id)
518: select s.proposed_salary_n*

Line 557: x_object_name => 'HRI_EDW_DAILY_SALARY_DETAILS',

553: -- The indexes should be created in correct tablespace.
554: --
555: ad_tspace_util.get_object_tablespace(
556: x_product_short_name => 'HRI',
557: x_object_name => 'HRI_EDW_DAILY_SALARY_DETAILS',
558: x_object_type => 'TABLE',
559: x_index_lookup_flag => 'Y',
560: x_validate_ts_exists => 'N',
561: x_is_object_registered => l_is_object_registered,

Line 565: l_stmt:='Create index hri_edw_daily_salary_details_u on hri_edw_daily_salary_details'||

561: x_is_object_registered => l_is_object_registered,
562: x_ts_exists => l_ts_exists,
563: x_tablespace => l_tablespace);
564: --
565: l_stmt:='Create index hri_edw_daily_salary_details_u on hri_edw_daily_salary_details'||
566: '(assignment_id) tablespace '||l_tablespace;
567: --
568: BEGIN
569: EXECUTE IMMEDIATE l_stmt;