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_WORKSHEET_DETAILS

Line 44: from pqh_worksheet_details

40: l_organization_id number;
41: l_position_transaction_id number;
42: l_res_organization_id number;
43: cursor c1 is select position_id,organization_id,job_id,grade_id,position_transaction_id
44: from pqh_worksheet_details
45: where worksheet_detail_id = p_worksheet_detail_id;
46: cursor c2 is select business_group_id from hr_positions
47: where position_id = l_position_id;
48: cursor c3 is select business_group_id from per_jobs

Line 94: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE,

90: ------------------------------------------------------------------*/
91:
92: PROCEDURE check_wks_errors
93: (
94: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE,
95: p_status OUT NOCOPY varchar2
96: ) IS
97: /*
98:

Line 104: CURSOR pqh_worksheet_details_cur IS

100:
101: */
102: -- local variables and cursors
103:
104: CURSOR pqh_worksheet_details_cur IS
105: SELECT level, wdt.*
106: FROM pqh_worksheet_details wdt
107: START WITH worksheet_detail_id = p_worksheet_detail_id
108: CONNECT BY prior worksheet_detail_id = parent_worksheet_detail_id ;

Line 106: FROM pqh_worksheet_details wdt

102: -- local variables and cursors
103:
104: CURSOR pqh_worksheet_details_cur IS
105: SELECT level, wdt.*
106: FROM pqh_worksheet_details wdt
107: START WITH worksheet_detail_id = p_worksheet_detail_id
108: CONNECT BY prior worksheet_detail_id = parent_worksheet_detail_id ;
109:
110: CURSOR pqh_worksheet_periods_cur (p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE) IS

Line 110: CURSOR pqh_worksheet_periods_cur (p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE) IS

106: FROM pqh_worksheet_details wdt
107: START WITH worksheet_detail_id = p_worksheet_detail_id
108: CONNECT BY prior worksheet_detail_id = parent_worksheet_detail_id ;
109:
110: CURSOR pqh_worksheet_periods_cur (p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE) IS
111: SELECT *
112: FROM pqh_worksheet_periods
113: WHERE worksheet_detail_id = p_worksheet_detail_id;
114:

Line 132: FROM pqh_worksheet_details

128: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
129:
130: CURSOR wks_detail_id_input_cur IS
131: SELECT *
132: FROM pqh_worksheet_details
133: WHERE worksheet_detail_id = p_worksheet_detail_id;
134:
135:
136: l_proc varchar2(72) := g_package||'check_wks_errors';

Line 138: l_pqh_worksheet_details_rec pqh_worksheet_details%ROWTYPE;

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;
142: l_pqh_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;

Line 147: l_pqh_worksheet_details_c_rec pqh_worksheet_details_cur%ROWTYPE;

143: l_message_text pqh_process_log.message_text%TYPE;
144: l_message_text_out fnd_new_messages.message_text%TYPE;
145: l_message_number_out fnd_new_messages.message_number%TYPE;
146: l_log_context pqh_process_log.log_context%TYPE;
147: l_pqh_worksheet_details_c_rec pqh_worksheet_details_cur%ROWTYPE;
148: l_level number;
149: l_batch_id number;
150: l_batch_context varchar2(2000);
151: l_date_status varchar2(10);

Line 189: FETCH wks_detail_id_input_cur INTO l_pqh_worksheet_details_rec;

185: );
186:
187: -- check that the worksheet_detail_id is root or delegated record else error and exit
188: OPEN wks_detail_id_input_cur;
189: FETCH wks_detail_id_input_cur INTO l_pqh_worksheet_details_rec;
190: CLOSE wks_detail_id_input_cur;
191:
192: /*
193: -- get log_context

Line 211: IF NVL(l_pqh_worksheet_details_rec.action_cd,'R') NOT IN ('D', 'R') THEN

207: );
208:
209: */
210: -- main check for input action cd in D or R
211: IF NVL(l_pqh_worksheet_details_rec.action_cd,'R') NOT IN ('D', 'R') THEN
212:
213: -- get message text for PQH_WKS_INVALID_ID
214: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_ID');
215: l_message_text_out := FND_MESSAGE.GET;

Line 246: -- open pqh_worksheet_details_cur

242: -- end log and HALT the program here
243: raise g_error_exception;
244: END IF; -- valid wks dates
245:
246: -- open pqh_worksheet_details_cur
247: OPEN pqh_worksheet_details_cur ;
248: LOOP -- loop 1
249: FETCH pqh_worksheet_details_cur INTO l_pqh_worksheet_details_c_rec;
250: EXIT WHEN pqh_worksheet_details_cur%NOTFOUND;

Line 247: OPEN pqh_worksheet_details_cur ;

243: raise g_error_exception;
244: END IF; -- valid wks dates
245:
246: -- open pqh_worksheet_details_cur
247: OPEN pqh_worksheet_details_cur ;
248: LOOP -- loop 1
249: FETCH pqh_worksheet_details_cur INTO l_pqh_worksheet_details_c_rec;
250: EXIT WHEN pqh_worksheet_details_cur%NOTFOUND;
251:

Line 249: FETCH pqh_worksheet_details_cur INTO l_pqh_worksheet_details_c_rec;

245:
246: -- open pqh_worksheet_details_cur
247: OPEN pqh_worksheet_details_cur ;
248: LOOP -- loop 1
249: FETCH pqh_worksheet_details_cur INTO l_pqh_worksheet_details_c_rec;
250: EXIT WHEN pqh_worksheet_details_cur%NOTFOUND;
251:
252: -- current level
253: l_level := l_pqh_worksheet_details_c_rec.level ;

Line 250: EXIT WHEN pqh_worksheet_details_cur%NOTFOUND;

246: -- open pqh_worksheet_details_cur
247: OPEN pqh_worksheet_details_cur ;
248: LOOP -- loop 1
249: FETCH pqh_worksheet_details_cur INTO l_pqh_worksheet_details_c_rec;
250: EXIT WHEN pqh_worksheet_details_cur%NOTFOUND;
251:
252: -- current level
253: l_level := l_pqh_worksheet_details_c_rec.level ;
254:

Line 253: l_level := l_pqh_worksheet_details_c_rec.level ;

249: FETCH pqh_worksheet_details_cur INTO l_pqh_worksheet_details_c_rec;
250: EXIT WHEN pqh_worksheet_details_cur%NOTFOUND;
251:
252: -- current level
253: l_level := l_pqh_worksheet_details_c_rec.level ;
254:
255: -- populate the global for current level
256: -- as wks detail is now the batch , actual level will be one less
257: g_curr_wks_dtl_level := l_pqh_worksheet_details_c_rec.level - 1;

Line 257: g_curr_wks_dtl_level := l_pqh_worksheet_details_c_rec.level - 1;

253: l_level := l_pqh_worksheet_details_c_rec.level ;
254:
255: -- populate the global for current level
256: -- as wks detail is now the batch , actual level will be one less
257: g_curr_wks_dtl_level := l_pqh_worksheet_details_c_rec.level - 1;
258:
259: IF g_curr_wks_dtl_level <> 0 THEN
260: -- this is NOT THE ROOT NODE
261:

Line 265: p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id,

261:
262: -- get log_context
263: set_wks_log_context
264: (
265: p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id,
266: p_log_context => l_log_context
267: );
268:
269: -- set the context

Line 272: p_txn_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id,

268:
269: -- set the context
270: pqh_process_batch_log.set_context_level
271: (
272: p_txn_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id,
273: p_txn_table_route_id => g_table_route_id_wdt,
274: p_level => g_curr_wks_dtl_level,
275: p_log_context => l_log_context
276: );

Line 279: IF NVL(l_pqh_worksheet_details_c_rec.action_cd,'R') IN ('D','R') THEN

275: p_log_context => l_log_context
276: );
277:
278: -- check level1 rows of the worksheet_detail_id for Delegated OR Root record ONLY
279: IF NVL(l_pqh_worksheet_details_c_rec.action_cd,'R') IN ('D','R') THEN
280: check_level1_rows
281: (
282: p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id
283: );

Line 282: p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id

278: -- check level1 rows of the worksheet_detail_id for Delegated OR Root record ONLY
279: IF NVL(l_pqh_worksheet_details_c_rec.action_cd,'R') IN ('D','R') THEN
280: check_level1_rows
281: (
282: p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id
283: );
284: END IF;
285:
286: check_wks_details

Line 288: p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id

284: END IF;
285:
286: check_wks_details
287: (
288: p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id
289: );
290:
291: ELSE
292: -- this is the ROOT INPUT NODE

