1 PACKAGE qa_web_txn_api AS
2 /* $Header: qlttxnwb.pls 120.3 2005/08/22 05:51:06 srhariha noship $ */
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 FUNCTION allowed_for_plan ( p_function_name IN VARCHAR2, p_plan_id IN NUMBER)
43 RETURN VARCHAR2;
44
45 FUNCTION plan_applies ( p_plan_id IN NUMBER,
46 p_txn_number IN NUMBER DEFAULT NULL,
47 p_org_id IN NUMBER DEFAULT NULL,
48 pk1 IN VARCHAR2 DEFAULT NULL,
49 pk2 IN VARCHAR2 DEFAULT NULL,
50 pk3 IN VARCHAR2 DEFAULT NULL,
51 pk4 IN VARCHAR2 DEFAULT NULL,
52 pk5 IN VARCHAR2 DEFAULT NULL,
53 pk6 IN VARCHAR2 DEFAULT NULL,
54 pk7 IN VARCHAR2 DEFAULT NULL,
55 pk8 IN VARCHAR2 DEFAULT NULL,
56 pk9 IN VARCHAR2 DEFAULT NULL,
57 pk10 IN VARCHAR2 DEFAULT NULL,
58 p_txn_name IN VARCHAR2 DEFAULT NULL)
59 RETURN VARCHAR2;
60
61
62 PROCEDURE quality_post_commit_processing (p_collection_id IN NUMBER,
63 p_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2);
66
67
68 FUNCTION get_mandatory_optional_info (p_plan_id NUMBER, p_txn_number IN NUMBER)
69 RETURN VARCHAR2;
70
71
72 PROCEDURE post_background_results(
73 p_txn_number IN NUMBER,
74 p_org_id IN NUMBER,
75 p_context_values IN VARCHAR2,
76 p_collection_id IN NUMBER);
77
78 --
79 -- Tracking Bug 4343758. Fwk Integration.
80 -- Currently there is no simple metamodel to look up
81 -- which transactions are enabled for Workbench.
82 -- So, we do a hard check here. When there is
83 -- datamodel available, this can be changed to
84 -- select from the db.
85 --
86 -- Return fnd_api.g_true if p_txn is enabled for OAF
87 -- transaction integration; else fnd_api.g_false.
88 -- bso Fri May 20 14:01:25 PDT 2005
89 --
90 --
91 FUNCTION is_workbench_txn(p_txn IN NUMBER) RETURN VARCHAR2;
92
93
94 -- Bug 4343758. Oa Fwk Integration Project.
95 -- New API used to get information on mandatory
96 -- result entry.
97 -- srhariha. Mon May 2 00:33:26 PDT 2005.
98
99 FUNCTION get_result_entered(p_plan_id IN NUMBER,
100 p_collection_id IN NUMBER)
101 RETURN VARCHAR2;
102
103 -- Bug 4519559. Oa Fwk Integration Project. UT bug fix.
104 -- Return fnd_api.g_true if p_txn is a mobile txn
105 -- else return fnd_api.g_false
106 -- srhariha. Tue Aug 2 01:37:53 PDT 2005
107
108 -- Bug 4519558.OA Framework Integration project. UT bug fix.
109 -- Incorporating Bryan's code review comments. Moved the
110 -- method to qa_mqa_mwa_api package.
111 -- srhariha. Mon Aug 22 02:50:35 PDT 2005.
112
113 -- FUNCTION is_mobile_txn(p_txn IN NUMBER) RETURN VARCHAR2;
114
115 END qa_web_txn_api;
[Home] [Help]