PACKAGE: APPS.OE_LINE_STATUS_PUB

Source

1 PACKAGE OE_LINE_STATUS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OEXPLNSS.pls 120.0 2005/05/31 23:09:30 appldev noship $ */
3 
4 
5 PROCEDURE Get_Closed_Status(
6 p_line_id	IN NUMBER,
7 x_result	OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
8 
9 PROCEDURE Get_Closed_Status(
10 p_line_id	IN NUMBER,
11 x_result	OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
12 x_result_date	OUT NOCOPY /* file.sql.39 change */ DATE);
13 
14 PROCEDURE Get_Cancelled_status(
15 p_line_id	IN NUMBER,
16 x_result	OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
17 
18 
19 PROCEDURE Get_Cancelled_Status(
20 p_line_id	IN NUMBER,
21 x_result	OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
22 x_result_date	OUT NOCOPY /* file.sql.39 change */ DATE);
23 
24 
25 PROCEDURE Get_Purchase_Release_status(
26 p_line_id	IN NUMBER,
27 x_result	OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
28 
29 
30 PROCEDURE Get_Purchase_Release_status(
31 p_line_id	IN NUMBER,
32 x_result	OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
33 x_result_date	OUT NOCOPY /* file.sql.39 change */ DATE);
34 
35 PROCEDURE Get_ship_Status(
36 p_line_id	IN NUMBER,
37 x_result	OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
38 
39 
40 PROCEDURE Get_ship_Status(
41 p_line_id	IN NUMBER,
42 x_result	OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
43 x_result_date	OUT NOCOPY /* file.sql.39 change */ DATE);
44 
45 PROCEDURE Get_pick_Status(
46 p_line_id	IN NUMBER,
47 x_result	OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
48 
49 PROCEDURE Get_pick_Status(
50 p_line_id	IN NUMBER,
51 x_result	OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
52 x_picked_quantity	OUT NOCOPY /* file.sql.39 change */ NUMBER,
53 x_picked_quantity_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
54 
55 PROCEDURE Get_Received_Status(
56 p_line_id	IN NUMBER,
57 x_result	OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
58 
59 PROCEDURE Get_Received_Status(
60 p_line_id	IN NUMBER,
61 x_result	OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
62 x_result_date	OUT NOCOPY /* file.sql.39 change */ DATE);
63 
64 PROCEDURE Get_Invoiced_Status(
65 p_line_id	IN NUMBER,
66 x_result	OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
67 
68 PROCEDURE Get_Invoiced_Status(
69 p_line_id	IN NUMBER,
70 x_result	OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
71 x_result_date	OUT NOCOPY /* file.sql.39 change */ DATE);
72 
73 
74 FUNCTION Get_Line_Status
75 ( p_line_id                  IN   NUMBER
76  ,p_flow_status_code         IN   VARCHAR2)
77 RETURN VARCHAR2;
78 
79 END OE_LINE_STATUS_PUB;