1 PACKAGE qa_results_pub AUTHID CURRENT_USER AS
2 /* $Header: qltpresb.pls 120.2.12010000.1 2008/07/25 09:22:07 appldev ship $ */
3
4
5 TYPE mesg_table IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
6
7 -- Start of comments
8 -- API name : qa_results_pub
9 -- Type : Public
10 -- Function : insert_row
11 -- Pre-reqs : None.
12 -- Parameters :
13 -- IN : p_api_version IN NUMBER Required
14 -- p_init_msg_list IN VARCHAR2 Optional
15 -- Default = FND_API.G_FALSE
16 -- p_commit IN VARCHAR2 Optional
17 -- Default = FND_API.G_FALSE
18 -- p_validation_level IN NUMBER Optional
19 -- Default = FND_API.G_VALID_LEVEL_FULL
20 -- parameter1
21 -- parameter2
22 -- .
23 -- .
24 -- OUT : x_return_status OUT VARCHAR2(1)
25 -- x_msg_count OUT NUMBER
26 -- x_msg_data OUT VARCHAR2(2000)
27 -- parameter1
28 -- parameter2
29 -- .
30 -- .
31 -- Version : Current version 1.0
32 -- previous version None
33 -- Initial version 1.0
34 --
35 -- End of comments
36
37 --
38 -- 12.1 QWB Usability Improvements
39 -- Added a new parameter p_ssqr_operation so that the
40 -- validation is not called while inserting
41 -- rows through the QWB application.
42 --
43 PROCEDURE insert_row (
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46 p_commit IN VARCHAR2 := FND_API.G_FALSE,
47 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48 p_plan_id IN NUMBER,
49 p_spec_id IN NUMBER DEFAULT NULL,
50 p_org_id IN NUMBER,
51 p_transaction_number IN NUMBER DEFAULT NULL,
52 p_transaction_id IN NUMBER DEFAULT NULL,
53 p_who_last_updated_by IN NUMBER := fnd_global.user_id,
54 p_who_created_by IN NUMBER := fnd_global.user_id,
55 p_who_last_update_login IN NUMBER := fnd_global.user_id,
56 p_enabled_flag IN NUMBER,
57 x_collection_id IN OUT NOCOPY NUMBER,
58 x_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 x_occurrence IN OUT NOCOPY NUMBER,
63 x_action_result OUT NOCOPY VARCHAR2,
64 x_message_array OUT NOCOPY qa_validation_api.MessageArray,
65 x_error_array OUT NOCOPY qa_validation_api.ErrorArray,
66 p_txn_header_id IN NUMBER DEFAULT NULL,
67 p_ssqr_operation IN NUMBER DEFAULT NULL,
68 p_last_update_date IN DATE DEFAULT SYSDATE);
69
70 --
71 -- 12.1 QWB Usability Improvements
72 -- Added a new parameter p_ssqr_operation so that the
73 -- validation is not called while updating
74 -- rows through the QWB application.
75 --
76 PROCEDURE update_row (
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79 p_commit IN VARCHAR2 := FND_API.G_FALSE,
80 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81 p_plan_id IN NUMBER,
82 p_spec_id IN NUMBER DEFAULT NULL,
83 p_org_id IN NUMBER,
84 p_transaction_number IN NUMBER DEFAULT NULL,
85 p_transaction_id IN NUMBER DEFAULT NULL,
86 p_who_last_updated_by IN NUMBER := fnd_global.user_id,
87 p_who_created_by IN NUMBER := fnd_global.user_id,
88 p_who_last_update_login IN NUMBER := fnd_global.user_id,
89 p_enabled_flag IN NUMBER,
90 p_collection_id IN NUMBER,
91 p_occurrence IN NUMBER,
92 x_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 x_action_result OUT NOCOPY VARCHAR2,
97 x_message_array OUT NOCOPY qa_validation_api.MessageArray,
98 x_error_array OUT NOCOPY qa_validation_api.ErrorArray,
99 p_txn_header_id IN NUMBER DEFAULT NULL,
100 p_ssqr_operation IN NUMBER DEFAULT NULL,
101 p_last_update_date IN DATE DEFAULT SYSDATE);
102
103
104 PROCEDURE enable_and_fire_action (
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107 p_commit IN VARCHAR2 := FND_API.G_FALSE,
108 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109 p_collection_id IN NUMBER,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2);
113
114
115 PROCEDURE commit_qa_results (
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118 p_commit IN VARCHAR2 := FND_API.G_FALSE,
119 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120 p_collection_id IN NUMBER,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2);
124
125 END qa_results_pub;
126