DBA Data[Home] [Help]

PACKAGE: APPS.OKE_BILLING_EVENT_PUB

Source


1 PACKAGE OKE_BILLING_EVENT_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKEPDBLS.pls 120.0.12020000.2 2013/02/22 06:33:05 ansraj noship $ */
3 /*
4  * This is public interface to create, update and delete project contract billing events.
5  * metalink 234864.1 See OracleMetaLink bulletin 234864.1
6  * scope public
7  * lifecycle active
8  * displayname Create Project Contract Deliverable
9  * category BUSINESS_ENTITY OKE_CONTRACT
10  */
11 
12 
13  G_PKG_NAME     CONSTANT VARCHAR2(200) := 'OKE_BILLING_EVENT_PUB';
14  G_MODULE                     CONSTANT   VARCHAR2(200) := 'oke.plsql.'||G_PKG_NAME||'.';
15  G_APP_NAME     CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;
16 
17 
18 TYPE k_billing_event_rec_type IS RECORD (
19 BILLING_EVENT_ID OKE_K_BILLING_EVENTS.BILLING_EVENT_ID%type := OKE_API.G_MISS_NUM,
20 CREATION_DATE OKE_K_BILLING_EVENTS.CREATION_DATE%type := OKE_API.G_MISS_DATE,
21 CREATED_BY OKE_K_BILLING_EVENTS.CREATED_BY%type := OKE_API.G_MISS_NUM,
22 LAST_UPDATE_DATE OKE_K_BILLING_EVENTS.LAST_UPDATE_DATE%type := OKE_API.G_MISS_DATE,
23 LAST_UPDATED_BY OKE_K_BILLING_EVENTS.LAST_UPDATED_BY%type := OKE_API.G_MISS_NUM,
24 LAST_UPDATE_LOGIN OKE_K_BILLING_EVENTS.LAST_UPDATE_LOGIN%type := OKE_API.G_MISS_NUM,
25 K_HEADER_ID OKE_K_BILLING_EVENTS.K_HEADER_ID%type := OKE_API.G_MISS_NUM,
26 K_LINE_ID OKE_K_BILLING_EVENTS.K_LINE_ID%type := OKE_API.G_MISS_NUM,
27 DELIVERABLE_ID OKE_K_BILLING_EVENTS.DELIVERABLE_ID%type := OKE_API.G_MISS_NUM,
28 BILL_EVENT_DATE OKE_K_BILLING_EVENTS.BILL_EVENT_DATE%type := OKE_API.G_MISS_DATE,
29 BILL_EVENT_TYPE OKE_K_BILLING_EVENTS.BILL_EVENT_TYPE%type := OKE_API.G_MISS_CHAR,
30 PA_EVENT_ID OKE_K_BILLING_EVENTS.PA_EVENT_ID%type := OKE_API.G_MISS_NUM,
31 BILL_ITEM_ID OKE_K_BILLING_EVENTS.BILL_ITEM_ID%type := OKE_API.G_MISS_NUM,
32 BILL_LINE_ID OKE_K_BILLING_EVENTS.BILL_LINE_ID%type := OKE_API.G_MISS_NUM,
33 BILL_CHG_REQ_ID OKE_K_BILLING_EVENTS.BILL_CHG_REQ_ID%type := OKE_API.G_MISS_NUM,
34 BILL_PROJECT_ID OKE_K_BILLING_EVENTS.BILL_PROJECT_ID%type := OKE_API.G_MISS_NUM,
35 BILL_TASK_ID OKE_K_BILLING_EVENTS.BILL_TASK_ID%type := OKE_API.G_MISS_NUM,
36 BILL_ORGANIZATION_ID OKE_K_BILLING_EVENTS.BILL_ORGANIZATION_ID%type := OKE_API.G_MISS_NUM,
37 BILL_FUND_REF1 OKE_K_BILLING_EVENTS.BILL_FUND_REF1%type := OKE_API.G_MISS_CHAR,
38 BILL_FUND_REF2 OKE_K_BILLING_EVENTS.BILL_FUND_REF2%type := OKE_API.G_MISS_CHAR,
39 BILL_FUND_REF3 OKE_K_BILLING_EVENTS.BILL_FUND_REF3%type := OKE_API.G_MISS_CHAR,
40 BILL_BILL_OF_LADING OKE_K_BILLING_EVENTS.BILL_BILL_OF_LADING%type := OKE_API.G_MISS_CHAR,
41 BILL_SERIAL_NUM OKE_K_BILLING_EVENTS.BILL_SERIAL_NUM%type := OKE_API.G_MISS_CHAR,
42 BILL_CURRENCY_CODE OKE_K_BILLING_EVENTS.BILL_CURRENCY_CODE%type := OKE_API.G_MISS_CHAR,
43 BILL_RATE_TYPE OKE_K_BILLING_EVENTS.BILL_RATE_TYPE%type := OKE_API.G_MISS_CHAR,
44 BILL_RATE_DATE OKE_K_BILLING_EVENTS.BILL_RATE_DATE%type := OKE_API.G_MISS_DATE,
45 BILL_EXCHANGE_RATE OKE_K_BILLING_EVENTS.BILL_EXCHANGE_RATE%type := OKE_API.G_MISS_NUM,
46 BILL_DESCRIPTION OKE_K_BILLING_EVENTS.BILL_DESCRIPTION%type := OKE_API.G_MISS_CHAR,
47 BILL_QUANTITY OKE_K_BILLING_EVENTS.BILL_QUANTITY%type := OKE_API.G_MISS_NUM,
48 BILL_UNIT_PRICE OKE_K_BILLING_EVENTS.BILL_UNIT_PRICE%type := OKE_API.G_MISS_NUM,
49 REVENUE_AMOUNT OKE_K_BILLING_EVENTS.REVENUE_AMOUNT%type := OKE_API.G_MISS_NUM,
50 ATTRIBUTE_CATEGORY OKE_K_BILLING_EVENTS.ATTRIBUTE_CATEGORY%type := OKE_API.G_MISS_CHAR,
51 ATTRIBUTE1 OKE_K_BILLING_EVENTS.ATTRIBUTE1%type := OKE_API.G_MISS_CHAR,
52 ATTRIBUTE2 OKE_K_BILLING_EVENTS.ATTRIBUTE2%type := OKE_API.G_MISS_CHAR,
53 ATTRIBUTE3 OKE_K_BILLING_EVENTS.ATTRIBUTE3%type := OKE_API.G_MISS_CHAR,
54 ATTRIBUTE4 OKE_K_BILLING_EVENTS.ATTRIBUTE4%type := OKE_API.G_MISS_CHAR,
55 ATTRIBUTE5 OKE_K_BILLING_EVENTS.ATTRIBUTE5%type := OKE_API.G_MISS_CHAR,
56 ATTRIBUTE6 OKE_K_BILLING_EVENTS.ATTRIBUTE6%type := OKE_API.G_MISS_CHAR,
57 ATTRIBUTE7 OKE_K_BILLING_EVENTS.ATTRIBUTE7%type := OKE_API.G_MISS_CHAR,
58 ATTRIBUTE8 OKE_K_BILLING_EVENTS.ATTRIBUTE8%type := OKE_API.G_MISS_CHAR,
59 ATTRIBUTE9 OKE_K_BILLING_EVENTS.ATTRIBUTE9%type := OKE_API.G_MISS_CHAR,
60 ATTRIBUTE10 OKE_K_BILLING_EVENTS.ATTRIBUTE10%type := OKE_API.G_MISS_CHAR,
61 ATTRIBUTE11 OKE_K_BILLING_EVENTS.ATTRIBUTE11%type := OKE_API.G_MISS_CHAR,
62 ATTRIBUTE12 OKE_K_BILLING_EVENTS.ATTRIBUTE12%type := OKE_API.G_MISS_CHAR,
63 ATTRIBUTE13 OKE_K_BILLING_EVENTS.ATTRIBUTE13%type := OKE_API.G_MISS_CHAR,
64 ATTRIBUTE14 OKE_K_BILLING_EVENTS.ATTRIBUTE14%type := OKE_API.G_MISS_CHAR,
65 ATTRIBUTE15 OKE_K_BILLING_EVENTS.ATTRIBUTE15%type := OKE_API.G_MISS_CHAR,
66 INITIATED_FLAG OKE_K_BILLING_EVENTS.INITIATED_FLAG%type := OKE_API.G_MISS_CHAR
67 );
68 
69 /*
70  * Create Contract Billing Event.
71  * metalink 234864.1 See OracleMetaLink bulletin 234864.1
72  * scope public
73  * lifecycle active
74  * displayname Create Project Contract Deliverable
75  * category BUSINESS_ENTITY OKE_CONTRACT
76  */
77 PROCEDURE create_k_billing_event(p_api_version IN NUMBER,
78                                  p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
79                                  p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,
80                                  x_k_billing_event_rec OUT NOCOPY OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,
81                                  x_return_status OUT NOCOPY VARCHAR2,
82                                  x_msg_count   OUT NOCOPY NUMBER,
83                                  x_msg_data OUT NOCOPY VARCHAR2
84                                 );
85 
86 /*
87  * Update Contract Billing Event.
88  * metalink 234864.1 See OracleMetaLink bulletin 234864.1
89  * scope public
90  * lifecycle active
91  * displayname Create Project Contract Deliverable
92  * category BUSINESS_ENTITY OKE_CONTRACT
93  */
94 PROCEDURE update_k_billing_event(p_api_version IN NUMBER,
95                                  p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
96                                  p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,
97                                  x_return_status OUT NOCOPY VARCHAR2,
98                                  x_msg_count   OUT NOCOPY NUMBER,
99                                  x_msg_data OUT NOCOPY VARCHAR2
100                                 );
101 
102 /*
103  * Deletes a Contract Billing Event.
104  * metalink 234864.1 See OracleMetaLink bulletin 234864.1
105  * scope public
106  * lifecycle active
107  * displayname Create Project Contract Deliverable
108  * category BUSINESS_ENTITY OKE_CONTRACT
109  */
110 
111 PROCEDURE delete_k_billing_event(p_api_version IN NUMBER,
112                                  p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
113                                  p_billing_event_id IN NUMBER,
114                                  x_return_status OUT NOCOPY VARCHAR2,
115                                  x_msg_count   OUT NOCOPY NUMBER,
116                                  x_msg_data OUT NOCOPY VARCHAR2
117                                 );
118 END  OKE_BILLING_EVENT_PUB;