[Home] [Help]
PACKAGE: APPS.PO_DIFF_SUMMARY_PKG
Source
1 PACKAGE PO_DIFF_SUMMARY_PKG AUTHID CURRENT_USER AS
2 -- $Header: PO_DIFF_SUMMARY_PKG.pls 120.3.12020000.3 2013/02/11 00:47:49 vegajula ship $
3
4
5 --==========================================================================
6 -- Workflow related procedures
7 --==========================================================================
8 FUNCTION accept_lines_within_tolerance
9 ( p_draft_id IN NUMBER
10 ) RETURN VARCHAR2;
11
12 PROCEDURE start_workflow
13 ( p_po_header_id IN NUMBER
14 );
15
16 PROCEDURE selector
17 ( item_type IN VARCHAR2,
18 item_key IN VARCHAR2,
19 activity_id IN NUMBER,
20 command IN VARCHAR2,
21 resultout IN OUT NOCOPY VARCHAR2
22 );
23
24 PROCEDURE start_buyer_acceptance_process
25 ( itemtype IN VARCHAR2,
26 itemkey IN VARCHAR2,
27 actid IN NUMBER,
28 funcmode IN VARCHAR2,
29 resultout OUT NOCOPY VARCHAR2
30 );
31
32 PROCEDURE mark_autoaccept_lines
33 ( itemtype IN VARCHAR2,
34 itemkey IN VARCHAR2,
35 actid IN NUMBER,
36 funcmode IN VARCHAR2,
37 resultout OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE buyer_acceptance_required
41 ( itemtype IN VARCHAR2,
42 itemkey IN VARCHAR2,
43 actid IN NUMBER,
44 funcmode IN VARCHAR2,
45 resultout OUT NOCOPY VARCHAR2
46 );
47
48 PROCEDURE transfer_if_all_autoaccepted
49 ( itemtype IN VARCHAR2,
50 itemkey IN VARCHAR2,
51 actid IN NUMBER,
52 funcmode IN VARCHAR2,
53 resultout OUT NOCOPY VARCHAR2
54 );
55
56 /* TODO: Don't need this
57 PROCEDURE send_reject_all_notification(p_po_header_id IN NUMBER,
58 p_user IN VARCHAR2);
59 */
60
61 PROCEDURE get_buyers_manager
62 ( itemtype IN VARCHAR2,
63 itemkey IN VARCHAR2,
64 actid IN NUMBER,
65 funcmode IN VARCHAR2,
66 resultout OUT NOCOPY VARCHAR2
67 );
68
69 PROCEDURE buyer_accept_changes
70 ( itemtype IN VARCHAR2,
71 itemkey IN VARCHAR2,
72 actid IN NUMBER,
73 funcmode IN VARCHAR2,
74 resultout OUT NOCOPY VARCHAR2
75 );
76
77 PROCEDURE buyer_reject_changes
78 ( itemtype IN VARCHAR2,
79 itemkey IN VARCHAR2,
80 actid IN NUMBER,
81 funcmode IN VARCHAR2,
82 resultout OUT NOCOPY VARCHAR2
83 );
84
85 PROCEDURE any_lines_get_rejected
86 ( itemtype IN VARCHAR2,
87 itemkey IN VARCHAR2,
88 actid IN NUMBER,
89 funcmode IN VARCHAR2,
90 resultout OUT NOCOPY VARCHAR2
91 );
92
93 PROCEDURE transfer_draft_to_txn
94 ( itemtype IN VARCHAR2,
95 itemkey IN VARCHAR2,
96 actid IN NUMBER,
97 funcmode IN VARCHAR2,
98 resultout OUT NOCOPY VARCHAR2
99 );
100
101 PROCEDURE launch_po_approval_wf
102 ( itemtype IN VARCHAR2,
103 itemkey IN VARCHAR2,
104 actid IN NUMBER,
105 funcmode IN VARCHAR2,
106 resultout OUT NOCOPY VARCHAR2
107 );
108
109 --==========================================================================
110 -- Regular procedures
111 --==========================================================================
112
113 FUNCTION get_new_itemkey
114 ( p_draft_id IN NUMBER
115 ) RETURN VARCHAR2;
116
117 FUNCTION find_itemkey
118 ( p_draft_id IN NUMBER
119 ) RETURN VARCHAR2;
120
121 PROCEDURE record_disposition
122 ( p_draft_id IN NUMBER,
123 p_reject_line_id_list IN PO_TBL_NUMBER,
124 x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544
125 x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544
126 x_return_status OUT NOCOPY VARCHAR2
127 );
128
129 PROCEDURE complete_resp_to_changes
130 ( p_draft_id IN NUMBER,
131 p_action IN VARCHAR2,
132 p_initiate_approval IN VARCHAR2,
133 p_note_to_approver IN VARCHAR2,
134 x_return_status OUT NOCOPY VARCHAR2
135 );
136
137 -- Bug 12964696
138 PROCEDURE post_buyer_acceptance
139 ( itemtype IN VARCHAR2,
140 itemkey IN VARCHAR2,
141 actid IN NUMBER,
142 funcmode IN VARCHAR2,
143 resultout OUT NOCOPY VARCHAR2
144 );
145
146 --Bug 13469215
147 PROCEDURE should_approval_be_launched
148 ( itemtype IN VARCHAR2,
149 itemkey IN VARCHAR2,
150 actid IN NUMBER,
151 funcmode IN VARCHAR2,
152 resultout OUT NOCOPY VARCHAR2
153 );
154
155 END PO_DIFF_SUMMARY_PKG;