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.PQH_WKS_ERROR_CHK dependencies on PQH_BUDGET

Line 10: g_budget_unit1_id pqh_budgets.budget_unit1_id%TYPE;

6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_wks_error_chk.'; -- Global package name
9: --
10: g_budget_unit1_id pqh_budgets.budget_unit1_id%TYPE;
11: g_budget_unit2_id pqh_budgets.budget_unit2_id%TYPE;
12: g_budget_unit3_id pqh_budgets.budget_unit3_id%TYPE;
13: g_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE;
14: g_budget_name pqh_budgets.budget_name%TYPE;

Line 11: g_budget_unit2_id pqh_budgets.budget_unit2_id%TYPE;

7: --
8: g_package varchar2(33) := ' pqh_wks_error_chk.'; -- Global package name
9: --
10: g_budget_unit1_id pqh_budgets.budget_unit1_id%TYPE;
11: g_budget_unit2_id pqh_budgets.budget_unit2_id%TYPE;
12: g_budget_unit3_id pqh_budgets.budget_unit3_id%TYPE;
13: g_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE;
14: g_budget_name pqh_budgets.budget_name%TYPE;
15: g_worksheet_mode_cd pqh_worksheets.worksheet_mode_cd%TYPE;

Line 12: g_budget_unit3_id pqh_budgets.budget_unit3_id%TYPE;

8: g_package varchar2(33) := ' pqh_wks_error_chk.'; -- Global package name
9: --
10: g_budget_unit1_id pqh_budgets.budget_unit1_id%TYPE;
11: g_budget_unit2_id pqh_budgets.budget_unit2_id%TYPE;
12: g_budget_unit3_id pqh_budgets.budget_unit3_id%TYPE;
13: g_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE;
14: g_budget_name pqh_budgets.budget_name%TYPE;
15: g_worksheet_mode_cd pqh_worksheets.worksheet_mode_cd%TYPE;
16: g_table_route_id_wdt NUMBER;

Line 13: g_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE;

9: --
10: g_budget_unit1_id pqh_budgets.budget_unit1_id%TYPE;
11: g_budget_unit2_id pqh_budgets.budget_unit2_id%TYPE;
12: g_budget_unit3_id pqh_budgets.budget_unit3_id%TYPE;
13: g_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE;
14: g_budget_name pqh_budgets.budget_name%TYPE;
15: g_worksheet_mode_cd pqh_worksheets.worksheet_mode_cd%TYPE;
16: g_table_route_id_wdt NUMBER;
17: g_table_route_id_wpr NUMBER;

Line 14: g_budget_name pqh_budgets.budget_name%TYPE;

10: g_budget_unit1_id pqh_budgets.budget_unit1_id%TYPE;
11: g_budget_unit2_id pqh_budgets.budget_unit2_id%TYPE;
12: g_budget_unit3_id pqh_budgets.budget_unit3_id%TYPE;
13: g_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE;
14: g_budget_name pqh_budgets.budget_name%TYPE;
15: g_worksheet_mode_cd pqh_worksheets.worksheet_mode_cd%TYPE;
16: g_table_route_id_wdt NUMBER;
17: g_table_route_id_wpr NUMBER;
18: g_table_route_id_wst NUMBER;

Line 26: g_position_control pqh_budgets.position_control_flag%TYPE;

22: g_worksheet_id pqh_worksheets.worksheet_id%TYPE;
23: g_error_exception exception;
24: g_curr_wks_dtl_level NUMBER;
25: g_batch_status VARCHAR2(30);
26: g_position_control pqh_budgets.position_control_flag%TYPE;
27: g_budget_id pqh_budgets.budget_id%TYPE;
28: g_budget_start_dt pqh_budgets.budget_start_date%TYPE;
29: g_budget_end_dt pqh_budgets.budget_end_date%TYPE;
30: g_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE;

Line 27: g_budget_id pqh_budgets.budget_id%TYPE;

23: g_error_exception exception;
24: g_curr_wks_dtl_level NUMBER;
25: g_batch_status VARCHAR2(30);
26: g_position_control pqh_budgets.position_control_flag%TYPE;
27: g_budget_id pqh_budgets.budget_id%TYPE;
28: g_budget_start_dt pqh_budgets.budget_start_date%TYPE;
29: g_budget_end_dt pqh_budgets.budget_end_date%TYPE;
30: g_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE;
31: g_budget_unit2_aggregate pqh_budgets.budget_unit2_aggregate%TYPE;

Line 28: g_budget_start_dt pqh_budgets.budget_start_date%TYPE;

24: g_curr_wks_dtl_level NUMBER;
25: g_batch_status VARCHAR2(30);
26: g_position_control pqh_budgets.position_control_flag%TYPE;
27: g_budget_id pqh_budgets.budget_id%TYPE;
28: g_budget_start_dt pqh_budgets.budget_start_date%TYPE;
29: g_budget_end_dt pqh_budgets.budget_end_date%TYPE;
30: g_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE;
31: g_budget_unit2_aggregate pqh_budgets.budget_unit2_aggregate%TYPE;
32: g_budget_unit3_aggregate pqh_budgets.budget_unit3_aggregate%TYPE;

