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