1 PACKAGE POS_ACK_PO AS
2 /* $Header: POSISPAS.pls 120.2.12010000.2 2008/08/02 14:55:44 sthoppan ship $ */
3 /*Bug 6772960
4 Modified the signature which takes l_last_update_date as IN parameter
5 and returns x_error as OUT parameter. l_last_update_date is used to
6 check the concurrency i.e., to check whether multiple supplier users
7 are acting on the same PO simutaneously. If the supplier try to modify
8 the PO which has already been modified by other user x_error returns false.
9 */
10 PROCEDURE ACKNOWLEDGE_PO (
11 l_po_header_id IN VARCHAR2,
12 l_po_release_id IN VARCHAR2 default null,
13 l_po_buyer_id IN VARCHAR2,
14 l_po_accept_reject IN VARCHAR2,
15 l_po_acc_type_code IN VARCHAR2,
16 l_po_ack_comments IN VARCHAR2 ,
17 l_user_id IN VARCHAR2,
18 l_last_update_date IN DATE DEFAULT fnd_api.G_NULL_DATE,
19 x_error OUT NOCOPY VARCHAR2);
20
21 PROCEDURE Acknowledge_promise_date ( -- RDP new procedure to default the promise date with need by date
22 p_line_location_id IN NUMBER,
23 p_po_header_id IN NUMBER,
24 p_po_release_id IN NUMBER,
25 p_revision_num IN NUMBER,
26 p_user_id IN NUMBER);
27
28 PROCEDURE CREATE_HEADER_PROCESS(
29 pos_po_header_id IN VARCHAR2,
30 pos_po_release_id IN VARCHAR2,
31 pos_user_id IN NUMBER,
32 pos_item_type OUT NOCOPY VARCHAR2,
33 pos_item_key OUT NOCOPY VARCHAR2
34 );
35
36 PROCEDURE START_HEADER_PROCESS(
37 l_item_type IN VARCHAR2,
38 l_item_key IN VARCHAR2
39 );
40
41 PROCEDURE ADD_SHIPMENT(
42 l_item_type IN VARCHAR2,
43 l_item_key IN VARCHAR2,
44 l_line_location_id IN VARCHAR2,
45 l_new_promise_date IN VARCHAR2,
46 l_old_promise_date IN VARCHAR2,
47 l_new_need_by_date IN VARCHAR2,
48 l_old_need_by_date IN VARCHAR2,
49 l_reason IN VARCHAR2
50 );
51 /*
52 PROCEDURE POS_ACK_HEADER_PROCESS(
53 pos_po_header_id IN VARCHAR2,
54 pos_po_release_id IN VARCHAR2,
55 pos_user_id IN NUMBER,
56 pos_item_type OUT NOCOPY VARCHAR2,
57 pos_item_key OUT NOCOPY VARCHAR2
58 );
59 */
60 END POS_ACK_PO;
[Home] [Help]