[Home] [Help]
PACKAGE: APPS.QA_AK_MAPPING_API
Source
1 PACKAGE qa_ak_mapping_api AUTHID CURRENT_USER AS
2 /* $Header: qltakmpb.pls 115.12 2002/11/27 19:21:23 jezheng ship $ */
3
4
5 g_element_appendix CONSTANT VARCHAR2(10) := 'CHARID';
6 g_special_appendix CONSTANT VARCHAR2(10) := 'QASP';
7
8 g_vqr_appendix CONSTANT VARCHAR2(10) := 'QAVQR';
9
10 g_osp_vqr_appendix CONSTANT VARCHAR2(10) := 'QAVQROSP';
11 g_ship_vqr_appendix CONSTANT VARCHAR2(10) := 'QAVQRSHP';
12 g_om_vqr_appendix CONSTANT VARCHAR2(10) := 'QAVQROMP';
13
14 --Parent-Child
15 g_pc_vqr_appendix CONSTANT VARCHAR2(10) := 'QAVQRPCH';
16 g_pc_vqr_hdr_region CONSTANT VARCHAR2(20) := 'QA_PC_RES_VQR_HDR';
17 g_child_url_attribute CONSTANT VARCHAR2(20) := 'QASPCHILDURL';
18 g_pc_vqr_sin_appendix CONSTANT VARCHAR2(10) := 'QAVQRSIN';
19 g_vqr_all_elements_url CONSTANT VARCHAR2(30)
20 := 'QA_PC_STATIC_LINK';
21
22 g_txn_osp_appendix CONSTANT VARCHAR2(10) := 'QAPLOSP';
23 g_txn_ship_appendix CONSTANT VARCHAR2(10) := 'QAPLSHP';
24
25 g_eqr_top_region CONSTANT VARCHAR2(20) := 'QAEQRHDR';
26 g_vqr_top_region CONSTANT VARCHAR2(20) := 'QAVQRHDR';
27 g_lov_region CONSTANT VARCHAR2(20) := 'QALOVREGION';
28
29 g_org_id_attribute CONSTANT VARCHAR2(20) := 'QASPORGID';
30 g_org_code_attribute CONSTANT VARCHAR2(20) := 'QASPORGCODE';
31 g_plan_id_attribute CONSTANT VARCHAR2(20) := 'QASPPLANID';
32 g_plan_name_attribute CONSTANT VARCHAR2(20) := 'QASPPLANNAME';
33 g_process_status_attribute CONSTANT VARCHAR2(20) := 'QASPPROCSTATUS';
34 g_source_code_attribute CONSTANT VARCHAR2(20) := 'QASPSOURCECODE';
35 g_source_line_id_attribute CONSTANT VARCHAR2(20) := 'QASPSOURCELINEID';
36 g_po_agent_id_attribute CONSTANT VARCHAR2(20) := 'QASPPOAGENTID';
37
38 g_qa_created_by_attribute CONSTANT VARCHAR2(20) := 'QASPQACREATEDBY';
39 g_collection_id_attribute CONSTANT VARCHAR2(20) := 'QASPCOLLECTIONID';
40 g_last_update_date_attribute CONSTANT VARCHAR2(20) := 'QASPLASTUPDATEDATE';
41
42 g_lov_attribute_code CONSTANT VARCHAR2(20) := 'QALOVCODE';
43 g_lov_attribute_description CONSTANT VARCHAR2(20) := 'QALOVDESCRIPTION';
44 g_lov_attribute_org_id CONSTANT VARCHAR2(20) := 'QALOVORGID';
45 g_lov_attribute_plan_id CONSTANT VARCHAR2(20) := 'QALOVPLANID';
46 g_lov_attribute_dependency CONSTANT VARCHAR2(20) := 'DEPEN';
47 g_eqr_view_usage_name CONSTANT VARCHAR2(30) := 'QaResultsVO';
48
49 g_vqr_view_usage_name CONSTANT VARCHAR2(30) := 'ViewResultsVO';
50 g_hidden_element_increment CONSTANT NUMBER := 2000;
51 g_application_id CONSTANT NUMBER := 250;
52
53 g_single_row_attachment CONSTANT VARCHAR2(20) := 'AK_ATTACHMENT_LINK';
54 g_multi_row_attachment CONSTANT VARCHAR2(20) := 'AK_ATTACHMENT_IMAGE';
55 g_update_attribute CONSTANT VARCHAR2(20) := 'QASPUPDATE';
56
57 g_txn_work_appendix CONSTANT VARCHAR2(10) := 'QAPLWORK';
58 g_txn_asset_appendix CONSTANT VARCHAR2(10) := 'QAPLASSET';
59 g_txn_op_appendix CONSTANT VARCHAR2(10) := 'QAPLOP';
60 g_work_vqr_appendix CONSTANT VARCHAR2(10) := 'QAVQRWORK';
61 g_asset_vqr_appendix CONSTANT VARCHAR2(10) := 'QAVQRASSET';
62 g_op_vqr_appendix CONSTANT VARCHAR2(10) := 'QAVQROP';
63 g_eam_eqr_hdr_region CONSTANT VARCHAR2(20) := 'QA_DDE_EQR_TOP';
64 g_eam_vqr_asset_hdr_region CONSTANT VARCHAR2(20) := 'QA_VQR_DATA_HDR';
65 g_eam_vqr_work_hdr_region CONSTANT VARCHAR2(20) := 'QA_VQR_TXN_HDR';
66
67
68
69
70 FUNCTION construct_ak_code (p_appendix IN VARCHAR2, p_id IN VARCHAR2)
71 RETURN VARCHAR2;
72
73
74 FUNCTION retrieve_id (p_code IN VARCHAR2)
75 RETURN NUMBER;
76
77
78 FUNCTION get_vo_attribute_name (p_char_id IN NUMBER, p_plan_id IN NUMBER)
79 RETURN VARCHAR2;
80
81
82 PROCEDURE map_element (p_char_id IN NUMBER, p_attribute_application_id IN
83 NUMBER, p_appendix IN VARCHAR2);
84
85
86 PROCEDURE map_plan (p_plan_id IN NUMBER, p_region_application_id IN NUMBER,
87 p_attribute_application_id IN NUMBER);
88
89
90 PROCEDURE delete_element_mapping (p_char_id IN NUMBER,
91 p_attribute_application_id IN NUMBER);
92
93
94 PROCEDURE delete_plan_mapping (p_plan_id IN NUMBER, p_region_application_id
95 IN NUMBER, p_attribute_application_id IN NUMBER);
96
97
98 -- This function is temporarily residing in this package. It will
99 -- get moved to qa_chars_api (qltcharb.pls and qltcharb.plb) very soon.
100
101 FUNCTION context_element (element_id IN NUMBER, txn_number IN NUMBER)
102 RETURN BOOLEAN;
103
104 END qa_ak_mapping_api;
105