[Home] [Help]
PACKAGE: APPS.CSD_ESTIMATE_UTILS_PVT
Source
1 Package Csd_Estimate_Utils_Pvt AS
2 /* $Header: csdueuts.pls 120.3 2005/08/26 17:09:21 takwong noship $ */
3
4 /*-------------------------------------------------------*/
5 /* function name: validate_estimate_id */
6 /* DEscription: Validates the estimate in the context */
7 /* of repair_line_Id */
8 /* Change History : Created 24th June 2005 by Vijay */
9 /*-------------------------------------------------------*/
10 FUNCTION VALIDATE_ESTIMATE_ID(p_estimate_id NUMBER,
11 p_repair_line_id NUMBER) RETURN BOOLEAN;
12
13 /*-------------------------------------------------------*/
14 /* function name: validate_estiamte_status */
15 /* DEscription: Validates the estimate status */
16 /* Change History : Created 24th June 2005 by Vijay */
17 /*-------------------------------------------------------*/
18 FUNCTION VALIDATE_EST_STATUS(p_estimate_status VARCHAR2) RETURN BOOLEAN;
19
20 /*-------------------------------------------------------*/
21 /* function name: validate_reject_Reason */
22 /* DEscription: Validates the estimate reject reason */
23 /* Change History : Created 24th June 2005 by Vijay */
24 /* */
25 /*-------------------------------------------------------*/
26 FUNCTION VALIDATE_REASON(p_reason_code VARCHAR2, p_status VARCHAR2)
27 RETURN BOOLEAN;
28
29 /*-------------------------------------------------------*/
30 /* function name: validate_uom_Code */
31 /* DEscription: Validates the uom code */
32 /* Change History : Created 24th June 2005 by Vijay */
33 /*-------------------------------------------------------*/
34 FUNCTION VALIDATE_UOM_CODE(p_uom_code VARCHAR2, p_item_id NUMBER)
35 RETURN BOOLEAN;
36
37 /*-------------------------------------------------------*/
38 /* function name: validate_lead_time_uom */
39 /* DEscription: Validates the uom code of th elead time */
40 /* Change History : Created 24th June 2005 by Vijay */
41 /*-------------------------------------------------------*/
42 FUNCTION VALIDATE_LEAD_TIME_UOM(p_lead_time_uom VARCHAR2) RETURN BOOLEAN;
43
44 /*-------------------------------------------------------*/
45 /* function name: validate_price_list */
46 /* DEscription: Validates price_list */
47 /* Change History : Created 24th June 2005 by Vijay */
48 /*-------------------------------------------------------*/
49 FUNCTION VALIDATE_PRICE_LIST(p_price_list_id NUMBER) RETURN BOOLEAN;
50
51 /*-------------------------------------------------------*/
52 /* function name: validate_Item_pl_uom */
53 /* DEscription: Validates the item/pl/uom code */
54 /* Change History : Created 24th June 2005 by Vijay */
55 /*-------------------------------------------------------*/
56 -- FUNCTION VALIDATE_ITEM_PL_UOM
57 -- ( p_item_id NUMBER,
58 -- p_price_list_id NUMBER,
59 -- p_uom VARCHAR2) RETURN BOOLEAN;
60
61 /*-------------------------------------------------------*/
62 /* function name: validate_order */
63 /* DEscription: Validates the order header and line */
64 /* and returns the order number */
65 /* Change History : Created 24th June 2005 by Vijay */
66 /*-------------------------------------------------------*/
67 FUNCTION VALIDATE_ORDER(p_order_header_id NUMBER) RETURN VARCHAR2;
68
69 /*-------------------------------------------------------*/
70 /* function name: validate_item_instance */
71 /* DEscription: Validates the item instance and returns */
72 /* the itme instance number */
73 /* Change History : Created 24th June 2005 by Vijay */
74 /*-------------------------------------------------------*/
75 FUNCTION VALIDATE_ITEM_INSTANCE(p_instance_id NUMBER) RETURN VARCHAR2;
76
77 /*-------------------------------------------------------*/
78 /* function name: validate_revision */
79 /* DEscription: Validates the revision */
80 /* Change History : Created 24th June 2005 by Vijay */
81 /*-------------------------------------------------------*/
82 FUNCTION VALIDATE_REVISION(p_revision VARCHAR2,
83 p_item_id NUMBER,
84 p_org_id NUMBER) RETURN BOOLEAN;
85
86 /*-------------------------------------------------------*/
87 /* function name: validate_serial_number */
88 /* DEscription: Validates the serial number */
89 /* Change History : Created 24th June 2005 by Vijay */
90 /*-------------------------------------------------------*/
91 FUNCTION VALIDATE_SERIAL_NUMBER(p_serial_number VARCHAR2,
92 p_item_id NUMBER) RETURN BOOLEAN;
93
94 /*-------------------------------------------------------*/
95 /* function name: validate_billing_type */
96 /* DEscription: Validates the billing type from looks */
97 /* table */
98 /* Change History : Created 24th June 2005 by Vijay */
99 /*-------------------------------------------------------*/
100 FUNCTION VALIDATE_BILLING_TYPE(p_billing_type VARCHAR2) RETURN BOOLEAN;
101
102 /*-------------------------------------------------------*/
103 /* function name: validate_rep_line_id */
104 /* DEscription: Validates the repair line id */
105 /* */
106 /* Change History : Created 24th June 2005 by Vijay */
107 /*-------------------------------------------------------*/
108 FUNCTION validate_rep_line_id(p_repair_line_id IN NUMBER) RETURN BOOLEAN;
109
110 /*-------------------------------------------------------*/
111 /* function name: validate_incident_id */
112 /* DEscription: Validates the incident id */
113 /* */
114 /* Change History : Created 24th June 2005 by Vijay */
115 /*-------------------------------------------------------*/
116 FUNCTION validate_incident_id(p_incident_id IN NUMBER) RETURN BOOLEAN;
117
118 /*-------------------------------------------------------*/
119 /* procedure name: validate_est_hdr_rec */
120 /* DEscription: Validates estimates header record */
121 /* */
122 /* Change History : Created 25th June2005 by Vijay */
123 /*-------------------------------------------------------*/
124 PROCEDURE validate_est_hdr_rec(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec,
125 p_validation_level IN NUMBER) ;
126
127
128 FUNCTION get_pricing_rec(p_estimate_line_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC)
129 RETURN Csd_Process_Util.PRICING_ATTR_REC;
130 /*------------------------------------------------------------------------*/
131 /* procedure name: DEFAULT_EST_HDR_REC */
132 /* DEscription: DEfault values are set in estimates header record */
133 /* */
134 /* Change History : Created 25th June2005 by Vijay */
135 /*------------------------------------------------------------------------*/
136
137 PROCEDURE DEFAULT_EST_HDR_REC(p_estimate_hdr_rec IN OUT NOCOPY Csd_Repair_Estimate_Pub.estimate_hdr_Rec);
138
139
140 /*------------------------------------------------------------------------*/
141 /* procedure name: VALIDATE_DEFAULTED_EST_HDR */
142 /* DEscription: Validate the defaulted estimates header record */
143 /* */
144 /* Change History : Created 25th June2005 by Vijay */
145 /*------------------------------------------------------------------------*/
146 PROCEDURE VALIDATE_DEFAULTED_EST_HDR(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec,
147 p_validation_level IN NUMBER);
148 /*-------------------------------------------------------*/
149 /* procedure name: validate_est_line_rec */
150 /* DEscription: Validates estimates line record */
151 /* */
152 /* Change History : Created 25th June2005 by Vijay */
153 /*-------------------------------------------------------*/
154
155 PROCEDURE VALIDATE_EST_LINE_REC(p_estimate_line_rec IN Csd_Repair_Estimate_Pub.estimate_line_Rec,
156 p_validation_level IN NUMBER) ;
157 /*------------------------------------------------------------------------*/
158 /* procedure name: DEFAULT_EST_LINE_REC */
159 /* DEscription: DEfault values are set in estimates line record */
160 /* */
161 /* Change History : Created 25th June2005 by Vijay */
162 /*------------------------------------------------------------------------*/
163
164 PROCEDURE DEFAULT_EST_LINE_REC(px_estimate_line_rec IN OUT NOCOPY Csd_Repair_Estimate_Pub.estimate_line_Rec);
165
166
167 PROCEDURE COPY_TO_EST_HDR_REC(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec,
168 x_est_pvt_hdr_rec OUT NOCOPY Csd_Repair_Estimate_Pvt.REPAIR_ESTIMATE_REC);
169
170 PROCEDURE COPY_TO_EST_HDR_REC_UPD(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec,
171 x_est_pvt_hdr_rec OUT NOCOPY Csd_Repair_Estimate_Pvt.REPAIR_ESTIMATE_REC) ;
172
173 /*------------------------------------------------------------------------*/
174 /* procedure name: VALIDATE_DEFAULTED_EST_LINE */
175 /* DEscription: Validate the defaulted estimates header record */
176 /* */
177 /* Change History : Created 25th June2005 by Vijay */
178 /*------------------------------------------------------------------------*/
179 PROCEDURE VALIDATE_DEFAULTED_EST_LINE(p_estimate_line_rec IN Csd_Repair_Estimate_Pub.estimate_line_Rec,
180 p_validation_level IN NUMBER) ;
181
182
183 --PROCEDURE COPY_TO_EST_pvt_line_REC(p_estimate_line_rec IN Csd_Repair_Estimate_Pub.estimate_line_Rec,
184 -- x_est_pvt_line_rec OUT NOCOPY Csd_Repair_Estimate_Pvt.REPAIR_ESTIMATE_LINE_REC) ;
185
186 END Csd_Estimate_Utils_Pvt;