[Home] [Help]
PACKAGE: APPS.QA_JRAD_PKG
Source
1 PACKAGE qa_jrad_pkg AS
2 /* $Header: qajrads.pls 120.1.12000000.1 2007/01/19 07:09:15 appldev ship $ */
3
4
5 g_element_prefix CONSTANT VARCHAR2(10) := 'CHARID';
6 g_special_prefix CONSTANT VARCHAR2(10) := 'QASP';
7
8 g_jrad_region_path CONSTANT VARCHAR2(50)
9 := '/oracle/apps/qa/regions/';
10
11 g_jrad_lov_path CONSTANT VARCHAR2(50)
12 := '/oracle/apps/qa/lov/webui/QaLovRN';
13
14 g_vqr_prefix CONSTANT VARCHAR2(10) := 'QAVQR';
15
16 g_osp_vqr_prefix CONSTANT VARCHAR2(10) := 'QAVQROSP';
17 g_ship_vqr_prefix CONSTANT VARCHAR2(10) := 'QAVQRSHP';
18 g_om_vqr_prefix CONSTANT VARCHAR2(10) := 'QAVQROMP';
19
20 --Parent-Child
21 g_pc_vqr_prefix CONSTANT VARCHAR2(10) := 'QAVQRPCH';
22 g_pc_vqr_hdr_region CONSTANT VARCHAR2(20) := 'QA_PC_RES_VQR_HDR';
23 g_child_url_attribute CONSTANT VARCHAR2(20) := 'QASPCHILDURL';
24 g_pc_vqr_sin_prefix CONSTANT VARCHAR2(10) := 'QAVQRSIN';
25 g_vqr_all_elements_url CONSTANT VARCHAR2(30)
26 := 'QA_PC_STATIC_LINK';
27
28 g_txn_osp_prefix CONSTANT VARCHAR2(10) := 'QAPLOSP';
29 g_txn_ship_prefix CONSTANT VARCHAR2(10) := 'QAPLSHP';
30
31 g_eqr_top_region CONSTANT VARCHAR2(20) := 'QAEQRHDR';
32 g_vqr_top_region CONSTANT VARCHAR2(20) := 'QAVQRHDR';
33 g_lov_region CONSTANT VARCHAR2(20) := 'QALOVREGION';
34
35 g_org_id_attribute CONSTANT VARCHAR2(20) := 'QASPORGID';
36 g_org_code_attribute CONSTANT VARCHAR2(20) := 'QASPORGCODE';
37 g_plan_id_attribute CONSTANT VARCHAR2(20) := 'QASPPLANID';
38 g_plan_name_attribute CONSTANT VARCHAR2(20) := 'QASPPLANNAME';
39 g_process_status_attribute CONSTANT VARCHAR2(20) := 'QASPPROCSTATUS';
40 g_source_code_attribute CONSTANT VARCHAR2(20) := 'QASPSOURCECODE';
41 g_source_line_id_attribute CONSTANT VARCHAR2(20) := 'QASPSOURCELINEID';
42 g_po_agent_id_attribute CONSTANT VARCHAR2(20) := 'QASPPOAGENTID';
43
44 g_qa_created_by_attribute CONSTANT VARCHAR2(20) := 'QASPQACREATEDBY';
45 g_collection_id_attribute CONSTANT VARCHAR2(20) := 'QASPCOLLECTIONID';
46 g_last_update_date_attribute CONSTANT VARCHAR2(20) := 'QASPLASTUPDATEDATE';
47
48 g_lov_attribute_code CONSTANT VARCHAR2(20) := 'QaLovCode';
49 g_lov_attribute_description CONSTANT VARCHAR2(20) := 'QaLovDesc';
50 g_lov_attribute_org_id CONSTANT VARCHAR2(20) := 'QaLovOrgId';
51 g_lov_attribute_plan_id CONSTANT VARCHAR2(20) := 'QaLovPlanId';
52 g_lov_attribute_dependency CONSTANT VARCHAR2(20) := 'DEPEN';
53 g_eqr_view_usage_name CONSTANT VARCHAR2(30) := 'QaResultsVO';
54
55 g_vqr_view_usage_name CONSTANT VARCHAR2(30) := 'ViewResultsVO';
56 g_hidden_element_increment CONSTANT NUMBER := 2000;
57 g_application_id CONSTANT NUMBER := 250;
58
59 g_single_row_attachment CONSTANT VARCHAR2(20) := 'AK_ATTACHMENT_LINK';
60 g_multi_row_attachment CONSTANT VARCHAR2(20) := 'AK_ATTACHMENT_IMAGE';
61 g_update_attribute CONSTANT VARCHAR2(20) := 'QASPUPDATE';
62
63 g_txn_work_prefix CONSTANT VARCHAR2(10) := 'QAPLWORK';
64 g_txn_asset_prefix CONSTANT VARCHAR2(10) := 'QAPLASSET';
65 g_txn_op_prefix CONSTANT VARCHAR2(10) := 'QAPLOP';
66 g_work_vqr_prefix CONSTANT VARCHAR2(10) := 'QAVQRWORK';
67 g_asset_vqr_prefix CONSTANT VARCHAR2(10) := 'QAVQRASSET';
68 g_op_vqr_prefix CONSTANT VARCHAR2(10) := 'QAVQROP';
69 --dgupta: Start R12 EAM Integration. Bug 4345492
70 g_checkin_vqr_prefix CONSTANT VARCHAR2(20) := 'QAVQRCHECKIN';
71 g_checkin_eqr_prefix CONSTANT VARCHAR2(20) := 'QAEQRCHECKIN';
72 g_checkout_vqr_prefix CONSTANT VARCHAR2(20) := 'QAVQRCHECKOUT';
73 g_checkout_eqr_prefix CONSTANT VARCHAR2(20) := 'QAEQRCHECKOUT';
74 --dgupta: End R12 EAM Integration. Bug 4345492
75
76 g_eam_eqr_hdr_region CONSTANT VARCHAR2(20) := 'QA_DDE_EQR_TOP';
77 g_eam_vqr_asset_hdr_region CONSTANT VARCHAR2(20) := 'QA_VQR_DATA_HDR';
78 g_eam_vqr_work_hdr_region CONSTANT VARCHAR2(20) := 'QA_VQR_TXN_HDR';
79
80
81
82
83
84
85 PROCEDURE map_plan (p_plan_id IN NUMBER,
86 p_jrad_doc_ver IN NUMBER DEFAULT NULL);
87
88 PROCEDURE map_on_demand (p_plan_id IN NUMBER,
89 x_jrad_doc_ver OUT NOCOPY NUMBER);
90
91
92
93 -- This function is temporarily residing in this package. It will
94 -- get moved to qa_chars_api (qltcharb.pls and qltcharb.plb) very soon.
95
96 FUNCTION context_element (element_id IN NUMBER, txn_number IN NUMBER)
97 RETURN BOOLEAN;
98
99 END qa_jrad_pkg;
100