[Home] [Help]
PACKAGE: APPS.QA_SSQR_JRAD_PKG
Source
1 PACKAGE qa_ssqr_jrad_pkg AUTHID CURRENT_USER AS
2 /* $Header: qajrmps.pls 120.4.12010000.1 2008/07/25 09:19:47 appldev ship $ */
3
4
5 -- 12.1 Inline Region in MES
6 -- saugupta Mon, 20 Aug 2007 03:07:40 -0700 PDT
7 g_pkg_name CONSTANT varchar2(100) := 'QA_SSQR_JRAD_PKG.';
8 /* g_debug_mode could be FND_LOG or QA_LOCAL default is FND_LOG */
9 g_debug_mode varchar2(10) := 'FND_LOG';
10 g_eqr_advtable_layout CONSTANT varchar2(100) := 'EQR_ADV_TABLE';
11 g_eqr_adv_table_prefix CONSTANT VARCHAR2(25) := 'QA_SSQR_ADV_TABLE_';
12
13 --
14 -- MOAC Project. 4637896
15 -- New constants.
16 -- srhariha. Tue Oct 11 04:22:16 PDT 2005.
17 --
18 g_jrad_lov_dir_path CONSTANT VARCHAR2(50)
19 := '/oracle/apps/qa/ssqr/lov/webui/';
20
21 -- jrad paths
22 g_jrad_region_path CONSTANT VARCHAR2(50)
23 := '/oracle/apps/qa/regions/';
24 g_jrad_lov_path CONSTANT VARCHAR2(50)
25 := '/oracle/apps/qa/ssqr/lov/webui/QaLovRN';
26 g_vo_name CONSTANT VARCHAR2(30) := 'QualityResultsVO';
27
28
29
30 -- special items added to a plan data region
31 -- for EQR
32 g_org_id_attribute CONSTANT VARCHAR2(20) := 'QASPORGID';
33 g_plan_id_attribute CONSTANT VARCHAR2(20) := 'QASPPLANID';
34 -- for VQR
35 g_qa_created_by_attribute CONSTANT VARCHAR2(20) := 'QASPQACREATEDBY';
36 g_collection_id_attribute CONSTANT VARCHAR2(20) := 'QASPCOLLECTIONID';
37 g_last_update_date_attribute CONSTANT VARCHAR2(20) := 'QASPLASTUPDATEDATE';
38 -- Attachments
39 g_multi_row_attachment CONSTANT VARCHAR2(20) := 'AK_ATTACHMENT_IMAGE';
40 g_attachment_entity CONSTANT VARCHAR2(20) := 'QA_RESULTS';
41
42
43 -- Layout modes
44 g_eqr_single_layout CONSTANT VARCHAR2(20) := 'EQR_SINGLE';
45 g_vqr_single_layout CONSTANT VARCHAR2(20) := 'VQR_SINGLE';
46 g_eqr_multiple_layout CONSTANT VARCHAR2(20) := 'EQR_MULTIPLE';
47
48
49
50 -- LOV and PopList
51 g_lov_attribute_code CONSTANT VARCHAR2(20) := 'QaLovCode';
52 g_lov_attribute_description CONSTANT VARCHAR2(20) := 'QaLovDesc';
53 g_lov_attribute_org_id CONSTANT VARCHAR2(20) := 'QaLovOrgId';
54 g_lov_attribute_plan_id CONSTANT VARCHAR2(20) := 'QaLovPlanId';
55 g_lov_attribute_dependency CONSTANT VARCHAR2(20) := 'DEPEN';
56
57 g_pop_vo_prefix CONSTANT VARCHAR2(20) := 'QaPoplist';
58 g_pop_display_column CONSTANT VARCHAR2(20) := 'DESCRIPTION';
59 g_pop_value_column CONSTANT VARCHAR2(20) := 'SHORT_CODE';
60
61
62 -- long comments
63 g_comments_height CONSTANT NUMBER := 5;
64 g_comments_width CONSTANT NUMBER := 80;
65 g_comments_max_len CONSTANT NUMBER := 2000;
66
67
68 -- Char datatypes
69 g_char_datatype CONSTANT NUMBER := 1;
70 g_num_datatype CONSTANT NUMBER := 2;
71 g_date_datatype CONSTANT NUMBER := 3;
72 g_comments_datatype CONSTANT NUMBER := 4;
73 g_seq_datatype CONSTANT NUMBER := 5;
74 g_datetime_datatype CONSTANT NUMBER := 6;
75
76
77 -- Data entry hints
78 g_tip_type CONSTANT VARCHAR2(20) := 'longMessage';
79 g_tip_message_name CONSTANT VARCHAR2(20) := 'QA_DATA_HINT_CHARID';
80 g_app_short_name CONSTANT VARCHAR2(20) := 'QA';
81 g_long_tip_region CONSTANT VARCHAR2(200) := '/oracle/apps/qa/ssqr/webui/QaLongTipRN';
82
83
84 -- prefixes for SSQR regions
85
86 g_element_prefix CONSTANT VARCHAR2(10) := 'CHARID';
87 g_dtl_element_prefix CONSTANT VARCHAR2(10) := 'DTLCHARID';
88
89 g_eqr_single_prefix CONSTANT VARCHAR2(25) := 'QA_SSQR_E_SING_';
90 g_eqr_data_prefix CONSTANT VARCHAR2(25) := 'QA_SSQR_E_DATA_';
91 g_eqr_comments_prefix CONSTANT VARCHAR2(25) := 'QA_SSQR_E_CMNT_';
92
93 g_vqr_single_prefix CONSTANT VARCHAR2(25) := 'QA_SSQR_V_SING_';
94 g_vqr_data_prefix CONSTANT VARCHAR2(25) := 'QA_SSQR_V_DATA_';
95 g_vqr_comments_prefix CONSTANT VARCHAR2(25) := 'QA_SSQR_V_CMNT_';
96
97 g_eqr_multiple_prefix CONSTANT VARCHAR2(25) := 'QA_SSQR_E_MULT_';
98 g_eqr_mult_dtl_prefix CONSTANT VARCHAR2(25) := 'QA_SSQR_E_MDTL_';
99
100 g_ncm CONSTANT VARCHAR2(25) := 'N_';
101 g_car CONSTANT VARCHAR2(25) := 'C_';
102 g_ora_data_text CONSTANT VARCHAR2(25) := 'OraDataText';
103
104 -- 12.1 Device Integration Project
105 -- Global Constants.
106 -- bhsankar Wed Oct 24 04:45:16 PDT 2007
107 g_eqr_device_prefix CONSTANT VARCHAR2(25) := 'QA_SSQR_E_DEVI_';
108 g_device_element_suffix CONSTANT VARCHAR2(25) := 'CHK';
109 g_eqr_mult_data_prefix CONSTANT VARCHAR2(25) := 'QA_SSQR_E_MDAT_';
110
111 -- 12.1 QWB Usability Project
112 -- Global Constants for Export Page
113 g_vqr_multiple_prefix CONSTANT VARCHAR2(25) := 'QA_SSQR_V_MULT_';
114 g_vqr_mult_dtl_prefix CONSTANT VARCHAR2(25) := 'QA_SSQR_V_MDTL_';
115 g_export_vo_name CONSTANT VARCHAR2(30) := 'ResultExportVO';
116 g_vqr_multiple_layout CONSTANT VARCHAR2(20) := 'VQR_MULTIPLE';
117
118
119 PROCEDURE map_plan (p_plan_id IN NUMBER);
120
121 PROCEDURE map_on_demand (p_plan_id IN NUMBER);
122
123 --
124 -- Bug 4697145
125 -- MOAC upgrade needs to delete JRad region. But this procedure
126 -- is generic to be used by other projects.
127 -- No longer used by MOAC. But this is generic, therefore leaving.
128 -- bso Sun Nov 6 16:53:56 PST 2005
129 --
130 PROCEDURE delete_plan_jrad_region(p_plan_id IN NUMBER);
131
132 --
133 -- Tracking Bug 4697145
134 -- MOAC Upgrade feature to indicate this plan has
135 -- been regenerated and on demand mapping can skip.
136 -- bso Sun Nov 6 16:52:53 PST 2005
137 --
138 PROCEDURE jrad_upgraded(p_plan_id IN NUMBER);
139
140 END qa_ssqr_jrad_pkg;
141