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 10: g_input_bvid pa_budget_versions.budget_version_id%type;

6: G_PROJ_ID NUMBER;
7: G_FC_ENABLED VARCHAR2(1);
8:
9: -- For R12
10: g_input_bvid pa_budget_versions.budget_version_id%type;
11: g_current_baseline_bvid pa_budget_versions.budget_version_id%type;
12: g_api_project_id pa_budget_versions.project_id%type;
13: g_api_task_id pa_tasks.task_id%type;
14: g_api_top_task_id pa_tasks.top_task_id%type;

Line 11: g_current_baseline_bvid pa_budget_versions.budget_version_id%type;

7: G_FC_ENABLED VARCHAR2(1);
8:
9: -- For R12
10: g_input_bvid pa_budget_versions.budget_version_id%type;
11: g_current_baseline_bvid pa_budget_versions.budget_version_id%type;
12: g_api_project_id pa_budget_versions.project_id%type;
13: g_api_task_id pa_tasks.task_id%type;
14: g_api_top_task_id pa_tasks.top_task_id%type;
15: g_api_rlmi pa_resource_list_members.resource_list_member_id%type;

Line 12: g_api_project_id pa_budget_versions.project_id%type;

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

Line 565: l_bdgt_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;

561: ,p_calling_mode IN VARCHAR2 -- STD / CBC
562: ) return varchar2 IS
563:
564: l_fnd_chk_req_flag varchar2(20) := 'N';
565: l_bdgt_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
566: l_encum_type_id number(15) := null;
567: l_bdgt_link VARCHAR2(20) := 'N';
568: l_calling_mode VARCHAR2(20);
569: l_balance_type VARCHAR2(20);

Line 648: ) return PA_BUDGET_VERSIONS.budget_version_id%TYPE IS

644: -- -----------------------------------------------------------------------------------+
645: FUNCTION get_bdgt_version_id
646: (p_project_id IN NUMBER
647: ,p_calling_mode IN VARCHAR2 -- STD / CBC
648: ) return PA_BUDGET_VERSIONS.budget_version_id%TYPE IS
649:
650: l_fnd_chk_req_flag varchar2(20) := 'N';
651: l_bdgt_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
652: l_encum_type_id number(15) := null;

Line 651: l_bdgt_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;

647: ,p_calling_mode IN VARCHAR2 -- STD / CBC
648: ) return PA_BUDGET_VERSIONS.budget_version_id%TYPE IS
649:
650: l_fnd_chk_req_flag varchar2(20) := 'N';
651: l_bdgt_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
652: l_encum_type_id number(15) := null;
653: l_bdgt_link VARCHAR2(20) := 'N';
654: l_calling_mode VARCHAR2(20);
655: l_balance_type VARCHAR2(20);

Line 805: l_bdgt_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;

801: ,p_calling_mode IN VARCHAR2 -- STD / CBC
802: ) return varchar2 IS
803:
804: l_fnd_chk_req_flag varchar2(20) := 'N';
805: l_bdgt_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
806: l_encum_type_id number(15) := null;
807: l_bdgt_link VARCHAR2(20) := 'N';
808: l_calling_mode VARCHAR2(20);
809: l_balance_type VARCHAR2(20);

Line 957: pa_budget_versions b

953:
954: select time_phased_type_code
955: into x_time_phased_type_code
956: from pa_budget_entry_methods a,
957: pa_budget_versions b
958: where a.budget_entry_method_code = b.budget_entry_method_code
959: and b.budget_version_id = p_budget_version_id;
960:
961: IF P_DEBUG_MODE = 'Y' THEN

Line 996: from pa_budget_versions pbv,

992: END IF;
993:
994: select pbv.budget_version_id, pbv.resource_list_id, pbm.entry_level_code
995: into x_base_version_id,x_res_list_id,x_entry_level_code
996: from pa_budget_versions pbv,
997: --pa_budget_types pbt,
998: pa_budget_entry_methods pbm,
999: pa_budgetary_control_options pbco
1000: where pbv.project_id = p_project_id

Line 1097: from pa_budget_versions pbv,

1093: pa_fck_util.debug_msg('Is_Budget_Baselined_Before: ' || 'PB:Inside Is budget baselined before');
1094: END IF;
1095:
1096: select 1 into l_count
1097: from pa_budget_versions pbv,
1098: pa_budget_types pbt
1099: where pbv.project_id = p_project_id
1100: and pbv.budget_status_code = 'B'
1101: and pbv.budget_type_code = pbt.budget_type_code

Line 1193: from pa_budget_versions pbv

1189: -- -------------------------------------+
1190: Begin
1191: select pbv.budget_version_id,pbv.project_id
1192: into g_current_baseline_bvid,g_api_project_id
1193: from pa_budget_versions pbv
1194: where (pbv.project_id,pbv.budget_type_code) in
1195: (select project_id,budget_type_code
1196: from pa_budget_versions
1197: where budget_version_id = p_budget_version_id)

Line 1196: from pa_budget_versions

1192: into g_current_baseline_bvid,g_api_project_id
1193: from pa_budget_versions pbv
1194: where (pbv.project_id,pbv.budget_type_code) in
1195: (select project_id,budget_type_code
1196: from pa_budget_versions
1197: where budget_version_id = p_budget_version_id)
1198: and pbv.budget_status_code = 'B'
1199: and pbv.current_flag = 'Y';
1200: Exception

Line 1283: pa_budget_versions pbv

1279:
1280: select pbem.entry_level_code
1281: into l_budget_entry_level_code
1282: from pa_budget_entry_methods pbem,
1283: pa_budget_versions pbv
1284: where pbv.budget_version_id = P_budget_version_id
1285: and pbem.budget_entry_method_code = pbv.budget_entry_method_code;
1286:
1287:

Line 2087: pa_budget_versions pbv,

2083: p_bud_ver_id budget_version_id,
2084: NULL budget_line_id,
2085: 'C' gl_period_status
2086: FROM pa_bc_commitments bc,
2087: pa_budget_versions pbv,
2088: pa_budget_entry_methods bem,
2089: gl_period_statuses gl
2090: WHERE GL.application_id = 101
2091: AND GL.set_of_books_id = bc.set_of_books_id

Line 2116: pa_budget_versions pbv,

2112: p_bud_ver_id budget_version_id,
2113: NULL budget_line_id,
2114: DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',NULL) gl_period_status
2115: from pa_bc_commitments bc,
2116: pa_budget_versions pbv,
2117: pa_budget_entry_methods bem,
2118: gl_period_statuses gl
2119: WHERE GL.application_id = 101
2120: AND GL.set_of_books_id = bc.set_of_books_id