[Home] [Help]
PACKAGE: APPS.QA_SS_CONST
Source
1 PACKAGE qa_ss_const AUTHID CURRENT_USER AS
2 /* $Header: qltsscnb.pls 120.14.12010000.2 2010/02/08 05:48:08 skolluku ship $ */
3
4
5 --
6 -- This package will now serve all server-side packages by
7 -- maintaining constants and useful data types.
8 --
9
10 TYPE Eqr_Array IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
11
12 def_array Eqr_Array;
13 value_array Eqr_Array;
14
15 TYPE names_table is TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
16
17 TYPE charid_table is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
18
19 TYPE Ctx_Table is TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
20
21 TYPE num_table is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
22 TYPE var150_table is TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
23 TYPE var30_table is TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
24
25 def30_tab var30_table; -- Used as an empty default table
26
27 TYPE bool_table is TABLE OF BOOLEAN INDEX BY BINARY_INTEGER;
28 TYPE var2000_table is TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
29
30 no_of_cols NUMBER := 0;
31 no_of_rows CONSTANT NUMBER := 25;
32 max_cols CONSTANT NUMBER := 160;
33 plan_name_i qa_plans.name%TYPE := NULL;
34 org_code_i mtl_parameters.organization_code%TYPE := NULL;
35 debug_mode BOOLEAN := TRUE;
36 debug_variable NUMBER;
37
38 -- G_Wip_Entity_Type NUMBER;
39 -- G_Wip_Repetitive_Schedule_Id NUMBER;
40 -- G_Po_Header_Id NUMBER;
41 -- G_Po_Release_Id NUMBER;
42 -- G_Po_Line_Id NUMBER;
43 -- G_Line_Location_Id NUMBER;
44 -- G_Po_Distribution_Id NUMBER;
45 -- G_Organization_Id NUMBER;
46 -- G_Item_Id NUMBER;
47 -- G_Wip_Entity_Id NUMBER;
48 -- G_Wip_Line_Id NUMBER;
49
50 -------------------------------------------
51
52 --
53 -- Below are the Char_ID values for all collection elements
54 --
55
56 transaction_date CONSTANT NUMBER := 1;
57 organization_id CONSTANT NUMBER := 2;
58 department CONSTANT NUMBER := 3;
59 quantity CONSTANT NUMBER := 4;
60 qa_created_by_name CONSTANT NUMBER := 5;
61 quality_code CONSTANT NUMBER := 6;
62 comments CONSTANT NUMBER := 7;
63 inspection_result CONSTANT NUMBER := 8;
64 supplier_lot CONSTANT NUMBER := 9;
65 item CONSTANT NUMBER := 10;
66 item_category CONSTANT NUMBER := 11;
67 uom CONSTANT NUMBER := 12;
68 revision CONSTANT NUMBER := 13;
69 subinventory CONSTANT NUMBER := 14;
70 locator CONSTANT NUMBER := 15;
71 lot_number CONSTANT NUMBER := 16;
72 serial_number CONSTANT NUMBER := 17;
73 reason_code CONSTANT NUMBER := 18;
74 job_name CONSTANT NUMBER := 19;
75 production_line CONSTANT NUMBER := 20;
76 to_op_seq_num CONSTANT NUMBER := 21;
77 from_op_seq_num CONSTANT NUMBER := 22;
78 to_intraoperation_step CONSTANT NUMBER := 23;
79 from_intraoperation_step CONSTANT NUMBER := 24;
80 resource_code CONSTANT NUMBER := 25;
81 vendor_name CONSTANT NUMBER := 26;
82 po_number CONSTANT NUMBER := 27;
83 po_line_num CONSTANT NUMBER := 28;
84 po_shipment_num CONSTANT NUMBER := 29;
85
86 receipt_num CONSTANT NUMBER := 31;
87 customer_name CONSTANT NUMBER := 32;
88 sales_order CONSTANT NUMBER := 33;
89 rma_number CONSTANT NUMBER := 34;
90 order_line CONSTANT NUMBER := 35;
91 ship_to CONSTANT NUMBER := 36;
92 location CONSTANT NUMBER := 37;
93 collection_id CONSTANT NUMBER := 38;
94 name CONSTANT NUMBER := 39;
95 destination_type CONSTANT NUMBER := 40;
96 return_to CONSTANT NUMBER := 41;
97 employee CONSTANT NUMBER := 42;
98 operation_code CONSTANT NUMBER := 45;
99 plan_type CONSTANT NUMBER := 46;
100 department_class CONSTANT NUMBER := 48;
101 qa_last_update_date CONSTANT NUMBER := 49;
102 qa_last_updated_by_name CONSTANT NUMBER := 50;
103 qa_creation_date CONSTANT NUMBER := 51;
104 item_description CONSTANT NUMBER := 52;
105 transaction_type CONSTANT NUMBER := 53;
106
107 comp_item CONSTANT NUMBER := 60;
108 comp_uom CONSTANT NUMBER := 62;
109 comp_revision CONSTANT NUMBER := 63;
110 comp_subinventory CONSTANT NUMBER := 64;
111 comp_locator CONSTANT NUMBER := 65;
112 comp_lot_number CONSTANT NUMBER := 66;
113 comp_serial_number CONSTANT NUMBER := 67;
114 customer_description CONSTANT NUMBER := 68;
115 supplier_description CONSTANT NUMBER := 69;
116 po_receipt_date CONSTANT NUMBER := 71;
117 po_shipped_date CONSTANT NUMBER := 72;
118 po_packing_slip CONSTANT NUMBER := 73;
119 received_by CONSTANT NUMBER := 74;
120 freight_carrier CONSTANT NUMBER := 75;
121 num_of_containers CONSTANT NUMBER := 76;
122 order_type CONSTANT NUMBER := 77;
123 ordered_quantity CONSTANT NUMBER := 78;
124 expected_receipt_date CONSTANT NUMBER := 79;
125 vender_item_number CONSTANT NUMBER := 80;
126 vendor_item_number CONSTANT NUMBER := 80;
127 -- charid 80 twice purposefully
128 -- to take care of seed115 typo
129 -- now can use either spelling in my code
130
131 hazard_class CONSTANT NUMBER := 81;
132 un_number CONSTANT NUMBER := 82;
133 po_routing_name CONSTANT NUMBER := 83;
134
135 defect_code CONSTANT NUMBER := 100;
136 to_department CONSTANT NUMBER := 107;
137 to_operation_code CONSTANT NUMBER := 108;
138 requestor CONSTANT NUMBER := 109;
139 po_release_num CONSTANT NUMBER := 110;
140 parent_quantity CONSTANT NUMBER := 111;
141 uom_name CONSTANT NUMBER := 112;
142 insp_reason_code CONSTANT NUMBER := 113;
143 insp_supplier_lot CONSTANT NUMBER := 114;
144 asl_status CONSTANT NUMBER := 115;
145
146 project_number CONSTANT NUMBER := 121;
147 task_number CONSTANT NUMBER := 122;
148 job_complete CONSTANT NUMBER := 123;
149 avail_to_complete CONSTANT NUMBER := 124;
150 vendor_site_code CONSTANT NUMBER := 130;
151 build_sequence CONSTANT NUMBER := 133;
152 schedule_number CONSTANT NUMBER := 134;
153 schedule_group_name CONSTANT NUMBER := 135;
154 bom_revision CONSTANT NUMBER := 136;
155 bom_revision_date CONSTANT NUMBER := 137;
156 routing_revision CONSTANT NUMBER := 138;
157 routing_revision_date CONSTANT NUMBER := 139;
158 accounting_class CONSTANT NUMBER := 140;
159 demand_class CONSTANT NUMBER := 141;
160 scrap_account_alias CONSTANT NUMBER := 142;
161 scrap_account CONSTANT NUMBER := 143;
162 scrap_op_seq CONSTANT NUMBER := 144;
163 kanban_number CONSTANT NUMBER := 145;
164 ship_to_location CONSTANT NUMBER := 146;
165 item_instance_serial CONSTANT NUMBER := 147; -- Bug 9203907
166 license_plate_number CONSTANT NUMBER := 150;
167 inspection_quantity CONSTANT NUMBER := 151;
168 lot_inspection_qty CONSTANT NUMBER := 152;
169 serial_inspection_qty CONSTANT NUMBER := 153;
170 contract_number CONSTANT NUMBER := 154;
171 contract_line_number CONSTANT NUMBER := 155;
172 deliverable_number CONSTANT NUMBER := 156;
173 intransit_shipment_num CONSTANT NUMBER := 157;
174 rma_line_num CONSTANT NUMBER := 158;
175 customer_item_num CONSTANT NUMBER := 159;
176 source_document_code CONSTANT NUMBER := 160;
177 receipt_source_code CONSTANT NUMBER := 161;
178 asset_group CONSTANT NUMBER := 162;
179 --dgupta: Start R12 EAM Integration. Bug 4345492
180 asset_instance_number CONSTANT NUMBER := 2147483550;
181 --dgupta: End R12 EAM Integration. Bug 4345492
182 asset_number CONSTANT NUMBER := 163;
183 asset_activity CONSTANT NUMBER := 164;
184 work_order CONSTANT NUMBER := 165;
185 step CONSTANT NUMBER := 166;
186 party_name CONSTANT NUMBER := 167;
187
188 -- added the following to include new hardcoded element followup activity, transfer license plate number
189 -- saugupta
190 xfr_license_plate_number CONSTANT NUMBER := 2147483574;
191 followup_activity CONSTANT NUMBER := 2147483575;
192
193 --
194 -- Included the following newly added collection elements
195 -- for ASO project. Existing vacancies in QA_CHARS seed
196 -- are used instead of appending to the maximum CHAR_ID of seed
197 -- rkunchal Thu Jul 25 01:43:48 PDT 2002
198 --
199
200 item_instance CONSTANT NUMBER := 30;
201 service_request CONSTANT NUMBER := 43;
202 maintenance_requirement CONSTANT NUMBER := 44;
203 rework_job CONSTANT NUMBER := 47;
204 counter_name CONSTANT NUMBER := 54;
205 counter_reading CONSTANT NUMBER := 55;
206
207 disposition_source CONSTANT NUMBER := 56;
208 disposition_action CONSTANT NUMBER := 57;
209 disposition CONSTANT NUMBER := 58;
210 disposition_status CONSTANT NUMBER := 59;
211
212 collection_plan CONSTANT NUMBER := 61;
213 installed_base_lot CONSTANT NUMBER := 84;
214
215 inspection_type CONSTANT NUMBER := 87;
216 engineering_approval CONSTANT NUMBER := 88;
217 purchasing_approval CONSTANT NUMBER := 89;
218 qa_approval CONSTANT NUMBER := 90;
219 approval_required CONSTANT NUMBER := 91;
220 approval_confirmed CONSTANT NUMBER := 92;
221 launch_action CONSTANT NUMBER := 93;
222 action_fired CONSTANT NUMBER := 94;
223 launch_workflow CONSTANT NUMBER := 95;
224 mechanic CONSTANT NUMBER := 96;
225 inspector CONSTANT NUMBER := 97;
226 work_order_status CONSTANT NUMBER := 98;
227 due_date CONSTANT NUMBER := 99;
228 operation_status CONSTANT NUMBER := 125;
229 approval_requested CONSTANT NUMBER := 131;
230 disposition_message CONSTANT NUMBER := 132;
231
232 --
233 -- End of inclusions for ASO project
234 -- rkunchal Thu Jul 25 01:43:48 PDT 2002
235 --
236
237 --
238 -- See Bug 588213
239 -- To support the new hardcoded element Maintenance Op Seq Number
240 -- to be used along with Maintenance Workorder
241 -- rkunchal Mon Sep 23 23:46:28 PDT 2002
242 --
243 maintenance_op_seq CONSTANT NUMBER := 199;
244 --
245 -- End of inclusions for Bug 2588213
246 --
247
248 -- Start of inclusions for NCM Hardcode Elements.
249 -- suramasw Thu Oct 31 10:48:59 PST 2002.
250 -- Bug 2449067.
251
252 nonconformance_source CONSTANT NUMBER := 166;
253 nonconform_severity CONSTANT NUMBER := 175;
254 nonconform_priority CONSTANT NUMBER := 176;
255 nonconformance_type CONSTANT NUMBER := 177;
256 nonconformance_code CONSTANT NUMBER := 178;
257 nonconformance_status CONSTANT NUMBER := 183;
258 date_opened CONSTANT NUMBER := 185;
259 date_closed CONSTANT NUMBER := 186;
260 days_to_close CONSTANT NUMBER := 187;
261 lot_status CONSTANT NUMBER := 188;
262 serial_status CONSTANT NUMBER := 189;
263 bill_reference CONSTANT NUMBER := 2147483631;
264 routing_reference CONSTANT NUMBER := 2147483630;
265 concurrent_request_id CONSTANT NUMBER := 2147483629;
266 to_subinventory CONSTANT NUMBER := 2147483628;
267 to_locator CONSTANT NUMBER := 2147483627;
268 receiving_trans_num CONSTANT NUMBER := 2147483621;
269
273
270 -- End of inclusions for NCM Hardcode Elements.
271
272 -- Softcoded Elements for NCM Actions.
274 quantity_nonconforming CONSTANT NUMBER := 168;
275 nonconforming_uom CONSTANT NUMBER := 169;
276 short_description CONSTANT NUMBER := 170;
277 detailed_description CONSTANT NUMBER := 171;
278 email_address CONSTANT NUMBER := 179;
279 send_email CONSTANT NUMBER := 180;
280 entered_by_user CONSTANT NUMBER := 181;
281 nonconformance_number CONSTANT NUMBER := 182;
282 enter_details CONSTANT NUMBER := 184;
283 process_name CONSTANT NUMBER := 190;
284 process_step CONSTANT NUMBER := 191;
285 nonconform_line_status CONSTANT NUMBER := 192;
286 note_type CONSTANT NUMBER := 193;
287 notes CONSTANT NUMBER := 194;
288 action_executed CONSTANT NUMBER := 195;
289 action_executed_by CONSTANT NUMBER := 196;
290 action_type CONSTANT NUMBER := 197;
291 action_description CONSTANT NUMBER := 198;
292 Action_Assigned_To CONSTANT NUMBER := 2147483620;
293 source_reference_id CONSTANT NUMBER := 2147483647;
294 source_ref_line_id CONSTANT NUMBER := 2147483646;
295 disposition_number CONSTANT NUMBER := 2147483645;
296 disposition_quantity CONSTANT NUMBER := 2147483644;
297 disposition_uom CONSTANT NUMBER := 2147483643;
298 disposition_owner CONSTANT NUMBER := 2147483642;
299 source_owner CONSTANT NUMBER := 2147483641;
300 disposition_desc CONSTANT NUMBER := 2147483640;
301 disposition_line_num CONSTANT NUMBER := 2147483639;
302 disposition_line_desc CONSTANT NUMBER := 2147483638;
303 implementation_by CONSTANT NUMBER := 2147483637;
304 implement_disposition CONSTANT NUMBER := 2147483636;
305 disposition_module CONSTANT NUMBER := 2147483635;
306 job_class CONSTANT NUMBER := 2147483634;
307 job_start_date CONSTANT NUMBER := 2147483633;
308 job_end_date CONSTANT NUMBER := 2147483632;
309 date_required CONSTANT NUMBER := 2147483626;
310 owner_email CONSTANT NUMBER := 2147483625;
311 source_owner_email CONSTANT NUMBER := 2147483624;
312 nonconform_line_num CONSTANT NUMBER := 2147483623;
313 move_order_number CONSTANT NUMBER := 2147483622;
314 new_rework_job CONSTANT NUMBER := 2147483619;
315
316 -- End of inclusions for NCM Actions.
317
318 -- anagarwa Wed Nov 13 16:41:40 PST 2002
319 -- New NCM elements
320 default_values CONSTANT NUMBER := 2147483618;
321 nonconform_item_type CONSTANT NUMBER := 2147483617;
322 rework_op_seq_num CONSTANT NUMBER := 2147483616;
323 rework_operation_code CONSTANT NUMBER := 2147483615;
324 rework_department CONSTANT NUMBER := 2147483614;
325 resource_op_seq_num CONSTANT NUMBER := 2147483613;
326 assigned_units CONSTANT NUMBER := 2147483612;
327 usage_rate CONSTANT NUMBER := 2147483611;
328
329 --anagarwa Thu Nov 14 13:31:42 PST 2002
330 -- Start inclusion for CAR elements
331 request_source CONSTANT NUMBER := 2147483608;
332 request_priority CONSTANT NUMBER := 2147483605;
333 request_severity CONSTANT NUMBER := 2147483604;
334 request_status CONSTANT NUMBER := 2147483601;
335 eco_name CONSTANT NUMBER := 2147483590;
336
337 -- end of CAR elements
338
339 -- Bug 4345779. Audits project.
340 -- Added constants for new audit elements.
341 -- srhariha. Wed Jun 1 12:13:02 PDT 2005.
342
343 internal_auditee_email CONSTANT NUMBER := 2147483525;
344 internal_auditor_email CONSTANT NUMBER := 2147483526;
345 finding_date CONSTANT NUMBER := 2147483527;
346 finding_type CONSTANT NUMBER := 2147483528;
347 audit_finding_num CONSTANT NUMBER := 2147483529;
348 audit_question CONSTANT NUMBER := 2147483530;
349 question_code CONSTANT NUMBER := 2147483531;
350 question_category CONSTANT NUMBER := 2147483532;
351 car_required CONSTANT NUMBER := 2147483533;
352 procedure_compliant CONSTANT NUMBER := 2147483534;
353 procedure_adequate CONSTANT NUMBER := 2147483535;
354 procedure_exists CONSTANT NUMBER := 2147483536;
355 audit_result CONSTANT NUMBER := 2147483537;
356 audit_status CONSTANT NUMBER := 2147483538;
357 audit_area CONSTANT NUMBER := 2147483539;
358 external_auditee CONSTANT NUMBER := 2147483540;
359 external_auditor CONSTANT NUMBER := 2147483541;
360 registrar CONSTANT NUMBER := 2147483542;
361 internal_auditee CONSTANT NUMBER := 2147483543;
362 internal_auditor CONSTANT NUMBER := 2147483544;
363 lead_internal_auditor CONSTANT NUMBER := 2147483545;
364 audit_objective CONSTANT NUMBER := 2147483546;
365 audit_type CONSTANT NUMBER := 2147483547;
366 audit_name CONSTANT NUMBER := 2147483548;
367 audit_num CONSTANT NUMBER := 2147483549;
368 standard_violated CONSTANT NUMBER := 2147483606;
369 section_violated CONSTANT NUMBER := 2147483591;
370 -- End 4345779.
374
371
372
373
375 --
376 -- The following are Quality datatypes
377 --
378
379 character_datatype CONSTANT NUMBER := 1;
380 number_datatype CONSTANT NUMBER := 2;
381 date_datatype CONSTANT NUMBER := 3;
382
383 -- Bug 2427337. Introduced 2 new datatype constants.
384 -- rponnusa Tue Jun 25 06:15:48 PDT 2002
385 comment_datatype CONSTANT NUMBER := 4;
386 sequence_datatype CONSTANT NUMBER := 5;
387 datetime_datatype CONSTANT NUMBER := 6;
388
389 --
390 -- The following are Transaction Numbers that indicate an
391 -- external product integration.
392 --
393
394 wip_move_txn CONSTANT NUMBER := 1;
395 wip_completion_txn CONSTANT NUMBER := 4;
396 po_inspection_txn CONSTANT NUMBER := 21;
397 po_receiving_txn CONSTANT NUMBER := 6;
398 flow_work_order_less_txn CONSTANT NUMBER := 22;
399 cs_service_request_txn CONSTANT NUMBER := 20;
400 ss_outside_processing_txn CONSTANT NUMBER := 100;
401 ss_shipments_txn CONSTANT NUMBER := 110;
402 eam_work_order_txn CONSTANT NUMBER := 31;
403 eam_asset_txn CONSTANT NUMBER := 32;
404 eam_operation_txn CONSTANT NUMBER := 33;
405
406 -- R12 OPM Deviations. Bug 4345503 Start
407 process_nc_txn CONSTANT NUMBER := 34;
408 -- R12 OPM Deviations. Bug 4345503 End
409
410 /* R12 DR Integration. Bug 4345489 Start */
411 depot_repair_txn CONSTANT NUMBER := 2005;
412 /* R12 DR Integration. Bug 4345489 End */
413
414 --dgupta: Start R12 EAM Integration. Bug 4345492
415 eam_checkin_txn CONSTANT NUMBER := 2006;
416 eam_checkout_txn CONSTANT NUMBER := 2007;
417 --dgupta: End R12 EAM Integration. Bug 4345492
418
419 /* R12 OAF Txn Integration . Bug 4343758 */
420 flow_line_op_txn CONSTANT NUMBER := 24;
421 osfm_move_txn CONSTANT NUMBER := 23;
422 /* R12 OAF Txn Integration . Bug 4343758 */
423
424
425 -- Bug 4519558. OA Framework Integration project. UT bug fix.
426 -- Added the following constants.
427 -- srhariha. Tue Aug 2 01:37:53 PDT 2005.
428
429 -- Bug 4519558.OA Framework Integration project. UT bug fix.
430 -- Incorporating Bryan's code review comments. Replace prefix
431 -- 'mob' with 'msca'.
432 -- Mobile transaction number range : [1001 - 1999]
433 -- srhariha. Mon Aug 22 02:50:35 PDT 2005.
434
435
436 msca_move_txn CONSTANT NUMBER := 1001;
437 msca_scrap_reject_txn CONSTANT NUMBER := 1002;
438 msca_return_txn CONSTANT NUMBER := 1003;
439 msca_completion_txn CONSTANT NUMBER := 1004;
440 msca_wo_less_txn CONSTANT NUMBER := 1005;
441 msca_flow_txn CONSTANT NUMBER := 1006;
442 msca_material_txn CONSTANT NUMBER := 1007;
443 msca_move_and_complete_txn CONSTANT NUMBER := 1008;
444 msca_return_and_move_txn CONSTANT NUMBER := 1009;
445 msca_ser_move_txn CONSTANT NUMBER := 1011;
446 msca_ser_scrap_rej_txn CONSTANT NUMBER := 1012;
447 msca_ser_return_txn CONSTANT NUMBER := 1013;
448 msca_ser_completion_txn CONSTANT NUMBER := 1014;
449 msca_ser_material_txn CONSTANT NUMBER := 1017;
450 msca_ser_move_and_comp_txn CONSTANT NUMBER := 1018;
451 msca_ser_return_and_move_txn CONSTANT NUMBER := 1019;
452 wma_lpn_inspection_txn CONSTANT NUMBER := 1021;
453 msca_recv_inspection_txn CONSTANT NUMBER := 1022;
454 wms_lpn_based_txn CONSTANT NUMBER := 1041;
455
456 mob_txn_lookup_prefix CONSTANT VARCHAR2(15) := 'QA_TXN_TYPE_';
457 -- End 4519558.
458
459 --
460 -- The following are Quality Action numbers.
461 --
462
463 display_message_action CONSTANT NUMBER := 1;
464 reject_input_action CONSTANT NUMBER := 2;
465 send_email_action CONSTANT NUMBER := 10;
466 exec_sql_action CONSTANT NUMBER := 11;
467 exec_script_action CONSTANT NUMBER := 12;
468 launch_request_action CONSTANT NUMBER := 13;
469 post_action_log_action CONSTANT NUMBER := 15;
470 place_job_on_hold_action CONSTANT NUMBER := 16;
471 assign_shop_floor_action CONSTANT NUMBER := 17;
472 assign_lot_status_action CONSTANT NUMBER := 18;
473 assign_serial_status_action CONSTANT NUMBER := 19;
474 assign_item_status_action CONSTANT NUMBER := 20;
475 place_supplier_on_hold_action CONSTANT NUMBER := 21;
476 place_document_on_hold_action CONSTANT NUMBER := 22;
477 hold_all_schedules_action CONSTANT NUMBER := 23;
478 assign_value_action CONSTANT NUMBER := 24;
479 accept_shipment_action CONSTANT NUMBER := 25;
480 reject_shipment_action CONSTANT NUMBER := 26;
481 assign_asl_status_action CONSTANT NUMBER := 27;
482 launch_workflow_action CONSTANT NUMBER := 28;
483
484 -- Bug 4305107. Introduced send notification to element
485 -- shkalyan Apr-21-2005
486 send_notification_to CONSTANT NUMBER := 2147483577;
487
488 -- R12 ERES Support in Service Family. Bug 4345768 Start
489 esignature_status CONSTANT NUMBER := 2147483572;
490 -- R12 ERES Support in Service Family. Bug 4345768 End
491
492 -- R12 OPM Deviations. Bug 4345503 Start
493 process_batch_num CONSTANT NUMBER := 2147483556;
494 process_batchstep_num CONSTANT NUMBER := 2147483555;
498 process_parameter CONSTANT NUMBER := 2147483551;
495 process_operation CONSTANT NUMBER := 2147483554;
496 process_activity CONSTANT NUMBER := 2147483553;
497 process_resource CONSTANT NUMBER := 2147483552;
499 -- R12 OPM Deviations. Bug 4345503 End
500
501 /* R12 DR Integration. Bug 4345489 Start */
502 repair_order_number CONSTANT NUMBER := 2147483558;
503 jtf_task_number CONSTANT NUMBER := 2147483557;
504 /* R12 DR Integration. Bug 4345489 End */
505 --
506 -- Some max values
507 --
508
509 -- Max. # of coll. elements, useful as hash function. Need this
510 -- no. to avoid hash collision.
511 max_elements CONSTANT NUMBER := 100000;
512
513 --
514 -- Release management requires a procedure. We will
515 -- supply an empty dummy procedure here.
516 --
517
518 procedure dummy1;
519
520 --
521 -- Bug 4635316
522 -- Introduced constants for Global parameters Org_Id and User_Id
523 -- which would be used in the package "qa_validation_api", file qltvalb.plb,
524 -- to be replaced with the bind variables,in the string containing the
525 -- sql text, used to assign a value to an element, in an action.
526 -- Also introduced are the constants for the respetive Bind variables
527 -- ntungare Thu Oct 6 21:52:39 PDT 2005
528 --
529 global_param_org_id CONSTANT VARCHAR2(20) := ':PARAMETER.ORG_ID';
530 global_param_user_id CONSTANT VARCHAR2(20) := ':PARAMETER.USER_ID';
531 bindvar_param_org_id CONSTANT VARCHAR2(20) := ':PARAMETER_ORG_ID';
532 bindvar_param_user_id CONSTANT VARCHAR2(20) := ':PARAMETER_USER_ID';
533
534 --
535 -- Tracking Bug 4697145
536 -- MOAC Upgrade feature. One seeded template plan is
537 -- dedicated to signal a JRad regeneration in the future.
538 -- See Bug text for info.
539 -- bso Sun Nov 6 16:52:53 PST 2005
540 --
541 jrad_upgrade_plan CONSTANT NUMBER := 1;
542
543
544 --
545 -- Tracking Bug 4939897
546 -- R12 Forms Upgrade - Obsolete Graphics.
547 -- bso Tue Feb 7 15:38:53 PST 2006
548 --
549 output_type_pareto CONSTANT NUMBER := 1;
550 output_type_trend CONSTANT NUMBER := 2;
551 output_type_report CONSTANT NUMBER := 3;
552 output_type_stats CONSTANT NUMBER := 4;
553 output_type_control CONSTANT NUMBER := 5;
554 output_type_histogram CONSTANT NUMBER := 6;
555
556 control_chart_XBarR CONSTANT NUMBER := 1;
557 control_chart_XmR CONSTANT NUMBER := 2;
558 control_chart_XBarS CONSTANT NUMBER := 3;
559 control_chart_mXmR CONSTANT NUMBER := 4;
560
561 chart_function_sum CONSTANT NUMBER := 1;
562 chart_function_count CONSTANT NUMBER := 2;
563 chart_function_average CONSTANT NUMBER := 3;
564 chart_function_min CONSTANT NUMBER := 4;
565 chart_function_max CONSTANT NUMBER := 5;
566
567 --
568 -- R12 performance fix. Added constant for few date chars.
569 -- srhariha. Thu Feb 16 22:38:26 PST 2006
570 --
571
572 expected_resolution_date CONSTANT NUMBER := 128;
573 actual_resolution_date CONSTANT NUMBER := 129;
574 approval_date CONSTANT NUMBER := 2147483598;
575 follow_up_date CONSTANT NUMBER := 2147483600;
576
577
578 END qa_ss_const;
579