Line 29: g_budget_end_dt pqh_budgets.budget_end_date%TYPE;

25: g_batch_status VARCHAR2(30);
26: g_position_control pqh_budgets.position_control_flag%TYPE;
27: g_budget_id pqh_budgets.budget_id%TYPE;
28: g_budget_start_dt pqh_budgets.budget_start_date%TYPE;
29: g_budget_end_dt pqh_budgets.budget_end_date%TYPE;
30: g_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE;
31: g_budget_unit2_aggregate pqh_budgets.budget_unit2_aggregate%TYPE;
32: g_budget_unit3_aggregate pqh_budgets.budget_unit3_aggregate%TYPE;
33: g_budget_style_cd pqh_budgets.budget_style_cd%TYPE;

Line 30: g_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE;

26: g_position_control pqh_budgets.position_control_flag%TYPE;
27: g_budget_id pqh_budgets.budget_id%TYPE;
28: g_budget_start_dt pqh_budgets.budget_start_date%TYPE;
29: g_budget_end_dt pqh_budgets.budget_end_date%TYPE;
30: g_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE;
31: g_budget_unit2_aggregate pqh_budgets.budget_unit2_aggregate%TYPE;
32: g_budget_unit3_aggregate pqh_budgets.budget_unit3_aggregate%TYPE;
33: g_budget_style_cd pqh_budgets.budget_style_cd%TYPE;
34: g_context_organization_id number;

Line 31: g_budget_unit2_aggregate pqh_budgets.budget_unit2_aggregate%TYPE;

27: g_budget_id pqh_budgets.budget_id%TYPE;
28: g_budget_start_dt pqh_budgets.budget_start_date%TYPE;
29: g_budget_end_dt pqh_budgets.budget_end_date%TYPE;
30: g_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE;
31: g_budget_unit2_aggregate pqh_budgets.budget_unit2_aggregate%TYPE;
32: g_budget_unit3_aggregate pqh_budgets.budget_unit3_aggregate%TYPE;
33: g_budget_style_cd pqh_budgets.budget_style_cd%TYPE;
34: g_context_organization_id number;
35:

Line 32: g_budget_unit3_aggregate pqh_budgets.budget_unit3_aggregate%TYPE;

28: g_budget_start_dt pqh_budgets.budget_start_date%TYPE;
29: g_budget_end_dt pqh_budgets.budget_end_date%TYPE;
30: g_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE;
31: g_budget_unit2_aggregate pqh_budgets.budget_unit2_aggregate%TYPE;
32: g_budget_unit3_aggregate pqh_budgets.budget_unit3_aggregate%TYPE;
33: g_budget_style_cd pqh_budgets.budget_style_cd%TYPE;
34: g_context_organization_id number;
35:
36: function get_organization_id (p_worksheet_detail_id in number) return number is

Line 33: g_budget_style_cd pqh_budgets.budget_style_cd%TYPE;

29: g_budget_end_dt pqh_budgets.budget_end_date%TYPE;
30: g_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE;
31: g_budget_unit2_aggregate pqh_budgets.budget_unit2_aggregate%TYPE;
32: g_budget_unit3_aggregate pqh_budgets.budget_unit3_aggregate%TYPE;
33: g_budget_style_cd pqh_budgets.budget_style_cd%TYPE;
34: g_context_organization_id number;
35:
36: function get_organization_id (p_worksheet_detail_id in number) return number is
37: l_position_id number;

Line 508: l_budgets_rec pqh_budgets%ROWTYPE;

504:
505: */
506:
507: l_proc varchar2(72) := g_package||'populate_globals';
508: l_budgets_rec pqh_budgets%ROWTYPE;
509: l_worksheets_rec pqh_worksheets%ROWTYPE;
510:
511: CURSOR csr_budget_rec IS
512: SELECT *

Line 513: FROM pqh_budgets