Line 295: IF NVL(l_pqh_worksheet_details_c_rec.action_cd,'R') IN ('D','R') THEN

291: ELSE
292: -- this is the ROOT INPUT NODE
293:
294: -- check level1 rows of the worksheet_detail_id for Delegated OR Root record ONLY
295: IF NVL(l_pqh_worksheet_details_c_rec.action_cd,'R') IN ('D','R') THEN
296: check_level1_rows
297: (
298: p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id
299: );

Line 298: p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id

294: -- check level1 rows of the worksheet_detail_id for Delegated OR Root record ONLY
295: IF NVL(l_pqh_worksheet_details_c_rec.action_cd,'R') IN ('D','R') THEN
296: check_level1_rows
297: (
298: p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id
299: );
300: END IF;
301:
302: check_input_wks_details

Line 304: p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id

300: END IF;
301:
302: check_input_wks_details
303: (
304: p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id
305: );
306:
307: END IF; -- for root node
308:

Line 309: g_context_organization_id := get_organization_id(p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id);

305: );
306:
307: END IF; -- for root node
308:
309: g_context_organization_id := get_organization_id(p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id);
310: -- For app periods level = g_curr_wks_dtl_level + 1
311:
312:
313: -- open pqh_worksheet_periods_cur

Line 314: OPEN pqh_worksheet_periods_cur(p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id);

310: -- For app periods level = g_curr_wks_dtl_level + 1
311:
312:
313: -- open pqh_worksheet_periods_cur
314: OPEN pqh_worksheet_periods_cur(p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id);
315: LOOP -- loop 2
316: FETCH pqh_worksheet_periods_cur INTO l_pqh_worksheet_periods_rec;
317: EXIT WHEN pqh_worksheet_periods_cur%NOTFOUND;
318:

Line 446: CLOSE pqh_worksheet_details_cur;

442: END LOOP; -- loop 2
443: CLOSE pqh_worksheet_periods_cur;
444:
445: END LOOP; -- loop 1
446: CLOSE pqh_worksheet_details_cur;
447:
448:
449: -- commit propogation
450: -- commit;

Line 495: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE

491:
492:
493: PROCEDURE populate_globals
494: (
495: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE
496: ) IS
497:
498: /*
499: This procedure will populate all the global variables.

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 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 593: -- table_route_id for pqh_worksheet_details

589: END IF;
590:
591: -- get table_route_id for all the six worksheet tables
592:
593: -- table_route_id for pqh_worksheet_details
594: OPEN csr_table_route (p_table_alias => 'WDT');
595: FETCH csr_table_route INTO g_table_route_id_wdt;
596: CLOSE csr_table_route;
597:

Line 645: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE

641:
642:
643: PROCEDURE check_level1_rows
644: (
645: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE
646: ) IS
647:
648: /*
649: This procedure will check if all the level one rows below root or input node

Line 661: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;

657:
658: */
659:
660: l_proc varchar2(72) := g_package||'check_level1_rows';
661: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
662: l_message_text pqh_process_log.message_text%TYPE;
663: l_message_text_out fnd_new_messages.message_text%TYPE;
664: l_message_number_out fnd_new_messages.message_number%TYPE;
665: l_log_context pqh_process_log.log_context%TYPE;

Line 668: l_unit1_available pqh_worksheet_details.budget_unit1_available%TYPE;

664: l_message_number_out fnd_new_messages.message_number%TYPE;
665: l_log_context pqh_process_log.log_context%TYPE;
666: l_error_flag varchar2(10) := 'N';
667:
668: l_unit1_available pqh_worksheet_details.budget_unit1_available%TYPE;
669: l_unit2_available pqh_worksheet_details.budget_unit2_available%TYPE;
670: l_unit3_available pqh_worksheet_details.budget_unit3_available%TYPE;
671: l_unit1_precision number;
672: l_unit2_precision number;

Line 669: l_unit2_available pqh_worksheet_details.budget_unit2_available%TYPE;

665: l_log_context pqh_process_log.log_context%TYPE;
666: l_error_flag varchar2(10) := 'N';
667:
668: l_unit1_available pqh_worksheet_details.budget_unit1_available%TYPE;
669: l_unit2_available pqh_worksheet_details.budget_unit2_available%TYPE;
670: l_unit3_available pqh_worksheet_details.budget_unit3_available%TYPE;
671: l_unit1_precision number;
672: l_unit2_precision number;
673: l_unit3_precision number;

