[Home] [Help]
PACKAGE: APPS.EAM_WORKORDERBILLING_PVT
Source
1 PACKAGE EAM_WorkOrderBilling_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVWOBS.pls 115.3 2003/01/31 22:08:49 lllin noship $ */
3
4 -- Start of comments
5 -- API name : insert_AR_Interface
6 -- Type : Private.
7 -- Function :
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- IN : p_api_version IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 Optional
12 -- Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional
14 -- Default = FND_API.G_FALSE
15 -- p_validation_level IN NUMBER Optional
16 -- Default = FND_API.G_VALID_LEVEL_FULL
17 -- parameter1
18 -- parameter2
19 -- .
20 -- .
21 -- OUT : x_return_status OUT VARCHAR2(1)
22 -- x_msg_count OUT NUMBER
23 -- x_msg_data OUT VARCHAR2(2000)
24 -- parameter1
25 -- parameter2
26 -- .
27 -- .
28 -- Version : Current version x.x
29 -- Changed....
30 -- previous version y.y
31 -- Changed....
32 -- .
33 -- .
34 -- previous version 2.0
35 -- Changed....
36 -- Initial version 1.0
37 --
38 -- Notes : Note text
39 --
40 -- End of comments
41
42 Type WO_Billing_Rec_Type is RECORD
43 (
44 organization_id number,
45 customer_id number,
46 bill_to_address_id number,
47 wip_entity_id number,
48 operation_seq_num number,
49 inventory_item_id number,
50 resource_id number,
51 billed_inventory_item_id number,
52 billed_uom_code varchar2(3),
53 billed_quantity number,
54 price_list_header_id number,
55 cost_type_id number,
56 cost_or_listprice number,
57 costplus_percentage number,
58 billed_amount number,
59 invoice_trx_number number,
60 invoice_line_number number,
61 currency_code varchar2(15),
62 conversion_rate number,
63 conversion_type_code varchar2(30),
64 conversion_rate_date date,
65 project_id number,
66 task_id number,
67 work_request_id number,
68 pa_event_id number,
69 billing_basis number,
70 billing_method number
71 );
72
73
74 Type WO_Billing_RA_Rec_Type is RECORD
75 (
76 wip_entity_id varchar2(30),
77 wip_entity_name varchar2(30),
78 invoice_num varchar2(30),
79 line_num varchar2(30),
80 work_request varchar2(30),
81 project_id varchar2(30),
82 task_id varchar2(30),
83 currency_code varchar2(15),
84 billed_amount number,
85 customer_id number,
86 bill_to_address number,
87 conversion_type varchar2(30),
88 conversion_date date,
89 conversion_rate number,
90 quantity number,
91 billed_inventory_item_id number,
92 uom_code varchar2(3),
93 org_id number,
94 party_id number,
95 unit_selling_price number
96 );
97
98 Type WO_Billing_PA_Event_Rec_Type is RECORD
99 (
100 task_id number,
101 event_num number,
102 project_id number,
103 organization_id number,
104 event_id number,
105 wip_entity_id varchar2(240),
106 wip_entity_name varchar2(240),
107 work_request_id varchar2(240),
108 service_request_id varchar2(240),
109 billing_currency_code varchar2(15),
110 bill_trans_bill_amount number,
111 bill_trans_rev_amount number
112 );
113
114
115 PROCEDURE insert_AR_Interface
116 ( p_api_version IN NUMBER ,
117 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
118 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
119 p_validation_level IN NUMBER :=
120 FND_API.G_VALID_LEVEL_FULL ,
121 x_return_status OUT NOCOPY VARCHAR2 ,
122 x_msg_count OUT NOCOPY NUMBER ,
123 x_msg_data OUT NOCOPY VARCHAR2 ,
124 p_ra_line IN WO_Billing_RA_Rec_Type
125 );
126
127
128 PROCEDURE insert_WOB_Table
129 ( p_api_version IN NUMBER ,
130 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
131 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
132 p_validation_level IN NUMBER :=
133 FND_API.G_VALID_LEVEL_FULL ,
134 x_return_status OUT NOCOPY VARCHAR2 ,
135 x_msg_count OUT NOCOPY NUMBER ,
136 x_msg_data OUT NOCOPY VARCHAR2 ,
137 p_wob_rec IN WO_Billing_Rec_Type
138 );
139
140
141 /*
142
143 PROCEDURE insert_PAEvent_Table
144 ( p_api_version IN NUMBER
145 ,
146 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
147 p_commit IN VARCHAR2 := FND_API.G_FALSE
148 ,
149 p_validation_level IN NUMBER :=
150 FND_API.G_VALID_LEVEL_FULL
151 ,
152 x_return_status OUT NOCOPY VARCHAR2 ,
153 x_msg_count OUT NOCOPY NUMBER
154 ,
155 x_msg_data OUT NOCOPY VARCHAR2
156 ,
157 p_pa_rec IN WO_Billing_PA_Event_Rec_Type
158 );
159
160 */
161
162 END;
163
164