[Home] [Help]
PACKAGE: APPS.AP_WEB_HOLDS_WF
Source
1 PACKAGE AP_WEB_HOLDS_WF AUTHID CURRENT_USER AS
2 /* $Header: apwholdss.pls 120.3 2011/07/15 10:17:52 rveliche ship $ */
3
4
5 ------------------------
6 -- Item Types
7 ------------------------
8 C_APWHOLDS CONSTANT VARCHAR2(8) := 'APWHOLDS';
9
10 ------------------------
11 -- Rules
12 ------------------------
13 C_HOLD_RULE CONSTANT ap_aud_rule_sets.rule_set_type%type := 'HOLD';
14
15 ------------------------
16 -- Hold Codes
17 ------------------------
18 C_HOLD_EACH_CODE CONSTANT ap_aud_rule_sets.hold_code%type := 'UNTIL_RCT_RECEIVED';
19 C_HOLD_EACH CONSTANT ap_aud_rule_sets.hold_code%type := 'EACH';
20 C_HOLD_ALL_CODE CONSTANT ap_aud_rule_sets.hold_code%type := 'RECEIPTS_OVERDUE';
21 C_HOLD_ALL CONSTANT ap_aud_rule_sets.hold_code%type := 'ALL';
22
23 ------------------------
24 -- Both Pay Hold Codes
25 ------------------------
26 C_HOLD_BP_NEVER CONSTANT ap_aud_rule_sets.hold_rct_overdue_bp_cc_code%type := 'NEVER';
27 C_HOLD_BP_REQUIRED CONSTANT ap_aud_rule_sets.hold_rct_overdue_bp_cc_code%type := 'RECEIPTS_REQUIRED';
28 C_HOLD_BP_ALWAYS CONSTANT ap_aud_rule_sets.hold_rct_overdue_bp_cc_code%type := 'ALWAYS';
29
30 ------------------------------------------------------------------------
31 FUNCTION IsHoldsRuleSetup(
32 p_org_id IN NUMBER,
33 p_report_submitted_date IN DATE) RETURN VARCHAR2;
34 ------------------------------------------------------------------------
35
36 ------------------------------------------------------------------------
37 PROCEDURE IsHoldsRuleSetup( p_item_type IN VARCHAR2,
38 p_item_key IN VARCHAR2,
39 p_actid IN NUMBER,
40 p_funmode IN VARCHAR2,
41 p_result OUT NOCOPY VARCHAR2);
42 ------------------------------------------------------------------------
43
44 ------------------------------------------------------------------------
45 PROCEDURE RaiseHeldEvent(
46 p_expense_report_id IN NUMBER);
47 ------------------------------------------------------------------------
48 ------------------------------------------------------------------------
49 PROCEDURE RaiseReleasedEvent(
50 p_expense_report_id IN NUMBER);
51 ------------------------------------------------------------------------
52
53 ------------------------------------------------------------------------
54 PROCEDURE RaiseReleasedEvent(
55 p_item_type IN VARCHAR2,
56 p_item_key IN VARCHAR2,
57 p_actid IN NUMBER,
58 p_funmode IN VARCHAR2,
59 p_result OUT NOCOPY VARCHAR2);
60 ------------------------------------------------------------------------
61
62 ------------------------------------------------------------------------
63 PROCEDURE InitHeld(
64 p_item_type IN VARCHAR2,
65 p_item_key IN VARCHAR2,
66 p_actid IN NUMBER,
67 p_funmode IN VARCHAR2,
68 p_result OUT NOCOPY VARCHAR2);
69 ------------------------------------------------------------------------
70
71 ------------------------------------------------------------------------
72 PROCEDURE InitReleased(
73 p_item_type IN VARCHAR2,
74 p_item_key IN VARCHAR2,
75 p_actid IN NUMBER,
76 p_funmode IN VARCHAR2,
77 p_result OUT NOCOPY VARCHAR2);
78 ------------------------------------------------------------------------
79
80 ------------------------------------------------------------------------
81 PROCEDURE AnyHoldsPending(
82 p_item_type IN VARCHAR2,
83 p_item_key IN VARCHAR2,
84 p_actid IN NUMBER,
85 p_funmode IN VARCHAR2,
86 p_result OUT NOCOPY VARCHAR2);
87 ------------------------------------------------------------------------
88
89 ------------------------------------------------------------------------
90 PROCEDURE GetHoldsScenario(
91 p_item_type IN VARCHAR2,
92 p_item_key IN VARCHAR2,
93 p_actid IN NUMBER,
94 p_funmode IN VARCHAR2,
95 p_result OUT NOCOPY VARCHAR2);
96 ------------------------------------------------------------------------
97
98 ------------------------------------------------------------------------
99 PROCEDURE ReleaseHold(
100 p_item_type IN VARCHAR2,
101 p_item_key IN VARCHAR2,
102 p_actid IN NUMBER,
103 p_funmode IN VARCHAR2,
104 p_result OUT NOCOPY VARCHAR2);
105 ------------------------------------------------------------------------
106
107 ------------------------------------------------------------------------
108 PROCEDURE StoreNote(
109 p_item_type IN VARCHAR2,
110 p_item_key IN VARCHAR2,
111 p_actid IN NUMBER,
112 p_funmode IN VARCHAR2,
113 p_result OUT NOCOPY VARCHAR2);
114 ------------------------------------------------------------------------
115
116 ------------------------------------------------------------------------
117 PROCEDURE CallbackFunction( p_item_type IN VARCHAR2,
118 p_item_key IN VARCHAR2,
119 p_actid IN NUMBER,
120 p_funmode IN VARCHAR2,
121 p_result OUT NOCOPY VARCHAR2);
122 ------------------------------------------------------------------------
123
124 ------------------------------------------------------------------------
125 PROCEDURE ExpenseHolds;
126 ------------------------------------------------------------------------
127 ------------------------------------------------------------------------
128 PROCEDURE HoldEach;
129 ------------------------------------------------------------------------
130 ------------------------------------------------------------------------
131 PROCEDURE HoldAll;
132 ------------------------------------------------------------------------
133 ------------------------------------------------------------------------
134 PROCEDURE HoldBothPay;
135 ------------------------------------------------------------------------
136 ------------------------------------------------------------------------
137 PROCEDURE ObsoleteHold;
138 ------------------------------------------------------------------------
139
140 PROCEDURE ReadyForPayment(p_report_header_id IN NUMBER);
141
142 FUNCTION GetReceiptsRequired(p_report_date IN DATE, p_org_id IN NUMBER) RETURN VARCHAR2;
143
144 END AP_WEB_HOLDS_WF;