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_PKG dependencies on PA_BUDGET_VERSIONS

Line 245: g_fclc_budget_version_id pa_budget_versions.budget_version_id%type := null;

241: g_pkt_p_acct_time_phase_code VARCHAR2(20) := null;
242: ------- end of performance varibales declrartions
243:
244: --Bug 5964934
245: g_fclc_budget_version_id pa_budget_versions.budget_version_id%type := null;
246: g_fclc_project_id pa_budgetary_controls.project_id%type := null;
247: g_fclc_top_task_id pa_budgetary_controls.top_task_id%type := null;
248: g_fclc_task_id pa_budgetary_controls.task_id%type := null;
249: g_fclc_parent_member_id pa_budgetary_controls.parent_member_id%type := null;

Line 6031: pa_budget_versions pbv,

6027: nvl(list.GROUP_RESOURCE_TYPE_ID,0) GROUP_RESOURCE_TYPE_ID, /* added for bug fix2658952 */
6028: pbc.ext_bdgt_flag
6029: FROM
6030: pa_bc_packets pbc,
6031: pa_budget_versions pbv,
6032: pa_budget_entry_methods pm,
6033: pa_budgetary_control_options pb,
6034: pa_projects_all pp,
6035: pa_resource_list_members rlm,

Line 6892: ,pa_budget_versions bv

6888:
6889: CURSOR res_fcl IS
6890: SELECT funds_control_level_code
6891: FROM pa_budgetary_controls pbc
6892: ,pa_budget_versions bv
6893: WHERE bv.budget_version_id = p_budget_version_id
6894: AND bv.project_id = pbc.project_id
6895: AND bv.budget_type_code = pbc.budget_type_code
6896: AND pbc.project_id = p_project_id

Line 6910: ,pa_budget_versions bv

6906:
6907: CURSOR res_grp_fcl IS
6908: SELECT funds_control_level_code
6909: FROM pa_budgetary_controls pbc
6910: ,pa_budget_versions bv
6911: WHERE bv.budget_version_id = p_budget_version_id
6912: AND bv.project_id = pbc.project_id
6913: AND bv.budget_type_code = pbc.budget_type_code
6914: AND pbc.project_id = p_project_id

Line 6924: ,pa_budget_versions bv

6920:
6921: CURSOR task_fcl IS
6922: SELECT funds_control_level_code
6923: FROM pa_budgetary_controls pbc
6924: ,pa_budget_versions bv
6925: WHERE bv.budget_version_id = p_budget_version_id
6926: AND bv.project_id = pbc.project_id
6927: AND bv.budget_type_code = pbc.budget_type_code
6928: AND pbc.project_id = p_project_id

Line 6937: ,pa_budget_versions bv

6933:
6934: CURSOR top_task_fcl IS
6935: SELECT funds_control_level_code
6936: FROM pa_budgetary_controls pbc
6937: ,pa_budget_versions bv
6938: WHERE bv.budget_version_id = p_budget_version_id
6939: AND bv.project_id = pbc.project_id
6940: AND bv.budget_type_code = pbc.budget_type_code
6941: AND pbc.project_id = p_project_id

Line 6950: ,pa_budget_versions bv

6946:
6947: CURSOR project_fcl IS
6948: SELECT funds_control_level_code
6949: FROM pa_budgetary_controls pbc
6950: ,pa_budget_versions bv
6951: WHERE bv.budget_version_id = p_budget_version_id
6952: AND bv.project_id = pbc.project_id
6953: AND bv.budget_type_code = pbc.budget_type_code
6954: AND pbc.project_id = p_project_id

Line 7626: pa_budget_versions bv,

7622: bv.resource_list_id,
7623: pbc.vendor_id
7624: FROM pa_bc_packets pbc,
7625: pa_projects_all pp,
7626: pa_budget_versions bv,
7627: pa_budget_entry_methods pm,
7628: pa_expenditure_types type,
7629: pa_expenditure_items_all ei
7630: WHERE pbc.packet_id = p_packet_id

Line 7756: FROM pa_budget_versions bv

7752: SELECT distinct bv.resource_list_id
7753: ,bv.budget_version_id
7754: ,bv.project_id
7755: ,NVL(pm.categorization_code,'N') resource_category_code
7756: FROM pa_budget_versions bv
7757: ,pa_budget_entry_methods pm
7758: ,pa_bc_packets pkt
7759: WHERE pkt.packet_id = p_packet_id
7760: AND bv.budget_version_id = pkt.budget_version_id

Line 8340: pa_budget_versions bv,

8336: -- pbc.burden_method_code) burden_method_code,
8337: pbc.budget_line_id,
8338: pbc.budget_ccid
8339: FROM pa_bc_packets pbc,
8340: pa_budget_versions bv,
8341: pa_budget_entry_methods pm,
8342: pa_budgetary_control_options pb
8343: WHERE pbc.packet_id = p_packet_id
8344: AND pbc.budget_version_id = bv.budget_version_id

Line 8378: pa_budget_versions pv

