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 244: g_fclc_budget_version_id pa_budget_versions.budget_version_id%type := null;

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

Line 5888: pa_budget_versions pbv,

5884: nvl(list.GROUP_RESOURCE_TYPE_ID,0) GROUP_RESOURCE_TYPE_ID, /* added for bug fix2658952 */
5885: pbc.ext_bdgt_flag
5886: FROM
5887: pa_bc_packets pbc,
5888: pa_budget_versions pbv,
5889: pa_budget_entry_methods pm,
5890: pa_budgetary_control_options pb,
5891: pa_projects_all pp,
5892: pa_resource_list_members rlm,

Line 6725: ,pa_budget_versions bv

6721:
6722: CURSOR res_fcl IS
6723: SELECT funds_control_level_code
6724: FROM pa_budgetary_controls pbc
6725: ,pa_budget_versions bv
6726: WHERE bv.budget_version_id = p_budget_version_id
6727: AND bv.project_id = pbc.project_id
6728: AND bv.budget_type_code = pbc.budget_type_code
6729: AND pbc.project_id = p_project_id

Line 6743: ,pa_budget_versions bv

6739:
6740: CURSOR res_grp_fcl IS
6741: SELECT funds_control_level_code
6742: FROM pa_budgetary_controls pbc
6743: ,pa_budget_versions bv
6744: WHERE bv.budget_version_id = p_budget_version_id
6745: AND bv.project_id = pbc.project_id
6746: AND bv.budget_type_code = pbc.budget_type_code
6747: AND pbc.project_id = p_project_id

Line 6757: ,pa_budget_versions bv

6753:
6754: CURSOR task_fcl IS
6755: SELECT funds_control_level_code
6756: FROM pa_budgetary_controls pbc
6757: ,pa_budget_versions bv
6758: WHERE bv.budget_version_id = p_budget_version_id
6759: AND bv.project_id = pbc.project_id
6760: AND bv.budget_type_code = pbc.budget_type_code
6761: AND pbc.project_id = p_project_id

Line 6770: ,pa_budget_versions bv

6766:
6767: CURSOR top_task_fcl IS
6768: SELECT funds_control_level_code
6769: FROM pa_budgetary_controls pbc
6770: ,pa_budget_versions bv
6771: WHERE bv.budget_version_id = p_budget_version_id
6772: AND bv.project_id = pbc.project_id
6773: AND bv.budget_type_code = pbc.budget_type_code
6774: AND pbc.project_id = p_project_id

Line 6783: ,pa_budget_versions bv

6779:
6780: CURSOR project_fcl IS
6781: SELECT funds_control_level_code
6782: FROM pa_budgetary_controls pbc
6783: ,pa_budget_versions bv
6784: WHERE bv.budget_version_id = p_budget_version_id
6785: AND bv.project_id = pbc.project_id
6786: AND bv.budget_type_code = pbc.budget_type_code
6787: AND pbc.project_id = p_project_id

Line 7428: pa_budget_versions bv,

7424: bv.resource_list_id,
7425: pbc.vendor_id
7426: FROM pa_bc_packets pbc,
7427: pa_projects_all pp,
7428: pa_budget_versions bv,
7429: pa_budget_entry_methods pm,
7430: pa_expenditure_types type,
7431: pa_expenditure_items_all ei
7432: WHERE pbc.packet_id = p_packet_id

Line 7558: FROM pa_budget_versions bv

7554: SELECT distinct bv.resource_list_id
7555: ,bv.budget_version_id
7556: ,bv.project_id
7557: ,NVL(pm.categorization_code,'N') resource_category_code
7558: FROM pa_budget_versions bv
7559: ,pa_budget_entry_methods pm
7560: ,pa_bc_packets pkt
7561: WHERE pkt.packet_id = p_packet_id
7562: AND bv.budget_version_id = pkt.budget_version_id

Line 8118: pa_budget_versions bv,

8114: -- pbc.burden_method_code) burden_method_code,
8115: pbc.budget_line_id,
8116: pbc.budget_ccid
8117: FROM pa_bc_packets pbc,
8118: pa_budget_versions bv,
8119: pa_budget_entry_methods pm,
8120: pa_budgetary_control_options pb
8121: WHERE pbc.packet_id = p_packet_id
8122: AND pbc.budget_version_id = bv.budget_version_id

Line 8156: pa_budget_versions pv

8152: fund_control_level_task ,
8153: fund_control_level_res_grp,
8154: fund_control_level_res
8155: from pa_budgetary_control_options pb,
8156: pa_budget_versions pv
8157: where pv.project_id = pb.project_id
8158: AND pb.BDGT_CNTRL_FLAG = 'Y'
8159: AND pb.BUDGET_TYPE_CODE = pv.budget_type_code
8160: AND pv.budget_version_id = bud_version_id;

