[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;