Line 670: l_unit3_available pqh_worksheet_details.budget_unit3_available%TYPE;

666: l_error_flag varchar2(10) := 'N';
667:
668: l_unit1_available pqh_worksheet_details.budget_unit1_available%TYPE;
669: l_unit2_available pqh_worksheet_details.budget_unit2_available%TYPE;
670: l_unit3_available pqh_worksheet_details.budget_unit3_available%TYPE;
671: l_unit1_precision number;
672: l_unit2_precision number;
673: l_unit3_precision number;
674: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;

Line 674: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;

670: l_unit3_available pqh_worksheet_details.budget_unit3_available%TYPE;
671: l_unit1_precision number;
672: l_unit2_precision number;
673: l_unit3_precision number;
674: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;
675: l_unit1_value pqh_worksheet_details.budget_unit1_value%TYPE;
676: l_unit2_value pqh_worksheet_details.budget_unit2_value%TYPE;
677: l_unit3_value pqh_worksheet_details.budget_unit3_value%TYPE;
678: l_propogate_status varchar2(30);

Line 675: l_unit1_value pqh_worksheet_details.budget_unit1_value%TYPE;

671: l_unit1_precision number;
672: l_unit2_precision number;
673: l_unit3_precision number;
674: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;
675: l_unit1_value pqh_worksheet_details.budget_unit1_value%TYPE;
676: l_unit2_value pqh_worksheet_details.budget_unit2_value%TYPE;
677: l_unit3_value pqh_worksheet_details.budget_unit3_value%TYPE;
678: l_propogate_status varchar2(30);
679:

Line 676: l_unit2_value pqh_worksheet_details.budget_unit2_value%TYPE;

672: l_unit2_precision number;
673: l_unit3_precision number;
674: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;
675: l_unit1_value pqh_worksheet_details.budget_unit1_value%TYPE;
676: l_unit2_value pqh_worksheet_details.budget_unit2_value%TYPE;
677: l_unit3_value pqh_worksheet_details.budget_unit3_value%TYPE;
678: l_propogate_status varchar2(30);
679:
680:

Line 677: l_unit3_value pqh_worksheet_details.budget_unit3_value%TYPE;

673: l_unit3_precision number;
674: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;
675: l_unit1_value pqh_worksheet_details.budget_unit1_value%TYPE;
676: l_unit2_value pqh_worksheet_details.budget_unit2_value%TYPE;
677: l_unit3_value pqh_worksheet_details.budget_unit3_value%TYPE;
678: l_propogate_status varchar2(30);
679:
680:
681: CURSOR csr_level1_rows IS

Line 683: FROM pqh_worksheet_details

679:
680:
681: CURSOR csr_level1_rows IS
682: SELECT *
683: FROM pqh_worksheet_details
684: WHERE worksheet_detail_id IN
685: (
686: SELECT worksheet_detail_id
687: FROM pqh_worksheet_details

Line 687: FROM pqh_worksheet_details

683: FROM pqh_worksheet_details
684: WHERE worksheet_detail_id IN
685: (
686: SELECT worksheet_detail_id
687: FROM pqh_worksheet_details
688: WHERE level = 2
689: AND action_cd = 'D'
690: START WITH worksheet_detail_id = p_worksheet_detail_id
691: CONNECT BY prior worksheet_detail_id = parent_worksheet_detail_id

Line 764: UPDATE pqh_worksheet_details

760: p_object_version_number => l_object_version_number
761: );
762:
763: -- update the current record with the new available values
764: UPDATE pqh_worksheet_details
765: SET budget_unit1_available = l_unit1_available,
766: budget_unit2_available = l_unit2_available,
767: budget_unit3_available = l_unit3_available
768: WHERE CURRENT OF csr_level1_rows;

Line 807: UPDATE pqh_worksheet_details

803: p_status => l_propogate_status
804: ) ;
805:
806: -- update the current record with the new available values
807: UPDATE pqh_worksheet_details
808: SET budget_unit1_value = l_unit1_value,
809: budget_unit2_value = l_unit2_value,
810: budget_unit3_value = l_unit3_value
811: WHERE CURRENT OF csr_level1_rows;

Line 866: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE

862:
863:
864: PROCEDURE check_wks_details
865: (
866: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE
867: ) IS
868:
869: /*
870: This procedure will check if all the wks detail records under the main node EXCLUDING

Line 876: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;

872: For budgeted records we check if there are rows in periods
873: */
874:
875: l_proc varchar2(72) := g_package||'check_wks_details';
876: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
877: l_message_text pqh_process_log.message_text%TYPE;
878: l_message_text_out fnd_new_messages.message_text%TYPE;
879: l_count number;
880: l_error_flag varchar2(10) := 'N';

Line 887: FROM pqh_worksheet_details

883:
884:
885: CURSOR csr_wks_details IS
886: SELECT *
887: FROM pqh_worksheet_details
888: WHERE worksheet_detail_id = p_worksheet_detail_id;
889:
890: CURSOR csr_wks_periods_count IS
891: SELECT COUNT(*)

Line 1224: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE,

1220:
1221:
1222: PROCEDURE check_wks_periods
1223: (
1224: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE,
1225: p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE
1226: ) IS
1227:
1228: /*

Line 2106: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE,

2102:
2103:
2104: PROCEDURE set_wks_log_context
2105: (
2106: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE,
2107: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2108: ) IS
2109:
2110: /*

Line 2121: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;

2117:
2118: */
2119:
2120: l_proc varchar2(72) := g_package||'set_wks_log_context';
2121: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
2122: l_position_name hr_positions.name%TYPE;
2123: l_job_name per_jobs.name%TYPE;
2124: l_organization_name hr_organization_units.name%TYPE;
2125: l_grade_name per_grades.name%TYPE;

Line 2129: FROM pqh_worksheet_details

2125: l_grade_name per_grades.name%TYPE;
2126:
2127: CURSOR csr_wks_detail_rec IS
2128: SELECT *
2129: FROM pqh_worksheet_details
2130: WHERE worksheet_detail_id = p_worksheet_detail_id ;
2131:
2132: CURSOR csr_ptx_name(p_position_transaction_id IN number) IS
2133: SELECT name

Line 2566: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE

2562:
2563:
2564: PROCEDURE check_input_wks_details
2565: (
2566: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE
2567: ) IS
2568:
2569: /*
2570: This procedure will check if all the input wks detail records i.e the main node is valid

Line 2577: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;

2573: For the input wks dtl ID there must be atleast one budgeted record under this node
2574: */
2575:
2576: l_proc varchar2(72) := g_package||'check_input_wks_details';
2577: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
2578: l_message_text pqh_process_log.message_text%TYPE;
2579: l_message_text_out fnd_new_messages.message_text%TYPE;
2580: l_count number;
2581: l_budget_count number;

Line 2587: FROM pqh_worksheet_details

2583:
2584:
2585: CURSOR csr_wks_details IS
2586: SELECT *
2587: FROM pqh_worksheet_details
2588: WHERE worksheet_detail_id = p_worksheet_detail_id;
2589:
2590: CURSOR csr_wks_periods_count IS
2591: SELECT COUNT(*)

Line 2597: FROM pqh_worksheet_details wdt

2593: WHERE worksheet_detail_id = p_worksheet_detail_id;
2594:
2595: CURSOR csr_budget_count IS
2596: SELECT COUNT(*)
2597: FROM pqh_worksheet_details wdt
2598: WHERE action_cd = 'B'
2599: START WITH worksheet_detail_id = p_worksheet_detail_id
2600: CONNECT BY prior worksheet_detail_id = parent_worksheet_detail_id ;
2601:

Line 2916: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE,

2912: ------------------------------------------------------------------*/
2913:
2914: PROCEDURE check_wks_dates
2915: (
2916: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE,
2917: p_status OUT NOCOPY varchar2,
2918: p_message OUT NOCOPY varchar2
2919: ) IS
2920: /*

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:

Line 3011: p_position_id IN pqh_worksheet_details.position_id%TYPE,

3007: ||
3008: ------------------------------------------------------------------*/
3009: PROCEDURE check_pc_posn
3010: (
3011: p_position_id IN pqh_worksheet_details.position_id%TYPE,
3012: p_status OUT NOCOPY varchar2
3013: ) IS
3014: /*
3015: This procedure will check if the position is already budgeted in any other budget