1 PACKAGE OE_ACCEPTANCE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVACCS.pls 120.2 2006/09/20 09:24:32 serla noship $ */
3
4 -- Datatype for bulk update of acceptance details
5 TYPE NUMBER_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6 TYPE VARCHAR_240_TYPE IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
7 TYPE VARCHAR_30_TYPE IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
8 TYPE VARCHAR_2000_TYPE IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
9 TYPE FLAG_TYPE IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
10 TYPE DATE_TYPE IS TABLE OF DATE INDEX BY BINARY_INTEGER;
11
12 --This procedure is called by Process_Order_Actions for processing actions 'ACCEPT_FULFILLMENT' and 'REJECT FULFILLMENT'.
13 Procedure Process_Acceptance(p_request_tbl IN OUT NOCOPY OE_ORDER_PUB.request_tbl_type
14 ,p_index IN NUMBER DEFAULT 1
15 ,x_return_status OUT NOCOPY Varchar2);
16
17 --This procedure builds the line table for all eligible lines when the entity passed in request_rec is 'HEADER'
18 Procedure Build_Header_Acceptance_table(p_request_rec IN OUT NOCOPY OE_ORDER_PUB.request_rec_type
19 ,x_return_status OUT NOCOPY Varchar2);
20
21 --This procedure will check if the given line is eligible for acceptance and then adds that line to line_tbl
22 Procedure Build_Line_Acceptance_table(p_request_rec IN OUT NOCOPY OE_ORDER_PUB.request_rec_type
23 ,p_line_id IN NUMBER DEFAULT NULL
24 ,x_return_status OUT NOCOPY Varchar2);
25
26 --This procedure progress the workflow for each of the lines that were processed for acceptance or rejection.
27 Procedure Progress_Accepted_Lines(x_return_status OUT NOCOPY Varchar2);
28
29 END OE_ACCEPTANCE_PVT;
[Home] [Help]