eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_BUDGET_VERSIONS

Line 7: g_input_bvid pa_budget_versions.budget_version_id%type;

3:
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: -- For R12
7: g_input_bvid pa_budget_versions.budget_version_id%type;
8: g_current_baseline_bvid pa_budget_versions.budget_version_id%type;
9: g_api_project_id pa_budget_versions.project_id%type;
10: g_api_task_id pa_tasks.task_id%type;
11: g_api_top_task_id pa_tasks.top_task_id%type;

Line 8: g_current_baseline_bvid pa_budget_versions.budget_version_id%type;

4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: -- For R12
7: g_input_bvid pa_budget_versions.budget_version_id%type;
8: g_current_baseline_bvid pa_budget_versions.budget_version_id%type;
9: g_api_project_id pa_budget_versions.project_id%type;
10: g_api_task_id pa_tasks.task_id%type;
11: g_api_top_task_id pa_tasks.top_task_id%type;
12: g_api_rlmi pa_resource_list_members.resource_list_member_id%type;

Line 9: g_api_project_id pa_budget_versions.project_id%type;

5:
6: -- For R12
7: g_input_bvid pa_budget_versions.budget_version_id%type;
8: g_current_baseline_bvid pa_budget_versions.budget_version_id%type;
9: g_api_project_id pa_budget_versions.project_id%type;
10: g_api_task_id pa_tasks.task_id%type;
11: g_api_top_task_id pa_tasks.top_task_id%type;
12: g_api_rlmi pa_resource_list_members.resource_list_member_id%type;
13: g_api_parent_rlmi pa_resource_list_members.parent_member_id%type;

Line 492: l_bdgt_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;

488: ,p_calling_mode IN VARCHAR2 -- STD / CBC
489: ) return varchar2 IS
490:
491: l_fnd_chk_req_flag varchar2(20) := 'N';
492: l_bdgt_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
493: l_encum_type_id number(15) := null;
494: l_bdgt_link VARCHAR2(20) := 'N';
495: l_calling_mode VARCHAR2(20);
496: l_balance_type VARCHAR2(20);

Line 557: ) return PA_BUDGET_VERSIONS.budget_version_id%TYPE IS

553: -- -----------------------------------------------------------------------------------+
554: FUNCTION get_bdgt_version_id
555: (p_project_id IN NUMBER
556: ,p_calling_mode IN VARCHAR2 -- STD / CBC
557: ) return PA_BUDGET_VERSIONS.budget_version_id%TYPE IS
558:
559: l_fnd_chk_req_flag varchar2(20) := 'N';
560: l_bdgt_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
561: l_encum_type_id number(15) := null;

Line 560: l_bdgt_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;

556: ,p_calling_mode IN VARCHAR2 -- STD / CBC
557: ) return PA_BUDGET_VERSIONS.budget_version_id%TYPE IS
558:
559: l_fnd_chk_req_flag varchar2(20) := 'N';
560: l_bdgt_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
561: l_encum_type_id number(15) := null;
562: l_bdgt_link VARCHAR2(20) := 'N';
563: l_calling_mode VARCHAR2(20);
564: l_balance_type VARCHAR2(20);

Line 676: l_bdgt_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;

672: ,p_calling_mode IN VARCHAR2 -- STD / CBC
673: ) return varchar2 IS
674:
675: l_fnd_chk_req_flag varchar2(20) := 'N';
676: l_bdgt_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
677: l_encum_type_id number(15) := null;
678: l_bdgt_link VARCHAR2(20) := 'N';
679: l_calling_mode VARCHAR2(20);
680: l_balance_type VARCHAR2(20);

Line 806: pa_budget_versions b

802:
803: select time_phased_type_code
804: into x_time_phased_type_code
805: from pa_budget_entry_methods a,
806: pa_budget_versions b
807: where a.budget_entry_method_code = b.budget_entry_method_code
808: and b.budget_version_id = p_budget_version_id;
809:
810: IF P_DEBUG_MODE = 'Y' THEN

Line 845: from pa_budget_versions pbv,

841: END IF;
842:
843: select pbv.budget_version_id, pbv.resource_list_id, pbm.entry_level_code
844: into x_base_version_id,x_res_list_id,x_entry_level_code
845: from pa_budget_versions pbv,
846: --pa_budget_types pbt,
847: pa_budget_entry_methods pbm,
848: pa_budgetary_control_options pbco
849: where pbv.project_id = p_project_id

Line 946: from pa_budget_versions pbv,

942: pa_fck_util.debug_msg('Is_Budget_Baselined_Before: ' || 'PB:Inside Is budget baselined before');
943: END IF;
944:
945: select 1 into l_count
946: from pa_budget_versions pbv,
947: pa_budget_types pbt
948: where pbv.project_id = p_project_id
949: and pbv.budget_status_code = 'B'
950: and pbv.budget_type_code = pbt.budget_type_code

Line 1042: from pa_budget_versions pbv

1038: -- -------------------------------------+
1039: Begin
1040: select pbv.budget_version_id,pbv.project_id
1041: into g_current_baseline_bvid,g_api_project_id
1042: from pa_budget_versions pbv
1043: where (pbv.project_id,pbv.budget_type_code) in
1044: (select project_id,budget_type_code
1045: from pa_budget_versions
1046: where budget_version_id = p_budget_version_id)

Line 1045: from pa_budget_versions

1041: into g_current_baseline_bvid,g_api_project_id
1042: from pa_budget_versions pbv
1043: where (pbv.project_id,pbv.budget_type_code) in
1044: (select project_id,budget_type_code
1045: from pa_budget_versions
1046: where budget_version_id = p_budget_version_id)
1047: and pbv.budget_status_code = 'B'
1048: and pbv.current_flag = 'Y';
1049: Exception

Line 1132: pa_budget_versions pbv

1128:
1129: select pbem.entry_level_code
1130: into l_budget_entry_level_code
1131: from pa_budget_entry_methods pbem,
1132: pa_budget_versions pbv
1133: where pbv.budget_version_id = P_budget_version_id
1134: and pbem.budget_entry_method_code = pbv.budget_entry_method_code;
1135:
1136:

Line 1936: pa_budget_versions pbv,

1932: p_bud_ver_id budget_version_id,
1933: NULL budget_line_id,
1934: 'C' gl_period_status
1935: FROM pa_bc_commitments bc,
1936: pa_budget_versions pbv,
1937: pa_budget_entry_methods bem,
1938: gl_period_statuses gl
1939: WHERE GL.application_id = 101
1940: AND GL.set_of_books_id = bc.set_of_books_id

Line 1965: pa_budget_versions pbv,

1961: p_bud_ver_id budget_version_id,
1962: NULL budget_line_id,
1963: DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',NULL) gl_period_status
1964: from pa_bc_commitments bc,
1965: pa_budget_versions pbv,
1966: pa_budget_entry_methods bem,
1967: gl_period_statuses gl
1968: WHERE GL.application_id = 101
1969: AND GL.set_of_books_id = bc.set_of_books_id