[Home] [Help]
PACKAGE: APPS.OE_PURCHASE_RELEASE_PVT
Source
1 PACKAGE OE_Purchase_Release_PVT AS
2 /* $Header: OEXVDSPS.pls 120.0.12010000.1 2008/07/25 07:59:37 appldev ship $ */
3
4
5 -- Modes for Purchase Release
6 G_MODE_CONCURRENT VARCHAR2(30) := 'CONCURRENT';
7 G_MODE_ONLINE VARCHAR2(30) := 'ONLINE';
8
9 -- Results for Workflow
10 G_RES_INCOMPLETE VARCHAR2(30) := 'INCOMPLETE';
11 G_RES_NOT_APPLICABLE VARCHAR2(30) := 'NOT_APPLICABLE';
12 G_RES_COMPLETE VARCHAR2(30) := 'COMPLETE';
13 G_RES_ONHOLD VARCHAR2(30) := 'ONHOLD';
14
15 TYPE Drop_Ship_Line_Rec_Type IS RECORD
16 (header_id NUMBER := FND_API.G_MISS_NUM,
17 order_type_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
18 order_number NUMBER := FND_API.G_MISS_NUM,
19 line_number NUMBER := FND_API.G_MISS_NUM,
20 line_id NUMBER := FND_API.G_MISS_NUM,
21 item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22 inventory_item_id NUMBER := FND_API.G_MISS_NUM,
23 ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
24 open_quantity NUMBER := FND_API.G_MISS_NUM,
25 open_quantity2 NUMBER := FND_API.G_MISS_NUM,
26 project_id NUMBER := FND_API.G_MISS_NUM,
27 task_id NUMBER := FND_API.G_MISS_NUM,
28 end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
29 user_name VARCHAR2(100) := FND_API.G_MISS_CHAR, -- Bug# 4189838
30 employee_id NUMBER := FND_API.G_MISS_NUM,
31 request_date DATE := FND_API.G_MISS_DATE,
32 schedule_ship_date DATE := FND_API.G_MISS_DATE,
33 source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
34 charge_account_id NUMBER := FND_API.G_MISS_NUM,
35 accrual_account_id NUMBER := FND_API.G_MISS_NUM,
36 ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
37 deliver_to_location_id NUMBER := FND_API.G_MISS_NUM,
38 return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
39 result VARCHAR2(30) := FND_API.G_MISS_CHAR,
40 uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
41 uom2_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
42 preferred_grade VARCHAR2(150) := FND_API.G_MISS_CHAR, -- INVCONV 4091955
43 unit_list_price NUMBER := FND_API.G_MISS_NUM,
44 item_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
45 );
46
47 G_MISS_DROP_SHIP_LINE_REC Drop_Ship_Line_Rec_Type;
48
49 TYPE Drop_Ship_Tbl_Type IS TABLE OF Drop_Ship_Line_Rec_Type
50 INDEX BY BINARY_INTEGER;
51
52 Procedure Purchase_Release
53 ( p_api_version_number IN NUMBER
54 , p_drop_ship_tbl IN Drop_Ship_Tbl_Type
55 , p_mode IN VARCHAR2 := G_MODE_ONLINE
56 , x_drop_ship_tbl OUT NOCOPY Drop_Ship_Tbl_Type
57
58 , x_return_status OUT NOCOPY VARCHAR2
59
60 , x_msg_count OUT NOCOPY NUMBER
61
62 , x_msg_data OUT NOCOPY VARCHAR2
63
64 );
65
66 Procedure Insert_Into_Po_Req_Interface
67 (p_drop_ship_line_rec IN Drop_Ship_Line_Rec_Type
68 ,x_return_status OUT NOCOPY VARCHAR2
69
70 ,p_user_id IN NUMBER
71 ,p_resp_id IN NUMBER
72 ,p_application_id IN NUMBER
73 ,p_org_id IN NUMBER
74 ,p_login_id IN NUMBER
75 ,p_drop_ship_source_id IN NUMBER
76 );
77
78 Procedure Insert_Drop_Ship_Source
79 ( p_drop_ship_line_rec IN Drop_Ship_Line_Rec_Type
80 ,x_return_status OUT NOCOPY VARCHAR2
81
82 ,p_user_id IN NUMBER
83 ,p_resp_id IN NUMBER
84 ,p_application_id IN NUMBER
85 ,p_org_id IN NUMBER
86 ,p_login_id IN NUMBER
87 ,p_drop_ship_source_id IN NUMBER
88 );
89
90 Procedure Associate_address(p_drop_ship_line_rec IN Drop_Ship_Line_Rec_Type
91 ,x_drop_ship_line_rec OUT NOCOPY Drop_Ship_Line_Rec_Type
92
93 ,x_return_status OUT NOCOPY VARCHAR2);
94
95
96 Procedure Get_Eligible_lines
97 (p_line_id IN NUMBER
98 ,x_drop_ship_tbl OUT NOCOPY Drop_Ship_Tbl_Type
99
100 ,x_return_status OUT NOCOPY VARCHAR2
101
102 );
103
104 Procedure Process_DropShip_CMS_Requests
105 (p_request_tbl IN OUT NOCOPY OE_ORDER_PUB.Request_Tbl_Type
106 ,x_return_status OUT NOCOPY VARCHAR2
107 );
108
109
110 END OE_Purchase_Release_PVT;