APPS.PQH_WKS_ERROR_CHK dependencies on PQH_WORKSHEETS

Line 15: g_worksheet_mode_cd pqh_worksheets.worksheet_mode_cd%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;
19: g_table_route_id_wel NUMBER;

Line 21: g_worksheet_name pqh_worksheets.worksheet_name%TYPE;

17: g_table_route_id_wpr NUMBER;
18: g_table_route_id_wst NUMBER;
19: g_table_route_id_wel NUMBER;
20: g_table_route_id_wfs NUMBER;
21: g_worksheet_name pqh_worksheets.worksheet_name%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);

Line 22: g_worksheet_id pqh_worksheets.worksheet_id%TYPE;

18: g_table_route_id_wst NUMBER;
19: g_table_route_id_wel NUMBER;
20: g_table_route_id_wfs NUMBER;
21: g_worksheet_name pqh_worksheets.worksheet_name%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;

Line 137: l_pqh_worksheets_rec pqh_worksheets%ROWTYPE;

133: WHERE worksheet_detail_id = p_worksheet_detail_id;
134:
135:
136: l_proc varchar2(72) := g_package||'check_wks_errors';
137: l_pqh_worksheets_rec pqh_worksheets%ROWTYPE;
138: l_pqh_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
139: l_pqh_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
140: l_pqh_worksheet_budget_set_rec pqh_worksheet_budget_sets%ROWTYPE;
141: l_pqh_worksheet_bdgt_elmnt_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;

Line 509: l_worksheets_rec pqh_worksheets%ROWTYPE;

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 *
513: FROM pqh_budgets

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 525: FROM pqh_worksheets

521: );
522:
523: CURSOR csr_worksheet_rec IS
524: SELECT *
525: FROM pqh_worksheets
526: WHERE worksheet_id =
527: (
528: SELECT wks.worksheet_id
529: FROM pqh_worksheets wks, pqh_worksheet_details wdt

Line 529: FROM pqh_worksheets wks, pqh_worksheet_details wdt

525: FROM pqh_worksheets
526: WHERE worksheet_id =
527: (
528: SELECT wks.worksheet_id
529: FROM pqh_worksheets wks, pqh_worksheet_details wdt
530: WHERE wdt.worksheet_id = wks.worksheet_id
531: AND wdt.worksheet_detail_id = p_worksheet_detail_id
532: );
533:

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 2928: l_worksheets_rec pqh_worksheets%ROWTYPE;

2924: --
2925: -- local variables
2926: --
2927: l_proc varchar2(72) := g_package||'check_wks_dates';
2928: l_worksheets_rec pqh_worksheets%ROWTYPE;
2929: l_wks_ll_date date;
2930: l_wks_ul_date date;
2931: l_status varchar2(10);
2932: l_message_text_out fnd_new_messages.message_text%TYPE;

Line 2941: FROM pqh_worksheets

2937: l_budgets_rec pqh_budgets%ROWTYPE;
2938:
2939: CURSOR csr_worksheet_rec IS
2940: SELECT *
2941: FROM pqh_worksheets
2942: WHERE worksheet_id =
2943: (
2944: SELECT wks.worksheet_id
2945: FROM pqh_worksheets wks, pqh_worksheet_details wdt

Line 2945: FROM pqh_worksheets wks, pqh_worksheet_details wdt

2941: FROM pqh_worksheets
2942: WHERE worksheet_id =
2943: (
2944: SELECT wks.worksheet_id
2945: FROM pqh_worksheets wks, pqh_worksheet_details wdt
2946: WHERE wdt.worksheet_id = wks.worksheet_id
2947: AND wdt.worksheet_detail_id = p_worksheet_detail_id
2948: );
2949: