PACKAGE: APPS.EDW_PROJ_PKG

Source

1 PACKAGE EDW_PROJ_PKG  AS
2 /* $Header: FIICAPJS.pls 120.0 2002/08/24 04:50:11 appldev noship $  */
3 
4 -- ------------------------
5 -- Public Functions
6 -- ------------------------
7 Function project_fk(
8    p_project_id        in NUMBER,
9    p_instance_code     in VARCHAR2 := NULL)
10    return VARCHAR2;
11 
12 Function seiban_number_fk(
13    p_project_id        in NUMBER,
14    p_instance_code     in VARCHAR2 := NULL)
15    return VARCHAR2;
16 
17 Function task_fk(
18    p_task_id           in NUMBER,
19    p_project_id        in NUMBER   := NULL,
20    p_instance_code     in VARCHAR2 := NULL)
21    return VARCHAR2;
22 
23 Function top_task_fk(
24    p_task_id           in NUMBER,
25    p_project_id        in NUMBER   := NULL,
26    p_instance_code     in VARCHAR2 := NULL)
27    return VARCHAR2;
28 
29 PRAGMA RESTRICT_REFERENCES (project_fk,WNDS, WNPS, RNPS);
30 PRAGMA RESTRICT_REFERENCES (task_fk,WNDS, WNPS, RNPS);
31 PRAGMA RESTRICT_REFERENCES (top_task_fk,WNDS, WNPS, RNPS);
32 PRAGMA RESTRICT_REFERENCES (seiban_number_fk,WNDS,WNPS, RNPS);
33 end;