1 PACKAGE AHL_QA_RESULTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVQARS.pls 115.3 2002/12/02 23:42:47 jeli noship $ */
3
4 TYPE qa_results_rec_type IS RECORD
5 (
6 CHAR_ID NUMBER, -- QA_CHARS.char_id
7 RESULT_VALUE VARCHAR2(2000), -- User Entered value
8 RESULT_ID NUMBER -- Future Use ( if IDs need to be submitted )
9 );
10
11 TYPE qa_results_tbl_type IS TABLE OF qa_results_rec_type INDEX BY BINARY_INTEGER;
12
13 TYPE occurrence_rec_type IS RECORD
14 (
15 ELEMENT_COUNT NUMBER,
16 OCCURRENCE NUMBER -- QA_RESULTS.occurrence
17 );
18
19 TYPE occurrence_tbl_type IS TABLE OF occurrence_rec_type INDEX BY BINARY_INTEGER;
20
21 TYPE qa_context_rec_type IS RECORD
22 (
23 NAME VARCHAR2(30), -- Name of the attribute ( ahl_wo_id )
24 VALUE VARCHAR2(2000) -- Value of the attribute (String value )
25 );
26
27 TYPE qa_context_tbl_type IS TABLE OF qa_context_rec_type INDEX BY BINARY_INTEGER;
28
29 -- Start of Comments
30 -- Procedure name : submit_qa_results
31 -- Type : Private
32 -- Pre-reqs :
33 -- Function :
34 -- Parameters :
35 --
36 -- Standard IN Parameters :
37 -- p_api_version NUMBER Required
38 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
39 -- p_commit VARCHAR2 Default FND_API.G_FALSE
40 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
41 -- p_default VARCHAR2 Default FND_API.G_TRUE
42 -- p_module_type VARCHAR2 Default NULL
43 --
44 -- Standard OUT Parameters :
45 -- x_return_status VARCHAR2 Required
46 -- x_msg_count NUMBER Required
47 -- x_msg_data VARCHAR2 Required
48 --
49 -- submit_qa_results IN parameters:
50 -- p_plan_id NUMBER Required
51 -- p_organization_id NUMBER Required
52 -- p_transaction_no NUMBER Required
53 -- p_specification_id NUMBER Default NULL
54 -- p_results_tbl qa_results_tbl_type Required
55 -- p_context_tbl qa_context_tbl_type Required
56 -- p_result_commit_flag NUMBER Default 0
57 -- p_id_or_value VARCHAR2 Default 'VALUE'
58 --
59 -- submit_qa_results IN OUT parameters:
60 -- p_x_collection_id NUMBER
61 -- p_x_occurrence_tbl occurrence_tbl_type
62 --
63 -- submit_qa_results OUT parameters:
64 -- None.
65 --
66 --
67 -- Version :
68 -- Current version 1.0
69 --
70 -- End of Comments
71
72 PROCEDURE submit_qa_results
73 (
74 p_api_version IN NUMBER := 1.0,
75 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
76 p_commit IN VARCHAR2 := FND_API.G_FALSE,
77 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78 p_default IN VARCHAR2 := FND_API.G_FALSE,
79 p_module_type IN VARCHAR2 := NULL,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_plan_id IN NUMBER,
84 p_organization_id IN NUMBER,
85 p_transaction_no IN NUMBER,
86 p_specification_id IN NUMBER := NULL,
87 p_results_tbl IN qa_results_tbl_type,
88 p_hidden_results_tbl IN qa_results_tbl_type,
89 p_context_tbl IN qa_context_tbl_type,
90 p_result_commit_flag IN NUMBER,
91 p_id_or_value IN VARCHAR2 := 'VALUE',
92 p_x_collection_id IN OUT NOCOPY NUMBER,
93 p_x_occurrence_tbl IN OUT NOCOPY occurrence_tbl_type
94 );
95
96 PROCEDURE get_char_lov_sql
97 (
98 p_api_version IN NUMBER := 1.0,
99 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
100 p_commit IN VARCHAR2 := FND_API.G_FALSE,
101 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
102 p_default IN VARCHAR2 := FND_API.G_FALSE,
103 p_module_type IN VARCHAR2 := NULL,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_plan_id IN NUMBER,
108 p_char_id IN NUMBER,
109 p_organization_id IN NUMBER,
110 p_user_id IN NUMBER := NULL,
111 p_depen1 IN VARCHAR2 := NULL,
112 p_depen2 IN VARCHAR2 := NULL,
113 p_depen3 IN VARCHAR2 := NULL,
114 p_value IN VARCHAR2 := NULL,
115 x_char_lov_sql OUT NOCOPY VARCHAR2
116 );
117
118 PROCEDURE get_qa_plan
119 (
120 p_api_version IN NUMBER := 1.0,
121 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
122 p_commit IN VARCHAR2 := FND_API.G_FALSE,
123 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124 p_default IN VARCHAR2 := FND_API.G_FALSE,
125 p_module_type IN VARCHAR2 := NULL,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_organization_id IN NUMBER,
130 p_transaction_number IN NUMBER,
131 p_col_trigger_value IN VARCHAR2,
132 x_plan_id OUT NOCOPY NUMBER
133 );
134
135 END AHL_QA_RESULTS_PVT;