PACKAGE: APPS.HRI_EDW_FCT_WRKFC_SPRTN

Source

1 PACKAGE hri_edw_fct_wrkfc_sprtn  AS
2 /* $Header: hriefwsp.pkh 120.1 2005/06/07 05:30:26 anmajumd noship $ */
3   --
4   FUNCTION calc_abv(p_assignment_id     IN NUMBER,
5                     p_business_group_id IN NUMBER,
6                     p_budget_type       IN VARCHAR2,
7                     p_effective_date    IN DATE)
8                     RETURN NUMBER;
9   --
10   FUNCTION find_movement_fk(p_actual_termination_date    IN DATE
11                            ,p_accepted_termination_date  IN DATE
12                            ,p_notified_termination_date  IN DATE
13                            ,p_projected_termination_date IN DATE
14                            ,p_final_process_date         IN DATE
15                            ,p_reason                     IN VARCHAR2)
16                    RETURN VARCHAR2;
17   --
18   PROCEDURE populate_sep_rsns;
19   --
20   PROCEDURE set_update_flag( p_reason_code     IN VARCHAR2 := NULL,
21                              p_update_allowed  IN VARCHAR2);
22   --
23   PROCEDURE populate_hri_prd_of_srvce;
24   --
25 End hri_edw_fct_wrkfc_sprtn ;