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 850: fnd_profile_revenue_orig_rate := NVL(fnd_profile.value_specific('PA_REVENUE_ORIGINAL_RATE_FORRECALC'),'N');

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

Line 980: IF fnd_profile_revenue_orig_rate = 'Y' THEN

976:
977: l_previous_project_rate_date := NULL;
978: l_previous_projfunc_rate_date:= NULL;
979:
980: IF fnd_profile_revenue_orig_rate = 'Y' THEN
981:
982: begin
983: l_previous_project_rate_date := NULL;
984: l_previous_projfunc_rate_date:= NULL;

Line 1005: IF fnd_profile_revenue_orig_rate = 'Y' THEN

1001: IF (l_project_rate_date_code = 'PA_INVOICE_DATE') THEN
1002: /* Code commented for bug 5907315
1003: l_project_rate_date_tab(I) := l_pa_date;
1004: The statement is modified as below */
1005: IF fnd_profile_revenue_orig_rate = 'Y' THEN
1006: l_project_rate_date_tab(I) := NVL(l_previous_project_rate_date,l_pa_date);
1007: ELSE
1008: l_project_rate_date_tab(I) := l_pa_date;
1009: END IF;

Line 1021: IF fnd_profile_revenue_orig_rate = 'Y' THEN

1017: IF (l_projfunc_rate_date_code = 'PA_INVOICE_DATE') THEN
1018: /* Code commented for bug 5907315
1019: l_projfunc_rate_date_tab(I) := l_pa_date;
1020: The statement is modified as below */
1021: IF fnd_profile_revenue_orig_rate = 'Y' THEN
1022: l_projfunc_rate_date_tab(I) := NVL(l_previous_projfunc_rate_date,l_pa_date);
1023: ELSE
1024: l_projfunc_rate_date_tab(I) := l_pa_date;
1025: END IF;

Line 1681: IF fnd_profile_revenue_orig_rate = 'Y' THEN

1677: /* Copy the funding rate date to array variable */
1678: /* Code added for bug 5907315 */
1679: l_previous_funding_rate_date := NULL;
1680:
1681: IF fnd_profile_revenue_orig_rate = 'Y' THEN
1682: l_previous_funding_rate_date := pa_date(l_ei_date_tab(I));
1683: END IF;
1684: /* End of code. Bug 5907315 */
1685:

Line 1689: IF fnd_profile_revenue_orig_rate = 'Y' THEN

1685:
1686: /* Code commented for bug 5907315
1687: l_funding_rev_rate_date_tab(I) := l_funding_rate_date;
1688: The statement is modified as below */
1689: IF fnd_profile_revenue_orig_rate = 'Y' THEN
1690: l_funding_rev_rate_date_tab(I) := nvl(l_previous_funding_rate_date,l_funding_rate_date);
1691: ELSE
1692: l_funding_rev_rate_date_tab(I) := l_funding_rate_date;
1693: END IF;