APPS.PA_MCB_REVENUE_PKG dependencies on FND_PROFILE

Line 28: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

24: +----------------------------------------------------------------------------------------*/
25:
26: /* Funding Revaluation Changes : Added the realized gain and loss event type */
27:
28: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
29: /* Fix for bug 5907315 starts here */
30: gl_pa_dt_st PA_PLSQL_DATATYPES.DateTabTyp;
31: gl_pa_dt_end PA_PLSQL_DATATYPES.DateTabTyp;
32:

Line 852: fnd_profile_revenue_orig_rate := NVL(fnd_profile.value_specific('PA_REVENUE_ORIGINAL_RATE_FORRECALC'),'N');

848:
849: END IF;
850:
851: /* Code added for bug 5907315 */
852: fnd_profile_revenue_orig_rate := NVL(fnd_profile.value_specific('PA_REVENUE_ORIGINAL_RATE_FORRECALC'),'N');
853: /* End of bug 5907315 */
854:
855:
856: /* cursor for select the expenditure details based on current request id */

Line 1023: IF fnd_profile_revenue_orig_rate = 'Y' THEN

1019:
1020: l_previous_project_rate_date := NULL;
1021: l_previous_projfunc_rate_date:= NULL;
1022:
1023: IF fnd_profile_revenue_orig_rate = 'Y' THEN
1024:
1025: begin
1026: l_previous_project_rate_date := NULL;
1027: l_previous_projfunc_rate_date:= NULL;

Line 1048: IF fnd_profile_revenue_orig_rate = 'Y' THEN

1044: IF (l_project_rate_date_code = 'PA_INVOICE_DATE') THEN
1045: /* Code commented for bug 5907315
1046: l_project_rate_date_tab(I) := l_pa_date;
1047: The statement is modified as below */
1048: IF fnd_profile_revenue_orig_rate = 'Y' THEN
1049: l_project_rate_date_tab(I) := NVL(l_previous_project_rate_date,l_pa_date);
1050: ELSE
1051: l_project_rate_date_tab(I) := l_pa_date;
1052: END IF;

Line 1064: IF fnd_profile_revenue_orig_rate = 'Y' THEN

1060: IF (l_projfunc_rate_date_code = 'PA_INVOICE_DATE') THEN
1061: /* Code commented for bug 5907315
1062: l_projfunc_rate_date_tab(I) := l_pa_date;
1063: The statement is modified as below */
1064: IF fnd_profile_revenue_orig_rate = 'Y' THEN
1065: l_projfunc_rate_date_tab(I) := NVL(l_previous_projfunc_rate_date,l_pa_date);
1066: ELSE
1067: l_projfunc_rate_date_tab(I) := l_pa_date;
1068: END IF;

Line 1724: IF fnd_profile_revenue_orig_rate = 'Y' THEN

1720: /* Copy the funding rate date to array variable */
1721: /* Code added for bug 5907315 */
1722: l_previous_funding_rate_date := NULL;
1723:
1724: IF fnd_profile_revenue_orig_rate = 'Y' THEN
1725: l_previous_funding_rate_date := pa_date(l_ei_date_tab(I));
1726: END IF;
1727: /* End of code. Bug 5907315 */
1728:

Line 1732: IF fnd_profile_revenue_orig_rate = 'Y' THEN

1728:
1729: /* Code commented for bug 5907315
1730: l_funding_rev_rate_date_tab(I) := l_funding_rate_date;
1731: The statement is modified as below */
1732: IF fnd_profile_revenue_orig_rate = 'Y' THEN
1733: l_funding_rev_rate_date_tab(I) := nvl(l_previous_funding_rate_date,l_funding_rate_date);
1734: ELSE
1735: l_funding_rev_rate_date_tab(I) := l_funding_rate_date;
1736: END IF;