1 PACKAGE MRP_SELECT_ALL_FOR_RELEASE_PUB AS
2 /* $Header: MRPSARPS.pls 120.2 2006/02/01 05:11:59 arrsubra noship $ */
3
4 PROCEDURE Update_Implement_Attrib(p_where_clause IN VARCHAR2,
5 p_employee_id IN NUMBER,
6 p_demand_class IN VARCHAR2,
7 p_def_job_class IN VARCHAR2,
8 p_def_firm_jobs IN VARCHAR2,
9 p_total_rows OUT NOCOPY NUMBER,
10 p_succ_rows OUT NOCOPY NUMBER,
11 p_error_rows OUT NOCOPY NUMBER);
12
13
14 PROCEDURE Update_Recom_Attrib(
15 p_employee_id IN NUMBER,
16 p_demand_class IN VARCHAR2,
17 p_def_job_class IN VARCHAR2,
18 p_def_firm_jobs IN VARCHAR2);
19
20 Procedure Update_Pre_Process_Errors(
21 p_no_rec_rows IN NUMBER,
22 p_no_rep_rows IN NUMBER);
23
24
25
26 PROCEDURE Update_Rep_Attrib(p_demand_class IN VARCHAR2);
27
28 FUNCTION Select_Rec_Rows(p_where_clause IN VARCHAR2) return NUMBER;
29
30 FUNCTION Select_Rep_Rows(p_where_clause IN VARCHAR2) return NUMBER;
31
32 FUNCTION Count_Row_Errors return NUMBER;
33
34 Procedure Rollback_Action;
35 Procedure Commit_Action;
36 Procedure Update_Job_Name( arg_org_id IN NUMBER,
37 arg_compile_designator IN VARCHAR2) ; --3463551
38
39 Procedure Update_Identical_Job_Name
40 ( arg_org_id IN NUMBER
41 , arg_compile_desig IN VARCHAR2);--4990499
42
43 /*
44 ** These functions are a duplicate of the general calendar
45 ** functions that we have in MRP. This is done for PRAGMA
46 ** reasons. Note that any change made to the code, in either
47 ** place can be propagated.
48 */
49
50 FUNCTION RELALL_NEXT_WORK_DAY(arg_org_id IN NUMBER,
51 arg_bucket IN NUMBER,
52 arg_date IN DATE) RETURN DATE;
53 FUNCTION RELALL_PREV_WORK_DAY(arg_org_id IN NUMBER,
54 arg_bucket IN NUMBER,
55 arg_date IN DATE) RETURN DATE;
56 FUNCTION RELALL_PREV_WORK_DAY_SEQNUM(arg_org_id IN NUMBER,
57 arg_bucket IN NUMBER,
58 arg_date IN DATE) RETURN NUMBER;
59
60 PROCEDURE RELALL_SELECT_CAL_DEFAULTS( arg_org_id IN NUMBER,
61 arg_calendar_code OUT NOCOPY VARCHAR2,
62 arg_exception_set_id OUT NOCOPY NUMBER);
63
64 PROCEDURE RELALL_MRP_CAL_INIT_GLOBAL(
65 arg_calendar_code VARCHAR,
66 arg_exception_set_id NUMBER);
67
68 FUNCTION RELALL_DAYS_BETWEEN( arg_org_id IN NUMBER,
69 arg_bucket IN NUMBER,
70 arg_date1 IN DATE,
71 arg_date2 IN DATE) RETURN NUMBER;
72
73
74 FUNCTION RELALL_DEFAULT_ACC_CLASS
75 (X_ORG_ID IN NUMBER,
76 X_ITEM_ID IN NUMBER,
77 X_ENTITY_TYPE IN NUMBER,
78 X_PROJECT_ID IN NUMBER
79 )
80 RETURN VARCHAR2;
81
82 FUNCTION RELALL_CHECK_DISABLED(
83 X_CLASS IN VARCHAR2,
84 X_ORG_ID IN NUMBER,
85 X_ENTITY_TYPE IN NUMBER)
86 RETURN NUMBER;
87
88 FUNCTION RELALL_CHECK_VALID_CLASS(
89 X_CLASS IN VARCHAR2,
90 X_ORG_ID IN NUMBER)
91 RETURN NUMBER;
92
93 PRAGMA RESTRICT_REFERENCES (RELALL_NEXT_WORK_DAY, WNDS);
94 PRAGMA RESTRICT_REFERENCES (RELALL_SELECT_CAL_DEFAULTS, WNDS);
95 PRAGMA RESTRICT_REFERENCES (RELALL_MRP_CAL_INIT_GLOBAL, WNDS);
96 PRAGMA RESTRICT_REFERENCES (RELALL_DAYS_BETWEEN, WNDS);
97 PRAGMA RESTRICT_REFERENCES (RELALL_PREV_WORK_DAY, WNDS);
98 PRAGMA RESTRICT_REFERENCES (RELALL_PREV_WORK_DAY_SEQNUM, WNDS);
99 PRAGMA RESTRICT_REFERENCES (RELALL_DEFAULT_ACC_CLASS, WNDS);
100 PRAGMA RESTRICT_REFERENCES (RELALL_CHECK_DISABLED, WNDS);
101 PRAGMA RESTRICT_REFERENCES (RELALL_CHECK_VALID_CLASS, WNDS);
102
103 g_rec_query_id NUMBER;
104 g_rep_query_id NUMBER;
105 END MRP_SELECT_ALL_FOR_RELEASE_PUB;