Line 9241: FROM pa_budget_versions

9237: l_wf_status varchar2(25) := null;
9238:
9239: cursor check_bdgt_baseline is
9240: SELECT wf_status_code
9241: FROM pa_budget_versions
9242: WHERE project_id = p_project_id
9243: AND wf_status_code is NOT NULL;
9244:
9245:

Line 14465: l_bvid_for_acct_changed_API pa_budget_versions.budget_Version_id%type;

14461: t_raid TypeNum;
14462: t_gl_rowid rowidtabtyp;
14463: t_budget_rowid rowidtabtyp;
14464: t_budget_start_date TypeDate;
14465: l_bvid_for_acct_changed_API pa_budget_versions.budget_Version_id%type;
14466:
14467: l_count NUMBER(4);
14468: l_validation_failed VARCHAR2(1);
14469: l_set_of_books_id pa_implementations_all.set_of_books_id%type;

Line 14471: l_current_budget_version_id pa_budget_versions.budget_version_id%TYPE;

14467: l_count NUMBER(4);
14468: l_validation_failed VARCHAR2(1);
14469: l_set_of_books_id pa_implementations_all.set_of_books_id%type;
14470: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
14471: l_current_budget_version_id pa_budget_versions.budget_version_id%TYPE;
14472: l_draft_budget_version_id pa_budget_versions.budget_version_id%TYPE;
14473: l_result_code pa_bc_packets.result_code%TYPE;
14474: l_acct_changed VARCHAR2(1);
14475: l_draft_acct_changed_flag VARCHAR2(1);

Line 14472: l_draft_budget_version_id pa_budget_versions.budget_version_id%TYPE;

14468: l_validation_failed VARCHAR2(1);
14469: l_set_of_books_id pa_implementations_all.set_of_books_id%type;
14470: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
14471: l_current_budget_version_id pa_budget_versions.budget_version_id%TYPE;
14472: l_draft_budget_version_id pa_budget_versions.budget_version_id%TYPE;
14473: l_result_code pa_bc_packets.result_code%TYPE;
14474: l_acct_changed VARCHAR2(1);
14475: l_draft_acct_changed_flag VARCHAR2(1);
14476: l_record_updated_flag VARCHAR2(1);

Line 14477: l_project_id pa_budget_versions.project_id%type;

14473: l_result_code pa_bc_packets.result_code%TYPE;
14474: l_acct_changed VARCHAR2(1);
14475: l_draft_acct_changed_flag VARCHAR2(1);
14476: l_record_updated_flag VARCHAR2(1);
14477: l_project_id pa_budget_versions.project_id%type;
14478: l_txn_exists_bc_pkt_flag VARCHAR2(1);
14479: l_txn_exists_bc_cmt_flag VARCHAR2(1);
14480: l_gl_failure_flag VARCHAR2(1);
14481: l_derive_draft_values VARCHAR2(1);

Line 14695: from pa_budget_versions pbv

14691: -- Get the draft or working budget ..
14692:
14693: Select pbv.budget_version_id
14694: into l_draft_budget_version_id
14695: from pa_budget_versions pbv
14696: where (pbv.project_id,pbv.budget_type_code) in
14697: (select project_id,budget_type_code
14698: from pa_budget_versions
14699: where budget_version_id = l_current_budget_version_id)

Line 14698: from pa_budget_versions

14694: into l_draft_budget_version_id
14695: from pa_budget_versions pbv
14696: where (pbv.project_id,pbv.budget_type_code) in
14697: (select project_id,budget_type_code
14698: from pa_budget_versions
14699: where budget_version_id = l_current_budget_version_id)
14700: and pbv.budget_status_code = decode(pa_budget_fund_pkg.g_processing_mode,
14701: 'YEAR_END','W','S');
14702:

Line 14733: pa_budget_versions pbv

14729:
14730: select pbem.entry_level_code
14731: into l_budget_entry_level_code
14732: from pa_budget_entry_methods pbem,
14733: pa_budget_versions pbv
14734: where pbv.budget_version_id = l_current_budget_version_id
14735: and pbem.budget_entry_method_code = pbv.budget_entry_method_code;
14736:
14737: End If;

Line 14795: select project_id into l_project_id from pa_budget_versions

14791: l_program_name := 'Do_budget_baseline_tieback';
14792: log_message(p_msg_token1=>l_program_name||'Get Project Id');
14793: End If;
14794:
14795: select project_id into l_project_id from pa_budget_versions
14796: where budget_version_id = l_current_budget_version_id;
14797:
14798: -- 1.9: If processing mode is BASELINE (and its a rebaseline, check if there are
14799: -- txns. against the project, if yes, set flag to 'Y' else 'N')