8374: fund_control_level_task ,
8375: fund_control_level_res_grp,
8376: fund_control_level_res
8377: from pa_budgetary_control_options pb,
8378: pa_budget_versions pv
8379: where pv.project_id = pb.project_id
8380: AND pb.BDGT_CNTRL_FLAG = 'Y'
8381: AND pb.BUDGET_TYPE_CODE = pv.budget_type_code
8382: AND pv.budget_version_id = bud_version_id;

Line 9494: FROM pa_budget_versions

9490: l_wf_status varchar2(25) := null;
9491:
9492: cursor check_bdgt_baseline is
9493: SELECT wf_status_code
9494: FROM pa_budget_versions
9495: WHERE project_id = p_project_id
9496: AND wf_status_code is NOT NULL;
9497:
9498:

Line 14887: l_bvid_for_acct_changed_API pa_budget_versions.budget_Version_id%type;

14883: t_raid TypeNum;
14884: t_gl_rowid rowidtabtyp;
14885: t_budget_rowid rowidtabtyp;
14886: t_budget_start_date TypeDate;
14887: l_bvid_for_acct_changed_API pa_budget_versions.budget_Version_id%type;
14888:
14889: l_count NUMBER(4);
14890: l_validation_failed VARCHAR2(1);
14891: l_set_of_books_id pa_implementations_all.set_of_books_id%type;

Line 14893: l_current_budget_version_id pa_budget_versions.budget_version_id%TYPE;

14889: l_count NUMBER(4);
14890: l_validation_failed VARCHAR2(1);
14891: l_set_of_books_id pa_implementations_all.set_of_books_id%type;
14892: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
14893: l_current_budget_version_id pa_budget_versions.budget_version_id%TYPE;
14894: l_draft_budget_version_id pa_budget_versions.budget_version_id%TYPE;
14895: l_result_code pa_bc_packets.result_code%TYPE;
14896: l_acct_changed VARCHAR2(1);
14897: l_draft_acct_changed_flag VARCHAR2(1);

Line 14894: l_draft_budget_version_id pa_budget_versions.budget_version_id%TYPE;

14890: l_validation_failed VARCHAR2(1);
14891: l_set_of_books_id pa_implementations_all.set_of_books_id%type;
14892: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
14893: l_current_budget_version_id pa_budget_versions.budget_version_id%TYPE;
14894: l_draft_budget_version_id pa_budget_versions.budget_version_id%TYPE;
14895: l_result_code pa_bc_packets.result_code%TYPE;
14896: l_acct_changed VARCHAR2(1);
14897: l_draft_acct_changed_flag VARCHAR2(1);
14898: l_record_updated_flag VARCHAR2(1);

Line 14899: l_project_id pa_budget_versions.project_id%type;

14895: l_result_code pa_bc_packets.result_code%TYPE;
14896: l_acct_changed VARCHAR2(1);
14897: l_draft_acct_changed_flag VARCHAR2(1);
14898: l_record_updated_flag VARCHAR2(1);
14899: l_project_id pa_budget_versions.project_id%type;
14900: l_txn_exists_bc_pkt_flag VARCHAR2(1);
14901: l_txn_exists_bc_cmt_flag VARCHAR2(1);
14902: l_gl_failure_flag VARCHAR2(1);
14903: l_derive_draft_values VARCHAR2(1);

Line 15117: from pa_budget_versions pbv

15113: -- Get the draft or working budget ..
15114:
15115: Select pbv.budget_version_id
15116: into l_draft_budget_version_id
15117: from pa_budget_versions pbv
15118: where (pbv.project_id,pbv.budget_type_code) in
15119: (select project_id,budget_type_code
15120: from pa_budget_versions
15121: where budget_version_id = l_current_budget_version_id)

Line 15120: from pa_budget_versions

15116: into l_draft_budget_version_id
15117: from pa_budget_versions pbv
15118: where (pbv.project_id,pbv.budget_type_code) in
15119: (select project_id,budget_type_code
15120: from pa_budget_versions
15121: where budget_version_id = l_current_budget_version_id)
15122: and pbv.budget_status_code = decode(pa_budget_fund_pkg.g_processing_mode,
15123: 'YEAR_END','W','S');
15124:

Line 15155: pa_budget_versions pbv

15151:
15152: select pbem.entry_level_code
15153: into l_budget_entry_level_code
15154: from pa_budget_entry_methods pbem,
15155: pa_budget_versions pbv
15156: where pbv.budget_version_id = l_current_budget_version_id
15157: and pbem.budget_entry_method_code = pbv.budget_entry_method_code;
15158:
15159: End If;

Line 15220: select project_id into l_project_id from pa_budget_versions

15216: l_program_name := 'Do_budget_baseline_tieback';
15217: log_message(p_msg_token1=>l_program_name||'Get Project Id');
15218: End If;
15219:
15220: select project_id into l_project_id from pa_budget_versions
15221: where budget_version_id = l_current_budget_version_id;
15222:
15223: -- 1.9: If processing mode is BASELINE (and its a rebaseline, check if there are
15224: -- txns. against the project, if yes, set flag to 'Y' else 'N')