1 PACKAGE QLTDACTB AUTHID CURRENT_USER as
2 /* $Header: qltdactb.pls 120.3.12010000.1 2008/07/25 09:21:43 appldev ship $ */
3
4 -- 2/8/95 - CREATED
5 -- Kevin Wiggen
6
7 -- This is a serverside package to be run in order to launch actions
8 -- It will check action triggers against data in qa_results and see in any
9 -- actions need to be launched
10
11 -- Changed the signature of DO_ACTIONS procedure for bug 1843356.
12 -- Added P_OCCURRENCE and P_PLAN_ID.
13 -- kabalakr 22 feb 02
14
15 --
16 -- changed all the parameter default value to NULL for
17 -- performance purpose
18 -- jezheng
19 -- Wed Nov 27 15:14:48 PST 2002
20 --
21
22 -- Added X_ARGUMENT in the signature of DO_ACTIONS.
23 -- Bug 3273447. suramasw
24
25 FUNCTION DO_ACTIONS(X_TXN_HEADER_ID NUMBER,
26 X_CONCURRENT NUMBER DEFAULT null,
27 X_PO_TXN_PROCESSOR_MODE VARCHAR2 DEFAULT NULL,
28 X_GROUP_ID NUMBER DEFAULT NULL,
29 X_BACKGROUND BOOLEAN DEFAULT NULL,
30 X_DEBUG BOOLEAN DEFAULT NULL,
31 X_ACTION_TYPE VARCHAR2 DEFAULT NULL ,
32 X_PASSED_ID_NAME VARCHAR2 DEFAULT NULL,
33 P_OCCURRENCE NUMBER DEFAULT NULL,
34 P_PLAN_ID NUMBER DEFAULT NULL,
35 X_ARGUMENT VARCHAR2 DEFAULT NULL)
36 RETURN BOOLEAN;
37
38 PROCEDURE launch_workflow(X_PCA_ID NUMBER,
39 X_WF_ITEMTYPE VARCHAR2,
40 X_PLAN_ID NUMBER,
41 X_WORKFLOW_PROCESSES VARCHAR2);
42
43 PROCEDURE FIRE_ALERT(X_PCA_ID NUMBER);
44
45 PROCEDURE DO_ASSIGNMENT(X_PCA_ID NUMBER,
46 X_MESSAGE VARCHAR2,
47 X_ASSIGNED_CHAR_ID NUMBER,
48 X_COLLECTION_ID NUMBER,
49 X_OCCURRENCE NUMBER,
50 X_PLAN_ID NUMBER,
51 X_SQL_STATEMENT OUT NOCOPY VARCHAR2);
52
53
54 -- Bug 3270283. This procedure takes care of defaulting the receiving
55 -- subinventory and locator values to the transfer LPN from the
56 -- parent LPN. kabalakr Mon Mar 8 08:01:35 PST 2004.
57
58 -- Bug 6781108
59 -- Added the two out parameters and deleted X_TRANSACTION_ID
60 -- from the specification
61 -- pdube Wed Feb 6 04:53:32 PST 2008
62 PROCEDURE DEFAULT_LPN_SUB_LOC_INFO(X_LPN_ID NUMBER,
63 X_XFR_LPN_ID NUMBER,
64 -- X_TRANSACTION_ID NUMBER
65 l_rti_sub_code OUT NOCOPY mtl_secondary_inventories.secondary_inventory_name%TYPE,
66 l_rti_loc_id OUT NOCOPY NUMBER);
67
68 -- 12.1 QWB Usability Improvements
69 -- Function to replace tokens strings defined in
70 -- an action message with Form field names
71 --
72 FUNCTION replace_tokens(p_plan_char_action_id IN NUMBER,
73 p_message_str IN VARCHAR2,
74 p_assign_type IN VARCHAr2,
75 P_assigned_elem_type IN NUMBER)
76 RETURN VARCHAR2;
77
78 -- 12.1 QWB Usability Improvements
79 -- Function to compute the low value for action
80 -- triggers
81 FUNCTION low_val(p_plan_id in NUMBER,
82 p_spec_id in NUMBER,
83 p_char_id in number,
84 p_char_type in number,
85 p_lowval_lookup in NUMBER,
86 p_highval_lookup in NUMBER,
87 p_char_uom in VARCHAR2,
88 p_plan_uom in VARCHAR2,
89 p_precision in NUMBER)
90 RETURN VARCHAR2;
91
92 -- 12.1 QWB Usability Improvements
93 -- Function to compute the high value for Spec
94 -- triggers
95 FUNCTION high_val(p_plan_id in NUMBER,
96 p_spec_id in NUMBER,
97 p_char_id in number,
98 p_char_type in number,
99 p_lowval_lookup in NUMBER,
100 p_highval_lookup in NUMBER,
101 p_char_uom in VARCHAR2,
102 p_plan_uom in VARCHAR2,
103 p_precision in NUMBER)
104 RETURN VARCHAR2;
105
106
107
108
109 END QLTDACTB;
110
111
112