[Home] [Help]
PACKAGE: APPS.PA_EVENT_RC_CLIENT_EXTN
Source
1 PACKAGE pa_event_rc_client_extn AUTHID CURRENT_USER AS
2 /* $Header: PAEVTRCS.pls 120.1 2005/08/19 16:22:46 mwasowic noship $ */
3
4
5 TYPE event_record IS RECORD (
6 task_id pa_events.task_id%TYPE,
7 event_num NUMBER(15),
8 last_update_date DATE,
9 last_updated_by NUMBER,
10 creation_date DATE,
11 created_by NUMBER(15),
12 last_update_login NUMBER(15),
13 event_type VARCHAR2(30),
14 description VARCHAR2(240),
15 bill_amount NUMBER,
16 revenue_amount NUMBER,
17 revenue_distributed_flag VARCHAR2(1),
18 bill_hold_flag pa_events.bill_hold_flag%TYPE,
19 completion_date pa_events.completion_date%TYPE,
20 rev_dist_rejection_code pa_events.rev_dist_rejection_code%TYPE,
21 request_id pa_events.request_id%TYPE,
22 program_application_id pa_events.program_application_id%TYPE,
23 program_id pa_events.program_id%TYPE,
24 program_update_date pa_events.program_update_date%TYPE,
25 attribute_category pa_events.attribute_category%TYPE,
26 attribute1 pa_events.attribute1%TYPE,
27 attribute2 pa_events.attribute2%TYPE,
28 attribute3 pa_events.attribute3%TYPE,
29 attribute4 pa_events.attribute4%TYPE,
30 attribute5 pa_events.attribute5%TYPE,
31 attribute6 pa_events.attribute6%TYPE,
32 attribute7 pa_events.attribute7%TYPE,
33 attribute8 pa_events.attribute8%TYPE,
34 attribute9 pa_events.attribute9%TYPE,
35 attribute10 pa_events.attribute10%TYPE,
36 project_id NUMBER(15),
37 organization_id NUMBER(15),
38 billing_assignment_id pa_events.billing_assignment_id%TYPE,
39 event_num_reversed pa_events.event_num_reversed%TYPE,
40 calling_place pa_events.calling_place%TYPE,
41 calling_process pa_events.calling_process%TYPE,
42 audit_cost_budget_type_code pa_events.audit_cost_budget_type_code%TYPE,
43 audit_rev_budget_type_code pa_events.audit_rev_budget_type_code%TYPE,
44 audit_amount1 pa_events.audit_amount1%TYPE,
45 audit_amount2 pa_events.audit_amount2%TYPE,
46 audit_amount3 pa_events.audit_amount3%TYPE,
47 audit_amount4 pa_events.audit_amount4%TYPE,
48 audit_amount5 pa_events.audit_amount5%TYPE,
49 audit_amount6 pa_events.audit_amount6%TYPE,
50 audit_amount7 pa_events.audit_amount7%TYPE,
51 audit_amount8 pa_events.audit_amount8%TYPE,
52 audit_amount9 pa_events.audit_amount9%TYPE,
53 audit_amount10 pa_events.audit_amount10%TYPE,
54 event_id NUMBER,
55 inventory_org_id pa_events.inventory_org_id%TYPE,
56 inventory_item_id pa_events.inventory_item_id%TYPE,
57 quantity_billed pa_events.quantity_billed%TYPE,
58 uom_code pa_events.uom_code%TYPE,
59 unit_price pa_events.unit_price%TYPE,
60 reference1 pa_events.reference1%TYPE,
61 reference2 pa_events.reference2%TYPE,
62 reference3 pa_events.reference3%TYPE,
63 reference4 pa_events.reference4%TYPE,
64 reference5 pa_events.reference5%TYPE,
65 reference6 pa_events.reference6%TYPE,
66 reference7 pa_events.reference7%TYPE,
67 reference8 pa_events.reference8%TYPE,
68 reference9 pa_events.reference9%TYPE,
69 reference10 pa_events.reference10%TYPE,
70 billed_flag pa_events.billed_flag%TYPE,
71 bill_trans_currency_code pa_events.bill_trans_currency_code%TYPE,
72 bill_trans_bill_amount pa_events.bill_trans_bill_amount%TYPE,
73 bill_trans_rev_amount pa_events.bill_trans_rev_amount%TYPE,
74 project_currency_code pa_events.project_currency_code%TYPE,
75 project_rate_type pa_events.project_rate_type%TYPE,
76 project_rate_date pa_events.project_rate_date%TYPE,
77 project_exchange_rate pa_events.project_exchange_rate%TYPE,
78 project_rev_rate_date pa_events.project_rev_rate_date%TYPE,
79 project_rev_exchange_rate pa_events.project_rev_exchange_rate%TYPE,
80 project_revenue_amount pa_events.project_revenue_amount%TYPE,
81 project_inv_rate_date pa_events.project_inv_rate_date%TYPE,
82 project_inv_exchange_rate pa_events.project_inv_exchange_rate%TYPE,
83 project_bill_amount pa_events.project_bill_amount%TYPE,
84 projfunc_currency_code pa_events.projfunc_currency_code%TYPE,
85 projfunc_rate_type pa_events.projfunc_rate_type%TYPE,
86 projfunc_rate_date pa_events.projfunc_rate_date%TYPE,
87 projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE,
88 projfunc_rev_rate_date pa_events.projfunc_rev_rate_date%TYPE,
89 projfunc_rev_exchange_rate pa_events.projfunc_rev_exchange_rate%TYPE,
90 projfunc_revenue_amount pa_events.projfunc_revenue_amount%TYPE,
91 projfunc_inv_rate_date pa_events.projfunc_inv_rate_date%TYPE,
92 projfunc_inv_exchange_rate pa_events.projfunc_inv_exchange_rate%TYPE,
93 projfunc_bill_amount pa_events.projfunc_bill_amount%TYPE,
94 funding_rate_type pa_events.funding_rate_type%TYPE,
95 funding_rate_date pa_events.funding_rate_date%TYPE,
96 funding_exchange_rate pa_events.funding_exchange_rate%TYPE,
97 revproc_currency_code pa_events.revproc_currency_code%TYPE,
98 revproc_rate_type pa_events.revproc_rate_type%TYPE,
99 revproc_rate_date pa_events.revproc_rate_date%TYPE,
100 revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE,
101 invproc_currency_code pa_events.invproc_currency_code%TYPE,
102 invproc_rate_type pa_events.invproc_rate_type%TYPE,
103 invproc_rate_date pa_events.invproc_rate_date%TYPE,
104 invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE,
105 inv_gen_rejection_code pa_events.inv_gen_rejection_code%TYPE,
106 adjusting_revenue_flag VARCHAR2(1),
107 adjust_revenue_flag VARCHAR2(1),
108 non_updateable_flag VARCHAR2(1),
109 project_funding_id NUMBER(15),
110 revenue_hold_flag VARCHAR2(1),
111 zero_revenue_amount_flag VARCHAR2(1)
112 );
113
114
115
116 PROCEDURE override_rsob_event_amount(
117 p_calling_mode IN VARCHAR2,
118 p_event_rec_old IN event_record,
119 p_event_rec_new IN event_record,
120 p_primary_set_of_books_id IN NUMBER,
121 p_primary_currency_code IN VARCHAR2,
122 p_reporting_set_of_books_id IN NUMBER,
123 p_reporting_currency_code IN VARCHAR2,
124 p_event_currency_code IN VARCHAR2,
125 p_rev_conversion_type IN VARCHAR2,
126 p_rev_conversion_date IN DATE,
127 p_rev_exchange_rate IN NUMBER,
128 p_bill_conversion_type IN VARCHAR2,
129 p_bill_conversion_date IN DATE,
130 p_bill_exchange_rate IN NUMBER,
131 p_rc_reval_revenue_amount IN NUMBER,
132 x_override_rev_amt_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
133 x_rev_amt_rate_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
134 x_rev_amt_rate_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
135 x_rev_amt_exchange_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
136 x_rc_revenue_amount OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
137 x_override_bill_amt_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
138 x_bill_amt_rate_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
139 x_bill_amt_rate_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
140 x_bill_amt_exchange_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
141 x_rc_bill_amount OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
142 x_event_description OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
143 x_error_message OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
144 x_status OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
145 );
146
147 END pa_event_rc_client_extn;