[Home] [Help]
PACKAGE: APPS.OE_LINE_STATUS_PUB
Source
1 PACKAGE OE_LINE_STATUS_PUB 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;