[Home] [Help]
PACKAGE: APPS.PA_MC_FUNDINGS_PKG
Source
1 PACKAGE PA_MC_FUNDINGS_PKG as
2 /* $Header: PAMRCFPS.pls 120.1 2005/08/05 00:24:00 rgandhi noship $ */
3
4
5 TYPE FundingLineRecord IS RECORD
6 (
7 project_funding_id pa_project_fundings.project_funding_id%TYPE,
8 last_update_date pa_project_fundings.last_update_date%TYPE,
9 last_updated_by pa_project_fundings.last_updated_by%TYPE,
10 creation_date pa_project_fundings.creation_date%TYPE,
11 created_by pa_project_fundings.created_by%TYPE,
12 last_update_login pa_project_fundings.last_update_login%TYPE,
13 agreement_id pa_project_fundings.agreement_id%TYPE,
14 project_id pa_project_fundings.project_id%TYPE,
15 task_id pa_project_fundings.task_id%TYPE,
16 budget_type_code pa_project_fundings.budget_type_code%TYPE,
17 allocated_amount pa_project_fundings.allocated_amount%TYPE,
18 date_allocated pa_project_fundings.date_allocated%TYPE,
19 attribute_category pa_project_fundings.attribute_category%TYPE,
20 attribute1 pa_project_fundings.attribute1%TYPE,
21 attribute2 pa_project_fundings.attribute2%TYPE,
22 attribute3 pa_project_fundings.attribute3%TYPE,
23 attribute4 pa_project_fundings.attribute4%TYPE,
24 attribute5 pa_project_fundings.attribute5%TYPE,
25 attribute6 pa_project_fundings.attribute6%TYPE,
26 attribute7 pa_project_fundings.attribute7%TYPE,
27 attribute8 pa_project_fundings.attribute8%TYPE,
28 attribute9 pa_project_fundings.attribute9%TYPE,
29 attribute10 pa_project_fundings.attribute10%TYPE,
30 pa_project_fundings_project_id pa_project_fundings.pa_project_fundings_project_id%TYPE,
31 pm_funding_reference pa_project_fundings.pm_funding_reference%TYPE,
32 pm_product_code pa_project_fundings.pm_product_code%TYPE,
33 funding_currency_code pa_project_fundings.funding_currency_code%TYPE,
34 project_currency_code pa_project_fundings.project_currency_code%TYPE,
35 project_rate_type pa_project_fundings.project_rate_type%TYPE,
36 project_rate_date pa_project_fundings.project_rate_date%TYPE,
37 project_exchange_rate pa_project_fundings.project_exchange_rate%TYPE,
38 project_allocated_amount pa_project_fundings.project_allocated_amount%TYPE,
39 projfunc_currency_code pa_project_fundings.projfunc_currency_code%TYPE,
40 projfunc_rate_type pa_project_fundings.projfunc_rate_type%TYPE,
41 projfunc_rate_date pa_project_fundings.projfunc_rate_date%TYPE,
42 projfunc_exchange_rate pa_project_fundings.projfunc_exchange_rate%TYPE,
43 projfunc_allocated_amount pa_project_fundings.projfunc_allocated_amount%TYPE,
44 invproc_currency_code pa_project_fundings.invproc_currency_code%TYPE,
45 invproc_rate_type pa_project_fundings.invproc_rate_type%TYPE,
46 invproc_rate_date pa_project_fundings.invproc_rate_date%TYPE,
47 invproc_exchange_rate pa_project_fundings.invproc_exchange_rate%TYPE,
48 invproc_allocated_amount pa_project_fundings.invproc_allocated_amount%TYPE,
49 revproc_currency_code pa_project_fundings.revproc_currency_code%TYPE,
50 revproc_rate_type pa_project_fundings.revproc_rate_type%TYPE,
51 revproc_rate_date pa_project_fundings.revproc_rate_date%TYPE,
52 revproc_exchange_rate pa_project_fundings.revproc_exchange_rate%TYPE,
53 revproc_allocated_amount pa_project_fundings.revproc_allocated_amount%TYPE,
54 funding_category pa_project_fundings.funding_category%TYPE,
55 pji_summarized_flag pa_project_fundings.pji_summarized_flag%TYPE
56 ,Revaluation_through_date pa_project_fundings.Revaluation_through_date%TYPE,
57 Revaluation_rate_date pa_project_fundings.Revaluation_rate_date%TYPE,
58 Revaluation_projfunc_rate_type pa_project_fundings.Revaluation_projfunc_rate_TYPE%TYPE,
59 Revaluation_invproc_rate_type pa_project_fundings.Revaluation_invproc_rate_type%TYPE,
60 Revaluation_projfunc_rate pa_project_fundings.Revaluation_projfunc_rate%TYPE,
61 Revaluation_invproc_rate pa_project_fundings.Revaluation_invproc_rate%TYPE,
62 Funding_Inv_Applied_Amount pa_project_fundings.Funding_Inv_Applied_Amount%TYPE,
63 Funding_Inv_Due_Amount pa_project_fundings.Funding_Inv_Due_Amount%TYPE,
64 Funding_backlog_amount pa_project_fundings.Funding_backlog_amount%TYPE,
65 ProjFunc_Realized_Gains_Amt pa_project_fundings.ProjFunc_Realized_Gains_Amt%TYPE,
66 ProjFunc_Realized_Losses_Amt pa_project_fundings.ProjFunc_Realized_Losses_Amt%TYPE,
67 ProjFunc_Inv_Applied_Amount pa_project_fundings.ProjFunc_Inv_Applied_Amount%TYPE,
68 ProjFunc_Inv_Due_Amount pa_project_fundings.ProjFunc_Inv_Due_Amount%TYPE,
69 ProjFunc_backlog_amount pa_project_fundings.ProjFunc_backlog_amount%TYPE,
70 Projfunc_Reval_Amount pa_project_fundings.Projfunc_Reval_Amount%TYPE,
71 Projfunc_Revalued_Amount pa_project_fundings.Projfunc_Revalued_Amount%TYPE,
72 Non_Updateable_Flag pa_project_fundings.Non_Updateable_Flag%TYPE,
73 InvProc_backlog_amount pa_project_fundings.InvProc_backlog_amount%TYPE,
74 Funding_Reval_Amount pa_project_fundings.Funding_Reval_Amount%TYPE,
75 Invproc_Reval_Amount pa_project_fundings.Invproc_Reval_Amount%TYPE,
76 Invproc_Revalued_Amount pa_project_fundings.Invproc_Revalued_Amount%TYPE,
77 Funding_revaluation_factor pa_project_fundings.Funding_revaluation_factor%TYPE,
78 Request_Id pa_project_fundings.Request_Id%TYPE,
79 program_application_id pa_project_fundings.program_application_id%TYPE,
80 program_id pa_project_fundings.program_id%TYPE,
81 program_update_date pa_project_fundings.program_update_date%TYPE
82 );
83
84 FUNCTION sum_mc_sob_cust_rdl_erdl(
85 p_project_id IN NUMBER,
86 p_draft_revenue_num IN NUMBER,
87 p_draft_revenue_item_line_num IN NUMBER,
88 p_set_of_books_id IN NUMBER
89 ) RETURN NUMBER;
90
91
92 --
93 -- Function : sum_mc_sob_cust_rdl_erdl
94 -- Purpose : This function returns the sum of RDL and ERDL for project, agreement, task
95 -- and set of books id in reporting.
96 -- Parameters :
97 --
98
99
100 FUNCTION check_mrc_install(
101 x_error_code OUT NOCOPY VARCHAR2 /*File.sql.39*/
102 ) RETURN BOOLEAN;
103
104
105 --
106 -- Function : check_mrc_install
107 -- Purpose : This function will check that MRC is installed or not if installed it will
108 -- return true otherwise false.
109 -- Parameters :
110 --
111
112
113
114 PROCEDURE upgrade_fundings_mrc(
115 p_upgrade_from_date IN DATE,
116 x_return_status OUT NOCOPY VARCHAR2,/*File.sql.39*/
117 x_msg_data OUT NOCOPY VARCHAR2,/*File.sql.39*/
118 x_msg_count OUT NOCOPY NUMBER/*File.sql.39*/);
119
120 --
121 -- Procedure : upgrade_fundings_mrc
122 -- Purpose : This procedure will populate the mrc funding lines table and mrc summary table
123 -- after converting all the records from primary. This procedure is being called
124 -- from concurrent process.
125 -- Parameters :
126 --
127
128 END PA_MC_FUNDINGS_PKG;
129