1 PACKAGE qa_mqa_mwa_api AUTHID CURRENT_USER AS
2 /* $Header: qamwas.pls 120.1 2005/08/22 06:02:24 srhariha noship $ */
3
4 TYPE PlanTxn IS RECORD (
5 planID NUMBER,
6 planTxnID NUMBER);
7
8 Type PlanTxnTab is TABLE of PlanTxn INDEX BY BINARY_INTEGER;
9
10 Type CtxElemCharIdTab is TABLE of NUMBER;
11
12 TYPE CtxElemId IS RECORD (
13 ID NUMBER DEFAULT NULL);
14
15 Type CtxElemIdTab is TABLE of CtxElemId INDEX BY BINARY_INTEGER;
16
17 --
18 -- Return 1 if the application p_short_name is installed.
19 -- Wrapper to fnd_installation.get_app_info (which, having
20 -- a Boolean return value, is not compatible with current
21 -- JDBC versions.
22 --
23
24 FUNCTION app_installed(p_short_name IN VARCHAR2)
25 RETURN NUMBER;
26
27 --
28 -- Wrapper to enabled API. User is encouraged to use the
29 -- original.
30 --
31 PROCEDURE transaction_completed(collection_id IN NUMBER,
32 commit_flag IN VARCHAR2 DEFAULT 'Y');
33
34
35 PROCEDURE EXPLODE_WMS_LPN(
36 p_lpn_id IN NUMBER,
37 p_org_id IN NUMBER,
38 x_content_table OUT NOCOPY WMS_CONTAINER_PUB.WMS_CONTAINER_TBL_TYPE,
39 x_elements OUT NOCOPY qa_txn_grp.ElementsArray,
40 x_element_ids OUT NOCOPY CtxElemIdTab);
41
42 PROCEDURE evaluate_triggers(
43 p_lpn_id IN NUMBER,
44 p_txn_number IN NUMBER,
45 p_org_id IN NUMBER,
46 x_plan_contexts_str OUT NOCOPY VARCHAR2,
47 x_plan_ctxs_ids_str OUT NOCOPY VARCHAR2,
48 x_plan_txn_ids_str OUT NOCOPY VARCHAR2);
49
50 FUNCTION triggers_matched(
51 p_plan_txn_id IN NUMBER,
52 elements IN qa_txn_grp.ElementsArray) return VARCHAR2;
53 -- Bug 4519558. Oa Fwk Integration Project. UT bug fix.
54 -- Return fnd_api.g_true if p_txn is a mobile txn
55 -- else return fnd_api.g_false.
56 -- Mobile transaction number will come in range (1000,2000)
57 -- srhariha. Mon Aug 22 02:50:35 PDT 2005.
58
59
60 FUNCTION is_mobile_txn(p_txn IN NUMBER) RETURN VARCHAR2;
61
62
63 END qa_mqa_mwa_api;