4 -- <PO_CHANGE_API_FPJ START>
1 PACKAGE PO_DOCUMENT_UPDATE_GRP AUTHID CURRENT_USER AS
2 /* $Header: POXGCPOS.pls 120.2.12020000.2 2013/02/10 19:34:34 vegajula ship $*/
3
5 -- In file version 115.4, added an overloaded update_document procedure that
6 -- takes in changes as a PO_CHANGES_REC_TYPE object. This allows the caller to
7 -- request changes to multiple lines, shipments, and distributions at once.
8
9 -------------------------------------------------------------------------------
10 --Start of Comments
11 --Name: update_document
12 --Function:
13 -- Validates and applies the requested changes and any derived
14 -- changes to the Purchase Order, Purchase Agreement, or Release.
15 --Note:
16 -- For details, see the package body comments for
17 -- PO_DOCUMENT_UPDATE_PVT.update_document.
18 --End of Comments
19 --------------------------------------------------------------------------------
20
21 g_process_param_chge_only VARCHAR2(1) := 'N'; --<INVCONV R12>
22
23 PROCEDURE update_document (
24 p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2,
26 x_return_status OUT NOCOPY VARCHAR2,
27 p_changes IN OUT NOCOPY PO_CHANGES_REC_TYPE,
28 p_run_submission_checks IN VARCHAR2,
29 p_launch_approvals_flag IN VARCHAR2,
30 p_buyer_id IN NUMBER,
31 p_update_source IN VARCHAR2,
32 p_override_date IN DATE,
33 x_api_errors OUT NOCOPY PO_API_ERRORS_REC_TYPE,
34 p_approval_background_flag IN VARCHAR2 DEFAULT NULL,
35 p_mass_update_releases IN VARCHAR2 DEFAULT NULL, -- Bug 3373453
36 p_req_chg_initiator IN VARCHAR2 DEFAULT NULL --Bug 14549341
37 );
38
39 -- Bug 3605355 START
40 -------------------------------------------------------------------------------
41 --Start of Comments
42 --Name: launch_po_approval_wf
43 --Function:
44 -- Launches the Document Approval workflow for the given document.
45 --Note:
46 -- For details, see the package body comments for
47 -- PO_DOCUMENT_UPDATE_PVT.launch_po_approval_wf.
48 --End of Comments
49 -------------------------------------------------------------------------------
50 PROCEDURE launch_po_approval_wf (
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2,
53 x_return_status OUT NOCOPY VARCHAR2,
54 p_document_id IN NUMBER,
55 p_document_type IN PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE,
56 p_document_subtype IN PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE,
57 p_preparer_id IN NUMBER,
58 p_approval_background_flag IN VARCHAR2,
59 p_mass_update_releases IN VARCHAR2
60 );
61 -- Bug 3605355 END
62
63 -- Parameter value constants:
64
65 G_PARAMETER_YES VARCHAR2(1) := PO_CORE_S.G_PARAMETER_YES;
66 G_PARAMETER_NO VARCHAR2(1) := PO_CORE_S.G_PARAMETER_NO;
67
68 -- Constants for the p_update_source parameter of update_document:
69
70 G_UPDATE_SOURCE_OM CONSTANT VARCHAR2(20)
71 := PO_DOCUMENT_UPDATE_PVT.G_UPDATE_SOURCE_OM; -- OM (Drop Ship Integration)
72
73 -- Entity type constants:
74
75 G_ENTITY_TYPE_CHANGES CONSTANT VARCHAR2(30)
76 := PO_DOCUMENT_UPDATE_PVT.G_ENTITY_TYPE_CHANGES;
77 G_ENTITY_TYPE_LINES CONSTANT VARCHAR2(30)
78 := PO_DOCUMENT_UPDATE_PVT.G_ENTITY_TYPE_LINES;
82 := PO_DOCUMENT_UPDATE_PVT.G_ENTITY_TYPE_DISTRIBUTIONS;
79 G_ENTITY_TYPE_SHIPMENTS CONSTANT VARCHAR2(30)
80 := PO_DOCUMENT_UPDATE_PVT.G_ENTITY_TYPE_SHIPMENTS;
81 G_ENTITY_TYPE_DISTRIBUTIONS CONSTANT VARCHAR2(30)
83
84 -- Use this constant in the change object to indicate that a field should be
85 -- set to NULL.
86 G_NULL_NUM CONSTANT NUMBER := PO_DOCUMENT_UPDATE_PVT.G_NULL_NUM;
87
88 -- <PO_CHANGE_API_FPJ END>
89
90 -- <PO_CHANGE_API_FPJ START>
91 -- In file version 115.3, removed the P_INTERFACE_TYPE and P_TRANSACTION_ID
92 -- parameters from UPDATE_DOCUMENT and added an X_API_ERRORS parameter.
93 -- The PO Change API will no longer write error messages to the
94 -- PO_INTERFACE_ERRORS table. Instead, all of the errors will be returned
95 -- in the x_api_errors object.
96 -- <PO_CHANGE_API_FPJ END>
97
98 /*=====================================================================
99 * PROCEDURE update_document
100 * API that updates qty, price or/and promised_date of a document.
101 * Parameters:
102 * - p_PO_NUMBER: po number of the document
103 * - p_RELEASE_NUMBER: Null if not a release, otherwise, release number
104 * - p_REVISION_NUMBER: should be the latest revision
105 * - p_LINE_NUMBER: Line number of the doc.
106 * - p_SHIPMENT_NUMBER: Shipment number
107 * - p_NEW_QUANTITY : desired new quantity for a line/shipment
108 * - p_NEW_PRICE : desired new price for a line/shipment
109 * - p_NEW_PROMISED_DATE: desired new promised date for a shipment
110 * - p_NEW_NEED_BY_DATE: desired new need-by date for a shipment
111 * - p_LAUNCH_APPROVALS_FLAG: determines whether approval workflow is
112 * executed or not after update
113 * - p_UPDATE_SOURCE: for future usage
114 * - p_OVERRIDE_DATE: If funds are reserved for the document, this
115 * parameter is to speicify the date that is used
116 * to unreserve the doc. It's meaningless if
117 * encumbrance is not used.
118 * - p_VERSION: version of the API that is intended to be used
119 * - x_result: return status of the call:
120 * 1 if the API completed successfully;
121 * 0 if there will any errors.
122 * - x_api_errors: If x_result = 0, this object will contain all of the error
123 * messages.
124 * - - p_BUYER_NAME: Added as a part of bug fix 2986718.
125 *======================================================================*/
126 PROCEDURE update_document
127 (
128 p_PO_NUMBER IN VARCHAR2,
129 p_RELEASE_NUMBER IN NUMBER,
130 p_REVISION_NUMBER IN NUMBER,
131 p_LINE_NUMBER IN NUMBER,
132 p_SHIPMENT_NUMBER IN NUMBER,
133 p_NEW_QUANTITY IN NUMBER,
134 p_NEW_PRICE IN NUMBER,
135 p_NEW_PROMISED_DATE IN DATE,
136 p_NEW_NEED_BY_DATE IN DATE,
137 p_LAUNCH_APPROVALS_FLAG IN VARCHAR2,
138 p_UPDATE_SOURCE IN VARCHAR2,
139 p_OVERRIDE_DATE IN DATE,
140 p_VERSION IN NUMBER,
141 x_result IN OUT NOCOPY NUMBER,
142 x_api_errors OUT NOCOPY PO_API_ERRORS_REC_TYPE,
143 p_BUYER_NAME IN VARCHAR2 default NULL,
144 --<INVCONV R12 START>
145 p_secondary_qty IN NUMBER ,
146 p_preferred_grade IN VARCHAR2
147 --<INVCONV R12 END>
148 );
149
150 END PO_DOCUMENT_UPDATE_GRP;