DBA Data[Home] [Help]

APPS.PA_EVENT_PVT dependencies on PA_PROJECTS_ALL

Line 508: l_projfunc_rate_date pa_projects_all.projfunc_bil_rate_date%type;

504: ,P_event_type_classification OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
505: RETURN VARCHAR2
506: IS
507:
508: l_projfunc_rate_date pa_projects_all.projfunc_bil_rate_date%type;
509: l_project_rate_date pa_projects_all.project_bil_rate_date%type;
510: p_api_name VARCHAR2(100):='CHECK_CREATE_EVENT_OK';
511: l_funding_rate_type PA_EVENTS.funding_rate_type%TYPE;
512: l_proj_func_currency_code PA_EVENTS.projfunc_currency_code%TYPE;

Line 509: l_project_rate_date pa_projects_all.project_bil_rate_date%type;

505: RETURN VARCHAR2
506: IS
507:
508: l_projfunc_rate_date pa_projects_all.projfunc_bil_rate_date%type;
509: l_project_rate_date pa_projects_all.project_bil_rate_date%type;
510: p_api_name VARCHAR2(100):='CHECK_CREATE_EVENT_OK';
511: l_funding_rate_type PA_EVENTS.funding_rate_type%TYPE;
512: l_proj_func_currency_code PA_EVENTS.projfunc_currency_code%TYPE;
513: l_return_status VARCHAR2(1):='Y';

Line 1626: l_projfunc_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;

1622: AS
1623:
1624: l_proj_func_currency_code PA_EVENTS.projfunc_currency_code%TYPE;
1625: l_bill_trans_currency_code PA_EVENTS.bill_trans_currency_code%TYPE; -- Added bug 3013137
1626: l_projfunc_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
1627: l_project_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
1628: l_funding_rate_type PA_EVENTS.funding_rate_type%TYPE;
1629: l_return_status VARCHAR2(1):='Y';
1630: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

Line 1627: l_project_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;

1623:
1624: l_proj_func_currency_code PA_EVENTS.projfunc_currency_code%TYPE;
1625: l_bill_trans_currency_code PA_EVENTS.bill_trans_currency_code%TYPE; -- Added bug 3013137
1626: l_projfunc_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
1627: l_project_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
1628: l_funding_rate_type PA_EVENTS.funding_rate_type%TYPE;
1629: l_return_status VARCHAR2(1):='Y';
1630: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1631: l_ret_status VARCHAR2(2000):=NULL;