[Home] [Help]
PACKAGE: APPS.PO_CHORD_WF6
Source
1 PACKAGE PO_CHORD_WF6 as
2 /* $Header: POXWCO6S.pls 120.8 2006/03/08 16:27:58 dreddy noship $ */
3
4 SUBTYPE t_header_control_type IS
5 PO_CHORD_WF1.t_header_control_type;
6
7 SUBTYPE t_lines_control_type IS
8 PO_CHORD_WF2.t_lines_control_type;
9
10 SUBTYPE t_shipments_control_type IS
11 PO_CHORD_WF3.t_shipments_control_type;
12
13 SUBTYPE t_dist_control_type IS
14 PO_CHORD_WF4.t_dist_control_type;
15
16 SUBTYPE t_release_control_type IS
17 PO_CHORD_WF5.t_release_control_type;
18
19 /* This record type holds tolerance percentages
20 ** defined by user in the workflow builder.
21 ** The prefix denotes the table which
22 ** the attribute is referring to :
23 ** h: po_headers_all
24 ** l: po_lines_all
25 ** s: po_line_locations_all
26 ** d: po_distributions_all
27 */
28
29 TYPE t_tolerance_control_type IS RECORD(
30 h_blanket_total_t NUMBER,
31 h_amount_limit_t NUMBER,
32 h_po_total_t NUMBER,
33 l_start_date_t NUMBER, --<R12 Requester Driven Procurement>
34 l_end_date_t NUMBER, --<R12 Requester Driven Procurement>
35 l_quantity_t NUMBER,
36 l_unit_price_t NUMBER,
37 l_quantity_committed_t NUMBER,
38 l_committed_amount_t NUMBER,
39 l_price_limit_t NUMBER,
40 l_amount_t NUMBER, --<R12 Requester Driven Procurement>
41 s_quantity_t NUMBER,
42 s_price_override_t NUMBER,
43 s_amount_t NUMBER, --<R12 Requester Driven Procurement>
44 s_need_by_date_t NUMBER, --<R12 Requester Driven Procurement>
45 s_promised_date_t NUMBER, --<R12 Requester Driven Procurement>
46 p_quantity_t NUMBER, -- <Complex Work R12>
47 p_price_override_t NUMBER, -- <Complex Work R12>
48 p_amount_t NUMBER, -- <Complex Work R12>
49 d_quantity_ordered_t NUMBER,
50 d_amount_ordered_t NUMBER --<R12 Requester Driven Procurement>
51 );
52
53
54 PROCEDURE standard_po_reapproval(itemtype IN VARCHAR2,
55 itemkey IN VARCHAR2,
56 actid IN NUMBER,
57 FUNCMODE IN VARCHAR2,
58 RESULT OUT NOCOPY VARCHAR2);
59
60 PROCEDURE planned_po_reapproval(itemtype IN VARCHAR2,
61 itemkey IN VARCHAR2,
62 actid IN NUMBER,
63 FUNCMODE IN VARCHAR2,
64 RESULT OUT NOCOPY VARCHAR2);
65
66 PROCEDURE blanket_po_reapproval(itemtype IN VARCHAR2,
67 itemkey IN VARCHAR2,
68 actid IN NUMBER,
69 FUNCMODE IN VARCHAR2,
70 RESULT OUT NOCOPY VARCHAR2);
71
72 PROCEDURE contract_po_reapproval(itemtype IN VARCHAR2,
73 itemkey IN VARCHAR2,
74 actid IN NUMBER,
75 FUNCMODE IN VARCHAR2,
76 RESULT OUT NOCOPY VARCHAR2);
77
78 PROCEDURE blanket_release_reapproval(itemtype IN VARCHAR2,
79 itemkey IN VARCHAR2,
80 actid IN NUMBER,
81 FUNCMODE IN VARCHAR2,
82 RESULT OUT NOCOPY VARCHAR2);
83
84 PROCEDURE scheduled_release_reapproval(itemtype IN VARCHAR2,
85 itemkey IN VARCHAR2,
86 actid IN NUMBER,
87 FUNCMODE IN VARCHAR2,
88 RESULT OUT NOCOPY VARCHAR2);
89
90 PROCEDURE get_default_tolerance(
91 itemtype IN VARCHAR2,
92 itemkey IN VARCHAR2,
93 x_tolerance_control IN OUT NOCOPY t_tolerance_control_type,
94 chord_doc_type IN VARCHAR2 default NULL);
95
96 PROCEDURE debug_default_tolerance(
97 itemtype IN VARCHAR2,
98 itemkey IN VARCHAR2,
99 x_tolerance_control t_tolerance_control_type);
100
101 /**************************************************************************
102 * The following procedures are procedures used to retrieve
103 * the tolerances.
104 **************************************************************************/
105 PROCEDURE Set_Wf_Order_Tol(
106 itemtype IN VARCHAR2,
107 itemkey IN VARCHAR2,
108 order_type IN VARCHAR2);
109
110 PROCEDURE Set_Wf_Agreement_Tol(
111 itemtype IN VARCHAR2,
112 itemkey IN VARCHAR2,
113 agreement_type IN VARCHAR2);
114
115 PROCEDURE Set_Wf_Release_Tol(
116 itemtype IN VARCHAR2,
117 itemkey IN VARCHAR2,
118 release_type IN VARCHAR2);
119
120
121 END PO_CHORD_WF6;