1 PACKAGE EDW_HR_PERSON_PKG AS
2 /*$Header: hriekpsn.pkh 120.1 2005/06/07 05:40:46 anmajumd noship $*/
3 -- ---------------------------------------------------------
4 -- Regular Employee API for Person Hierarchy in PERSON DIMENSION
5 --
6 -- Function returns primary assignment level key for this regular
7 -- employee (past and current) with employee_id = p_person_id
8 --
9 -- Underlining View: edw_hr_person_prim_assign_fkv
10 -- ---------------------------------------------------------
11 --
12 Function Regular_Employee_FK (
13 p_person_id in NUMBER,
14 p_instance_code in VARCHAR2 := NULL) return VARCHAR2;
15 --
16 -- ---------------------------------------------------------
17 -- Planners API for Person Hierarchy in PERSON DIMENSION
18 -- Function returns primary assignment level key for this planner with
19 -- p_organization_id and p_planner_code
20 --
21 -- Underlining View: edw_mtl_planners_fkv
22 -- ---------------------------------------------------------
23 --
24 Function Planner_FK (
25 p_organization_id in NUMBER,
26 p_planner_code in VARCHAR2,
27 p_instance_code in VARCHAR2 := NULL) return VARCHAR2;
28 --
29 -- ---------------------------------------------------------
30 -- Sales_Rep API for Person Hierarchy in PERSON DIMENSION
31 --
32 -- Function returns primary assignment level key for sales_rep with
33 -- sales_rep_id = p_salesrep_id and organization_id = p_organization_id
34 -- Underlining View: edw_ra_salesreps_fkv
35 -- ---------------------------------------------------------
36 --
37 Function Sales_Rep_FK (
38 p_salesrep_id in NUMBER,
39 p_organization_id in NUMBER,
40 p_instance_code in VARCHAR2 :=NULL) return VARCHAR2;
41 --
42 PRAGMA RESTRICT_REFERENCES (Regular_Employee_FK, WNDS, WNPS, RNPS);
43 --
44 PRAGMA RESTRICT_REFERENCES (Planner_FK, WNDS, WNPS, RNPS);
45 --
46 PRAGMA RESTRICT_REFERENCES (Sales_Rep_FK, WNDS, WNPS, RNPS);
47 --
48 -- -----------------------------------------------------------
49 -- API to determine if a person with person_id is a buyer
50 -- It returns either 'Y' or 'N'
51 -- -----------------------------------------------------------
52 --
53 Function Buyer_Flag (p_person_id in NUMBER) return VARCHAR2;
54 --
55 -- -----------------------------------------------------------
56 -- API to determine if a person with person_id is a planner
57 -- It returns either 'Y' or 'N'
58 -- -----------------------------------------------------------
59 --
60 Function Planner_Flag (p_person_id in NUMBER) return VARCHAR2;
61 --
62 -- -----------------------------------------------------------
63 -- API to determine if a person with person_id is a sales_rep
64 -- It returns either 'Y' or 'N'
65 --------------------------------------------------------------
66 --
67 Function Sales_Rep_Flag (p_person_id in NUMBER) return VARCHAR2;
68 --
69 PRAGMA RESTRICT_REFERENCES (Buyer_Flag, WNDS, WNPS, RNPS);
70 --
71 PRAGMA RESTRICT_REFERENCES (Planner_Flag, WNDS, WNPS, RNPS);
72 --
73 PRAGMA RESTRICT_REFERENCES (Sales_Rep_Flag, WNDS, WNPS, RNPS);
74 --
75 END EDW_HR_PERSON_PKG;
[Home] [Help]