PACKAGE: APPS.OE_LINE_FULLFILL

Source

1 PACKAGE OE_LINE_FULLFILL AUTHID CURRENT_USER AS
2 /* $Header: OEXVFULS.pls 120.0.12010000.1 2008/07/25 07:59:58 appldev ship $ */
3 
4 TYPE Line_Set_Rec_Type	IS RECORD
5 (
6 	line_id				NUMBER := FND_API.G_MISS_NUM
7 ,	set_id				NUMBER := FND_API.G_MISS_NUM
8 ,	type				VARCHAR2(1) := FND_API.G_MISS_CHAR
9 ,	fulfilled_flag		VARCHAR2(1) := FND_API.G_MISS_CHAR
10 ,	ordered_quantity	NUMBER := FND_API.G_MISS_NUM
11 );
12 
13 G_DEBUG_MSG  VARCHAR2(2000);
14 
15 TYPE Line_Set_Tbl_Type IS TABLE OF Line_Set_Rec_Type
16 	INDEX BY BINARY_INTEGER;
17 
18 TYPE processed_set IS TABLE OF NUMBER
19 INDEX BY BINARY_INTEGER;
20 
21 FUNCTION Is_Part_Of_Fulfillment_Set
22 (
23 	p_line_id					IN	NUMBER
24 ) return VARCHAR2 ;
25 
26 PROCEDURE Fulfill_Line
27 (
28 	p_line_rec				IN	OE_Order_Pub.Line_Rec_Type DEFAULT OE_Order_Pub.G_MISS_LINE_REC
29 ,	p_line_tbl				IN	OE_Order_Pub.Line_Tbl_Type DEFAULT OE_Order_Pub.G_MISS_LINE_TBL
30 ,	p_mode					IN	VARCHAR2
31 ,	p_fulfillment_type		IN	VARCHAR2
32 ,	p_fulfillment_activity	IN	VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
33 , x_return_status OUT NOCOPY VARCHAR2
34 
35 );
36 
37 PROCEDURE Process_Fulfillment
38 (
39 	p_api_version_number	IN	NUMBER
40 ,	p_line_id				IN	NUMBER
41 ,	p_activity_id			IN	NUMBER
42 , x_result_out OUT NOCOPY VARCHAR2
43 
44 , x_return_status OUT NOCOPY VARCHAR2
45 
46 , x_msg_count OUT NOCOPY VARCHAR2
47 
48 , x_msg_data OUT NOCOPY VARCHAR2
49 
50 );
51 
52 PROCEDURE Get_Fulfillment_Activity
53 (
54 	p_item_key				IN	VARCHAR2
55 ,	p_activity_id			IN	NUMBER
56 , x_fulfillment_activity OUT NOCOPY VARCHAR2
57 
58 , x_return_status OUT NOCOPY VARCHAR2
59 
60 );
61 
62 PROCEDURE Get_Activity_Result
63 (
64 	p_item_type				IN	VARCHAR2
65 ,	p_item_key				IN	VARCHAR2
66 ,	p_activity_name			IN	VARCHAR2
67 , x_return_status OUT NOCOPY VARCHAR2
68 
69 , x_activity_result OUT NOCOPY VARCHAR2
70 
71 , x_activity_status_code OUT NOCOPY VARCHAR2
72 
73 , x_activity_id OUT NOCOPY NUMBER
74 
75 );
76 
77 -- Bug2068310: new parameter p_fulfill_operation added.
78 PROCEDURE Cancel_line
79 (
80 	p_line_id			IN NUMBER
81 , x_return_status OUT NOCOPY VARCHAR2
82 
83 ,       p_fulfill_operation             IN  VARCHAR2 DEFAULT 'N'
84 ,       p_set_id                        IN  NUMBER DEFAULT NULL  -- 2525203
85 );
86 
87 PROCEDURE Get_Fulfillment_Set
88 (
89 	p_line_id			IN	NUMBER
90 , x_return_status OUT NOCOPY VARCHAR2
91 
92 , x_set_tbl OUT NOCOPY Line_Set_Tbl_Type
93 
94 );
95 
96 PROCEDURE Fulfill_Service_Lines
97 (
98 	p_line_id			IN	NUMBER
99 ,       p_header_id			IN	NUMBER DEFAULT NULL  -- 1717444
100 , x_return_status OUT NOCOPY VARCHAR2
101 
102 );
103 
104 end OE_LINE_FULLFILL;