[Home] [Help]
PACKAGE: APPS.OKE_AMG_GRP
Source
1 PACKAGE OKE_AMG_GRP AUTHID CURRENT_USER AS
2 /* $Header: OKEAMGDS.pls 120.1 2005/09/20 10:29:02 ausmani noship $ */
3
4 TYPE dlv_rec_type IS RECORD(
5 dlv_short_name VARCHAR2(150),
6 dlv_description VARCHAR2(240),
7 item_id NUMBER ,
8 inventory_org_id NUMBER ,
9 quantity NUMBER ,
10 uom_code VARCHAR2(30) ,
11 unit_price NUMBER ,
12 unit_number VARCHAR2(30) ,
13 pa_deliverable_id NUMBER ,
14 project_id NUMBER ,
15 currency_code VARCHAR2(30));
16
17 TYPE dlv_ship_action_rec_type IS RECORD(
18 pa_action_id NUMBER ,
19 pa_deliverable_id NUMBER ,
20 action_name VARCHAR2(240),
21 ship_finnancial_task_id NUMBER ,
22 demand_schedule VARCHAR2(10),
23 ship_from_organization_id NUMBER ,
24 ship_from_location_id NUMBER ,
25 ship_to_organization_id NUMBER ,
26 ship_to_location_id NUMBER ,
27 INSPECTION_REQ_FLAG Varchar2(1),
28 promised_shipment_date DATE ,
29 expected_shipment_date DATE ,
30 volume NUMBER ,
31 volume_uom VARCHAR2(10),
32 weight NUMBER ,
33 weight_uom VARCHAR2(10),
34 quantity NUMBER ,
35 uom_code VARCHAR2(10),
36 ready_to_ship_flag VARCHAR2(1) ,
37 initiate_planning_flag VARCHAR2(1) ,
38 initiate_shipping_flag VARCHAR2(1) );
39
40 TYPE dlv_req_action_rec_type IS RECORD(
41 pa_action_id NUMBER ,
42 pa_deliverable_id NUMBER ,
43 action_name VARCHAR2(240) ,
44 proc_finnancial_task_id NUMBER ,
45 destination_type_code VARCHAR2(30) ,
46 receiving_org_id NUMBER ,
47 receiving_location_id VARCHAR2(150),
48 po_need_by_date DATE ,
49 vendor_id NUMBER ,
50 vendor_site_id NUMBER ,
51 quantity NUMBER ,
52 uom_code Varchar2(30) ,
53 unit_price NUMBER ,
54 currency Varchar2(30) ,
55 exchange_rate_type VARCHAR2(30) ,
56 exchange_rate_date DATE ,
57 exchange_rate NUMBER ,
58 expenditure_type VARCHAR2(30) ,
59 expenditure_org_id NUMBER ,
60 expenditure_item_date DATE ,
61 requisition_line_type_id NUMBER ,
62 category_id NUMBER ,
63 ready_to_procure_flag VARCHAR2(1) ,
64 initiate_procure_flag VARCHAR2(1) );
65
66 Procedure manage_dlv(
67 p_api_version IN Number,
68 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
69 p_commit IN Varchar2 default fnd_api.g_false,
70 p_action IN Varchar2,
71 p_item_dlv IN Varchar2,
72 p_master_inv_org_id IN Number,
73 p_dlv_rec IN OUT NOCOPY dlv_rec_type,
74 x_return_status OUT NOCOPY Varchar2,
75 x_msg_data OUT NOCOPY Varchar2,
76 x_msg_count OUT NOCOPY Number
77 );
78
79 Procedure manage_dlv_action(
80 p_api_version IN Number,
81 p_init_msg_list IN Varchar2 default fnd_api.g_false,
82 p_commit IN Varchar2 default fnd_api.g_false,
83 p_action IN Varchar2,
84 p_item_dlv IN Varchar2,
85 p_master_inv_org_id IN Number,
86 p_dlv_action_type IN Varchar2,
87 p_dlv_ship_action_rec IN OUT NOCOPY dlv_ship_action_rec_type,
88 p_dlv_req_action_rec IN OUT NOCOPY dlv_req_action_rec_type,
89 x_return_status OUT NOCOPY Varchar2,
90 x_msg_data OUT NOCOPY Varchar2,
91 x_msg_count OUT NOCOPY Number
92 );
93
94 Procedure initiate_dlv_action (
95 p_api_version IN Number,
96 p_init_msg_list IN Varchar2 default fnd_api.g_false,
97 p_commit IN Varchar2 default fnd_api.g_false,
98 p_pa_action_id IN Number,
99 p_dlv_action_type IN Varchar2,
100 x_return_status OUT NOCOPY Varchar2,
101 x_msg_data OUT NOCOPY Varchar2,
102 x_msg_count OUT NOCOPY Number
103 );
104 END OKE_AMG_GRP;