[Home] [Help]
PACKAGE: APPS.RLM_COMP_SCH_TO_DEMAND_SV
Source
1 PACKAGE RLM_COMP_SCH_TO_DEMAND_SV AUTHID CURRENT_USER as
2 /* $Header: RLMCOMDS.pls 115.1 2002/11/25 16:46:59 brana noship $*/
3
4 /*===========================================================================
5 PACKAGE NAME: rlm_comp_sch_to_demand_sv
6
7 DESCRIPTION: Contains all server side code for populating the records in the
8 temporary table for Compare schedule to demand report.
9
10 CLIENT/SERVER: Server
11
12 LIBRARY NAME: None
13
14 OWNER: brana
15
16 PROCEDURE/FUNCTIONS:
17 proc_comp_sch_to_demand()
18 get_weekly_quantity()
19 get_monday_date()
20 get_precision ()
21 GLOBALS:
22 g_SDEBUG
23 g_DEBUG
24
25
26 ===========================================================================*/
27 g_DAY CONSTANT VARCHAR2(10) := '1';
28 g_WEEK CONSTANT VARCHAR2(10) := '2';
29 g_FLEXIBLE CONSTANT VARCHAR2(10) := '3';
30 g_MONTH CONSTANT VARCHAR2(10) := '4';
31 g_QUARTER CONSTANT VARCHAR2(10) := '5';
32 g_SUCCESS CONSTANT NUMBER := 0;
33 g_WARNING CONSTANT NUMBER := 1;
34 g_ERROR CONSTANT NUMBER := 2;
35 g_RaiseErr CONSTANT NUMBER := -10;
36
37 /*===========================================================================
38 PROCEDURE NAME: proc_comp_sch_to_demand
39
40 DESCRIPTION: This is the main procedure which is used for inserting the
41 records in the Temporary Table for the Compare Schedule
42 to Demand Report.
43
44 PARAMETERS: p_schedule_type IN VARCHAR2,
45 p_header_id IN NUMBER :=NULL,
46 p_Customer_name_from IN varchar2 :=NULL,
47 p_Customer_name_to IN Varchar2 :=NULL,
48 p_ship_from_org_id IN NUMBER :=NULL,
49 p_ship_to IN NUMBER :=NULL,
50 p_tp_code_from IN VARCHAR2 :=NULL,
51 p_tp_code_to IN VARCHAR2 :=NULL,
52 p_tp_location_from IN VARCHAR2 :=NULL,
53 p_tp_location_to IN VARCHAR2 :=NULL,
54 p_process_date_from IN VARCHAR2 :=NULL,
55 p_process_date_to IN VARCHAR2 :=NULL,
56 p_issue_date_from IN VARCHAR2 :=NULL,
57 p_issue_date_to IN VARCHAR2 :=NULL,
58 p_request_date_from IN VARCHAR2 :=NULL,
59 p_request_date_to IN VARCHAR2 :=NULL,
60 p_customer_item_from IN VARCHAR2 :=NULL,
61 p_customer_item_to IN VARCHAR2 :=NULL,
62 p_internal_item_from IN VARCHAR2 :=NULL,
63 p_internal_item_to IN VARCHAR2 :=NULL,
64 p_demand_type IN VARCHAR2 :=NULL,
65
66
67 DESIGN REFERENCES: rlmdmddld.rtf
68
69 ALGORITHM:
70
71 NOTES:
72
73 OPEN ISSUES:
74
75 CLOSED ISSUES:
76
77 CHANGE HISTORY: brana 11/15/02 created
78 ===========================================================================*/
79 PROCEDURE proc_comp_sch_to_demand
80 (p_schedule_type IN VARCHAR2,
81 p_header_id IN NUMBER :=NULL,
82 p_Customer_name_from IN Varchar2 :=NULL,
83 p_Customer_name_to IN Varchar2 :=NULL,
84 p_ship_from_org_id IN NUMBER :=NULL,
85 p_ship_to IN NUMBER :=NULL,
86 p_tp_code_from IN VARCHAR2 :=NULL,
87 p_tp_code_to IN VARCHAR2 :=NULL,
88 p_tp_location_from IN VARCHAR2 :=NULL,
89 p_tp_location_to IN VARCHAR2 :=NULL,
90 p_process_date_from IN VARCHAR2 :=NULL,
91 p_process_date_to IN VARCHAR2 :=NULL,
92 p_issue_date_from IN VARCHAR2 :=NULL,
93 p_issue_date_to IN VARCHAR2 :=NULL,
94 p_request_date_from IN VARCHAR2 :=NULL,
95 p_request_date_to IN VARCHAR2 :=NULL,
96 p_customer_item_from IN VARCHAR2 :=NULL,
97 p_customer_item_to IN VARCHAR2 :=NULL,
98 p_internal_item_from IN VARCHAR2 :=NULL,
99 p_internal_item_to IN VARCHAR2 :=NULL,
100 p_demand_type IN VARCHAR2 :=NULL
101 ) ;
102
103
104 /*===========================================================================
105 FUNCTION NAME: get_monday_date
106
107 DESCRIPTION: This procedure finds the Monday date for a given week
108
109 PARAMETERS: P_DATE IN Date
110
111 DESIGN REFERENCES: rlmdmddld.rtf
112
113 ALGORITHM:
114
115 NOTES:
116
117 OPEN ISSUES:
118
119 CLOSED ISSUES:
120
121 CHANGE HISTORY: BRANA 11/15/02 created
122 ===========================================================================*/
123 FUNCTION GET_MONDAY_DATE (P_DATE date)
124 RETURN DATE ;
125
126
127 /*===========================================================================
128 FUNCTION NAME: week_name
129
130 DESCRIPTION: This procedure finds the Monday date for the given week
131
132 PARAMETERS: v_week_number IN Number
133
134 DESIGN REFERENCES: rlmdmddld.rtf
135
136 ALGORITHM:
137
138 NOTES:
139
140 OPEN ISSUES:
141
142 CLOSED ISSUES:
143
144 CHANGE HISTORY: BRANA 11/15/02 created
145 ===========================================================================*/
146 Function Get_week_Name(v_week_number in NUMBER)
147 RETURN VARCHAR2 ;
148
149 END RLM_COMP_SCH_TO_DEMAND_SV;