1 PACKAGE qa_web_txn_api AUTHID CURRENT_USER AS
2 /* $Header: qlttxnwb.pls 120.3.12020000.2 2013/03/28 05:29:52 ntungare ship $ */
3
4 FUNCTION quality_plans_applicable (p_txn_number IN NUMBER,
5 p_organization_id IN NUMBER DEFAULT NULL,
6 pk1 IN VARCHAR2 DEFAULT NULL,
7 pk2 IN VARCHAR2 DEFAULT NULL,
8 pk3 IN VARCHAR2 DEFAULT NULL,
9 pk4 IN VARCHAR2 DEFAULT NULL,
10 pk5 IN VARCHAR2 DEFAULT NULL,
11 pk6 IN VARCHAR2 DEFAULT NULL,
12 pk7 IN VARCHAR2 DEFAULT NULL,
13 pk8 IN VARCHAR2 DEFAULT NULL,
14 pk9 IN VARCHAR2 DEFAULT NULL,
15 pk10 IN VARCHAR2 DEFAULT NULL,
16 p_txn_name IN VARCHAR2 DEFAULT NULL)
17 RETURN VARCHAR2;
18
19
20 FUNCTION quality_mandatory_plans_remain (p_txn_number IN NUMBER,
21 p_organization_id IN NUMBER DEFAULT NULL,
22 pk1 IN VARCHAR2 DEFAULT NULL,
23 pk2 IN VARCHAR2 DEFAULT NULL,
24 pk3 IN VARCHAR2 DEFAULT NULL,
25 pk4 IN VARCHAR2 DEFAULT NULL,
26 pk5 IN VARCHAR2 DEFAULT NULL,
27 pk6 IN VARCHAR2 DEFAULT NULL,
28 pk7 IN VARCHAR2 DEFAULT NULL,
29 pk8 IN VARCHAR2 DEFAULT NULL,
30 pk9 IN VARCHAR2 DEFAULT NULL,
31 pk10 IN VARCHAR2 DEFAULT NULL,
32 p_txn_name IN VARCHAR2 DEFAULT NULL,
33 p_list_of_plans IN VARCHAR2 DEFAULT NULL,
34 p_collection_id IN NUMBER DEFAULT NULL,
35 p_wip_entity_id IN NUMBER DEFAULT NULL)
36 RETURN VARCHAR2;
37
38
39 FUNCTION background_plan ( p_plan_id IN NUMBER, p_txn_number IN NUMBER)
40 RETURN VARCHAR2;
41
42 --
43 -- Bug 16263093
44 -- Made the function deterministic to improve performance
45 --
46 FUNCTION allowed_for_plan ( p_function_name IN VARCHAR2, p_plan_id IN NUMBER)
47 RETURN VARCHAR2 DETERMINISTIC;
48
49 FUNCTION plan_applies ( p_plan_id IN NUMBER,
50 p_txn_number IN NUMBER DEFAULT NULL,
51 p_org_id IN NUMBER DEFAULT NULL,
52 pk1 IN VARCHAR2 DEFAULT NULL,
53 pk2 IN VARCHAR2 DEFAULT NULL,
54 pk3 IN VARCHAR2 DEFAULT NULL,
55 pk4 IN VARCHAR2 DEFAULT NULL,
56 pk5 IN VARCHAR2 DEFAULT NULL,
57 pk6 IN VARCHAR2 DEFAULT NULL,
58 pk7 IN VARCHAR2 DEFAULT NULL,
59 pk8 IN VARCHAR2 DEFAULT NULL,
60 pk9 IN VARCHAR2 DEFAULT NULL,
61 pk10 IN VARCHAR2 DEFAULT NULL,
62 p_txn_name IN VARCHAR2 DEFAULT NULL)
63 RETURN VARCHAR2;
64
65
66 PROCEDURE quality_post_commit_processing (p_collection_id IN NUMBER,
67 p_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2);
70
71
72 FUNCTION get_mandatory_optional_info (p_plan_id NUMBER, p_txn_number IN NUMBER)
73 RETURN VARCHAR2;
74
75
76 PROCEDURE post_background_results(
77 p_txn_number IN NUMBER,
78 p_org_id IN NUMBER,
79 p_context_values IN VARCHAR2,
80 p_collection_id IN NUMBER);
81
82 --
83 -- Tracking Bug 4343758. Fwk Integration.
84 -- Currently there is no simple metamodel to look up
85 -- which transactions are enabled for Workbench.
86 -- So, we do a hard check here. When there is
87 -- datamodel available, this can be changed to
88 -- select from the db.
89 --
90 -- Return fnd_api.g_true if p_txn is enabled for OAF
91 -- transaction integration; else fnd_api.g_false.
92 -- bso Fri May 20 14:01:25 PDT 2005
93 --
94 --
95 FUNCTION is_workbench_txn(p_txn IN NUMBER) RETURN VARCHAR2;
96
97
98 -- Bug 4343758. Oa Fwk Integration Project.
99 -- New API used to get information on mandatory
100 -- result entry.
101 -- srhariha. Mon May 2 00:33:26 PDT 2005.
102
103 FUNCTION get_result_entered(p_plan_id IN NUMBER,
104 p_collection_id IN NUMBER)
105 RETURN VARCHAR2;
106
107 -- Bug 4519559. Oa Fwk Integration Project. UT bug fix.
108 -- Return fnd_api.g_true if p_txn is a mobile txn
109 -- else return fnd_api.g_false
110 -- srhariha. Tue Aug 2 01:37:53 PDT 2005
111
112 -- Bug 4519558.OA Framework Integration project. UT bug fix.
113 -- Incorporating Bryan's code review comments. Moved the
114 -- method to qa_mqa_mwa_api package.
115 -- srhariha. Mon Aug 22 02:50:35 PDT 2005.
116
117 -- FUNCTION is_mobile_txn(p_txn IN NUMBER) RETURN VARCHAR2;
118
119 END qa_web_txn_api;
[Home] [Help]