1 PACKAGE PA_MCB_REVENUE_PKG AS
2 --$Header: PAXMCRUS.pls 120.4 2007/12/28 11:59:21 hkansal ship $
3
4
5 G_LAST_UPDATE_LOGIN NUMBER;
6 G_REQUEST_ID NUMBER;
7 G_PROGRAM_APPLICATION_ID NUMBER;
8 G_PROGRAM_ID NUMBER;
9 G_LAST_UPDATED_BY NUMBER;
10 G_CREATED_BY NUMBER;
11 G_DEBUG_MODE VARCHAR2(1);
12 /* Variable added for bug 5907315 */
13 fnd_profile_revenue_orig_rate VARCHAR2(1) := 'N';
14
15
16 PROCEDURE event_amount_conversion( p_project_id IN NUMBER,
17 p_request_id IN NUMBER,
18 p_event_type IN VARCHAR2,
19 p_calling_place IN VARCHAR2,
20 p_acc_thru_dt IN DATE,
21 p_project_rate_date IN DATE,
22 p_projfunc_rate_date IN DATE,
23 x_return_status IN OUT NOCOPY VARCHAR2,
24 x_msg_count IN OUT NOCOPY NUMBER,
25 x_msg_data IN OUT NOCOPY VARCHAR2);
26
27
28 PROCEDURE ei_amount_conversion( p_project_id IN NUMBER,
29 p_ei_id IN PA_PLSQL_DATATYPES.IdTabTyp,
30 p_request_id IN NUMBER,
31 p_pa_date IN VARCHAR2,
32 x_return_status IN OUT NOCOPY VARCHAR2,
33 x_msg_count IN OUT NOCOPY NUMBER,
34 x_msg_data IN OUT NOCOPY VARCHAR2,
35 x_rej_reason IN OUT NOCOPY VARCHAR2);
36
37
38 PROCEDURE rdl_amount_conversion( p_project_id IN NUMBER,
39 p_request_id IN NUMBER,
40 p_ei_id IN PA_PLSQL_DATATYPES.IdTabTyp,
41 p_raw_revenue IN PA_PLSQL_DATATYPES.Char30TabTyp,
42 p_bill_trans_raw_revenue IN PA_PLSQL_DATATYPES.Char30TabTyp,
43 p_project_raw_revenue IN PA_PLSQL_DATATYPES.Char30TabTyp,
44 p_projfunc_raw_revenue IN PA_PLSQL_DATATYPES.Char30TabTyp,
45 p_funding_rate_date IN VARCHAR2,
46 x_return_status IN OUT NOCOPY VARCHAR2,
47 x_msg_count IN OUT NOCOPY NUMBER,
48 x_msg_data IN OUT NOCOPY VARCHAR2);
49
50
51 PROCEDURE erdl_amount_conversion( p_project_id IN NUMBER,
52 p_draft_revenue_num IN NUMBER,
53 p_btc_code IN VARCHAR2,
54 p_btc_amount IN VARCHAR2,
55 p_funding_rate_date IN VARCHAR2,
56 p_funding_curr_code IN VARCHAR2,
57 x_funding_rate_type IN OUT NOCOPY VARCHAR2,
58 x_funding_rate_date IN OUT NOCOPY VARCHAR2,
59 x_funding_exchange_rate IN OUT NOCOPY VARCHAR2,
60 x_funding_amount IN OUT NOCOPY VARCHAR2,
61 x_funding_convert_status IN OUT NOCOPY VARCHAR2,
62 p_projfunc_curr_code IN VARCHAR2,
63 p_projfunc_amount IN VARCHAR2,
64 p_projfunc_rate_type IN VARCHAR2,
65 p_projfunc_rate_date IN VARCHAR2,
66 p_projfunc_exch_rate IN VARCHAR2,
67 p_revtrans_curr_code IN VARCHAR2,
68 p_calling_place IN VARCHAR2,
69 x_revtrans_rate_type IN OUT NOCOPY VARCHAR2,
70 x_revtrans_rate_date IN OUT NOCOPY VARCHAR2,
71 x_revtrans_exch_rate IN OUT NOCOPY VARCHAR2,
72 x_revtrans_amount IN OUT NOCOPY VARCHAR2,
73 x_return_status IN OUT NOCOPY VARCHAR2,
74 x_msg_count IN OUT NOCOPY NUMBER,
75 x_msg_data IN OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE ei_fcst_amount_conversion(
79 p_project_id IN NUMBER,
80 p_ei_id IN PA_PLSQL_DATATYPES.IdTabTyp,
81 p_request_id IN NUMBER,
82 p_pa_date IN VARCHAR2,
83 x_return_status IN OUT NOCOPY VARCHAR2,
84 x_msg_count IN OUT NOCOPY NUMBER,
85 x_msg_data IN OUT NOCOPY VARCHAR2);
86
87
88 PROCEDURE log_message (p_log_msg IN VARCHAR2);
89
90 PROCEDURE Init (
91 P_DEBUG_MODE VARCHAR2);
92
93 /*----------------------------------------------------------------------------------------+
94 | Procedure : RTC_UBR_UER_CALC |
95 | Purpose : To compute transaction level ie, draft revenue level UBR/UER values in |
96 | Revenue transaction currency. |
97 | Parameters : |
98 | ================================================================================== |
99 | Name Mode Description |
100 | ================================================================================== |
101 | P_PFC_REV_AMOUNT IN Total revenue amount for a revenue in PFC |
102 | P_REVTRANS_AMOUNT IN Total revenue amount for a revenue in RTC |
103 | P_PROJFUNC_UBR IN UBR amount in project functional currency |
104 | P_PROJFUNC_UER IN UBR amount in project functional currency |
105 | P_UBR_CORR IN UBR correction amt in proj functional currency|
106 | P_UER_CORR IN UER correction amt in proj functional currency|
107 | P_REVTRANS_UBR OUT NOCOPY UBR amount in revenue transaction currency |
108 | P_REVTRANS_UER OUT NOCOPY UER amount in revenue transaction currency |
109 | X_RETURN_STATUS OUT NOCOPY Return status |
110 | X_MSG_COUNT OUT NOCOPY Error messages count |
111 | X_MSG_DATA OUT NOCOPY Error message |
112 | ================================================================================== |
113 +----------------------------------------------------------------------------------------*/
114 PROCEDURE RTC_UBR_UER_CALC(
115 P_PFC_REV_AMOUNT IN NUMBER,
116 P_REVTRANS_AMOUNT IN NUMBER,
117 P_PROJFUNC_UBR IN NUMBER,
118 P_PROJFUNC_UER IN NUMBER,
119 P_UBR_CORR IN NUMBER,
120 P_UER_CORR IN NUMBER,
121 P_REVTRANS_UBR OUT NOCOPY VARCHAR,
122 P_REVTRANS_UER OUT NOCOPY VARCHAR,
123 X_RETURN_STATUS OUT NOCOPY VARCHAR,
124 X_MSG_COUNT OUT NOCOPY NUMBER,
125 X_MSG_DATA OUT NOCOPY VARCHAR);
126
127 END PA_MCB_REVENUE_PKG;