509: l_worksheets_rec pqh_worksheets%ROWTYPE;
510:
511: CURSOR csr_budget_rec IS
512: SELECT *
513: FROM pqh_budgets
514: WHERE budget_id =
515: (
516: SELECT b.budget_id
517: FROM pqh_budgets b, pqh_worksheets wks, pqh_worksheet_details wdt

Line 517: FROM pqh_budgets b, pqh_worksheets wks, pqh_worksheet_details wdt

513: FROM pqh_budgets
514: WHERE budget_id =
515: (
516: SELECT b.budget_id
517: FROM pqh_budgets b, pqh_worksheets wks, pqh_worksheet_details wdt
518: WHERE wdt.worksheet_id = wks.worksheet_id
519: AND wks.budget_id = b.budget_id
520: AND wdt.worksheet_detail_id = p_worksheet_detail_id
521: );

Line 744: pqh_budget.propagate_worksheet_changes

740: pqh_wks_budget.get_wkd_unit_precision(p_worksheet_detail_id => l_worksheet_details_rec.worksheet_detail_id,
741: p_unit1_precision => l_unit1_precision,
742: p_unit2_precision => l_unit2_precision,
743: p_unit3_precision => l_unit3_precision);
744: pqh_budget.propagate_worksheet_changes
745: (p_change_mode => l_worksheet_details_rec.propagation_method,
746: p_worksheet_detail_id => l_worksheet_details_rec.worksheet_detail_id,
747: p_budget_style_cd => g_budget_style_cd,
748: p_new_wks_unit1_value => l_worksheet_details_rec.budget_unit1_value,

Line 898: FROM hr_all_positions_f pos, pqh_worksheets wks, pqh_budgets bud

894:
895: CURSOR csr_pos_availability(p_position_id l_worksheet_details_rec.position_id%type,
896: p_worksheet_id l_worksheet_details_rec.worksheet_id%type) IS
897: SELECT pos.availability_status_id
898: FROM hr_all_positions_f pos, pqh_worksheets wks, pqh_budgets bud
899: WHERE pos.position_id = p_position_id
900: AND wks.worksheet_id = p_worksheet_id
901: AND wks.budget_id = bud.budget_id
902: AND pos.effective_start_date < bud.budget_end_date

Line 2027: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_SRC_MANDATORY');

2023: l_worksheet_fund_srcs_rec.expenditure_type is null or
2024: l_worksheet_fund_srcs_rec.organization_id is null then
2025: -- one of the PATEO column is missing, raise an error
2026: l_error_flag := 'Y';
2027: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_SRC_MANDATORY');
2028: l_message_text_out := FND_MESSAGE.GET;
2029: l_message_text := l_message_text||' **** '||l_message_text_out;
2030: end if;
2031: else

Line 2040: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_SRC_GL_GMS');

2036: l_worksheet_fund_srcs_rec.expenditure_type is not null and
2037: l_worksheet_fund_srcs_rec.organization_id is not null then
2038: -- some of the PATEO column is present alongwith cost allocation, raise an error
2039: l_error_flag := 'Y';
2040: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_SRC_GL_GMS');
2041: l_message_text_out := FND_MESSAGE.GET;
2042: l_message_text := l_message_text||' **** '||l_message_text_out;
2043: end if;
2044: end if;

Line 2937: l_budgets_rec pqh_budgets%ROWTYPE;

2933: l_pc_start_date date;
2934: l_pc_end_date date;
2935: l_pc_bdgt_name varchar2(80);
2936: l_pc_version_no number(9);
2937: l_budgets_rec pqh_budgets%ROWTYPE;
2938:
2939: CURSOR csr_worksheet_rec IS
2940: SELECT *
2941: FROM pqh_worksheets

Line 2952: FROM pqh_budgets

2948: );
2949:
2950: CURSOR csr_budgets_rec(p_budget_id IN number) IS
2951: SELECT *
2952: FROM pqh_budgets
2953: WHERE budget_id = p_budget_id ;
2954:
2955: BEGIN
2956:

Line 3024: FROM pqh_budgets bgt, pqh_budget_versions bvr, pqh_budget_details bdt

3020: l_proc varchar2(72) := g_package||'check_pc_posn';
3021:
3022: CURSOR csr_budget_id IS
3023: SELECT DISTINCT bgt.budget_id
3024: FROM pqh_budgets bgt, pqh_budget_versions bvr, pqh_budget_details bdt
3025: WHERE bgt.budget_id = bvr.budget_id
3026: AND bvr.budget_version_id = bdt.budget_version_id
3027: AND bdt.position_id = p_position_id
3028: AND NVL(bgt.position_control_flag,'X') = 'Y'

Line 3033: FROM pqh_budgets

3029: AND bgt.budget_id <> g_budget_id;
3030:
3031: CURSOR csr_budget_rec(p_budget_id IN number) IS
3032: SELECT *
3033: FROM pqh_budgets
3034: WHERE budget_id = p_budget_id;
3035:
3036: CURSOR csr_lookup(p_shared_type_id IN number) IS
3037: SELECT system_type_cd

Line 3041: l_budget_id pqh_budgets.budget_id%TYPE;

3037: SELECT system_type_cd
3038: FROM per_shared_types
3039: WHERE shared_type_id = NVL(p_shared_type_id,-1);
3040:
3041: l_budget_id pqh_budgets.budget_id%TYPE;
3042: l_budget_rec pqh_budgets%ROWTYPE;
3043:
3044: l_curr_lookup1 varchar2(50) := 'A';
3045: l_curr_lookup2 varchar2(50) := 'B';

Line 3042: l_budget_rec pqh_budgets%ROWTYPE;

3038: FROM per_shared_types
3039: WHERE shared_type_id = NVL(p_shared_type_id,-1);
3040:
3041: l_budget_id pqh_budgets.budget_id%TYPE;
3042: l_budget_rec pqh_budgets%ROWTYPE;
3043:
3044: l_curr_lookup1 varchar2(50) := 'A';
3045: l_curr_lookup2 varchar2(50) := 'B';
3046: l_curr_lookup3 varchar2(50) := 'C';