[Home] [Help]
259: hr_utility.set_location('workflow name is '||l_workflow_name||l_proc,20);
260: select wkd.status,wkd.parent_worksheet_detail_id,wkd.object_version_number,
261: wks.worksheet_id,wks.object_version_number
262: into l_status,l_parent_wkd_id,l_wkd_ovn,l_worksheet_id,l_wks_ovn
263: from pqh_worksheet_details wkd, pqh_worksheets wks
264: where wkd.worksheet_detail_id = p_worksheet_detail_id
265: and wkd.worksheet_id = wks.worksheet_id;
266: if p_result_status = 'REJECT' then
267: hr_utility.set_location('result_status is '||p_result_status||l_proc,30);
324: p_object_version_number => l_wkd_ovn,
325: p_status => 'REJECT'
326: );
327: hr_utility.set_location('wks status changed from '||l_status||l_proc,110);
328: pqh_worksheets_api.update_worksheet(
329: p_worksheet_id => l_worksheet_id,
330: p_effective_date => trunc(sysdate),
331: p_object_version_number => l_wks_ovn,
332: p_transaction_status => 'REJECT'
389: p_effective_date => trunc(sysdate),
390: p_object_version_number => l_wkd_ovn,
391: p_status => 'APPROVED');
392: hr_utility.set_location('wks status changed from '||l_status||l_proc,110);
393: pqh_worksheets_api.update_worksheet(
394: p_worksheet_id => l_worksheet_id,
395: p_effective_date => trunc(sysdate),
396: p_object_version_number => l_wks_ovn,
397: p_transaction_status => 'APPROVED');
418: p_effective_date => trunc(sysdate),
419: p_object_version_number => l_wkd_ovn,
420: p_status => 'SUBMITTED');
421: hr_utility.set_location('wks status changed from '||l_status||l_proc,110);
422: pqh_worksheets_api.update_worksheet(
423: p_worksheet_id => l_worksheet_id,
424: p_effective_date => trunc(sysdate),
425: p_object_version_number => l_wks_ovn,
426: p_transaction_status => 'SUBMITTED');
437: p_effective_date => trunc(sysdate),
438: p_object_version_number => l_wkd_ovn,
439: p_status => 'PENDING');
440: hr_utility.set_location('wks status changed from '||l_status||l_proc,110);
441: pqh_worksheets_api.update_worksheet(
442: p_worksheet_id => l_worksheet_id,
443: p_effective_date => trunc(sysdate),
444: p_object_version_number => l_wks_ovn,
445: p_transaction_status => 'PENDING');
453: p_status => p_result_status);
454: -- status is changed to terminated, get the ovn's
455: select wkd.object_version_number,wks.object_version_number
456: into l_wkd_ovn,l_wks_ovn
457: from pqh_worksheet_details wkd, pqh_worksheets wks
458: where wkd.worksheet_detail_id = p_worksheet_detail_id
459: and wkd.worksheet_id = wks.worksheet_id;
460: end if;
461: select wkd.object_version_number, wks.object_version_number
459: and wkd.worksheet_id = wks.worksheet_id;
460: end if;
461: select wkd.object_version_number, wks.object_version_number
462: into l_wkd_ovn,l_wks_ovn
463: from pqh_worksheet_details wkd, pqh_worksheets wks
464: where wkd.worksheet_detail_id = p_worksheet_detail_id
465: and wkd.worksheet_id = wks.worksheet_id;
466: p_wkd_object_version_number := l_wkd_ovn;
467: p_wks_object_version_number := l_wks_ovn;
614: old_unit1_value,old_unit2_value,old_unit3_value,
615: budget_unit1_available,budget_unit2_available,budget_unit3_available,
616: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent ;
617: cursor c3 is select wks.propagation_method
618: from pqh_worksheets wks, pqh_worksheet_details wkd
619: where wks.worksheet_id = wkd.worksheet_id
620: and worksheet_detail_id = p_worksheet_detail_id;
621: l_budget_unit1_value number;
622: l_budget_unit2_value number;
633: l_budget_unit1_available number;
634: l_budget_unit2_available number;
635: l_budget_unit3_available number;
636: l_object_version_number number := p_object_version_number;
637: l_wks_propagation_method pqh_worksheets.propagation_method%type;
638: l_proc varchar2(100) := g_package||'propagate_worksheet_changes' ;
639: l_code varchar2(30);
640: begin
641: hr_utility.set_location('entering '||l_proc,10);
2470: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;
2471: l_budget_entity_cd pqh_budgets.budgeted_entity_cd%type;
2472:
2473: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
2474: from pqh_budgets bge, pqh_worksheets wks
2475: where wks.budget_id = bge.budget_id
2476: and wks.worksheet_id = p_worksheet_id;
2477: cursor c1 is select grade_id from per_grades a
2478: where business_group_id = p_business_group_id
2523: p_rows_inserted out nocopy number) as
2524: l_budget_start_date date;
2525: l_budget_end_date date;
2526: cursor c0 is select budget_start_date,budget_end_date
2527: from pqh_budgets bgt, pqh_worksheets wks
2528: where wks.budget_id = bgt.budget_id
2529: and wks.worksheet_id = p_worksheet_id;
2530: cursor c1 is select job_id from per_jobs
2531: where business_group_id = p_business_group_id
2575: p_rows_inserted out nocopy number) as
2576: l_budget_start_date date;
2577: l_budget_end_date date;
2578: cursor c0 is select budget_start_date,budget_end_date
2579: from pqh_budgets bgt, pqh_worksheets wks
2580: where wks.budget_id = bgt.budget_id
2581: and wks.worksheet_id = p_worksheet_id;
2582: cursor c1 is select position_id,job_id,organization_id,availability_status_id
2583: from hr_positions
2676: p_rows_inserted out nocopy number) as
2677: l_budget_start_date date;
2678: l_budget_end_date date;
2679: cursor c0 is select budget_start_date,budget_end_date
2680: from pqh_budgets bgt, pqh_worksheets wks
2681: where wks.budget_id = bgt.budget_id
2682: and wks.worksheet_id = p_worksheet_id;
2683: cursor c1 is select organization_id
2684: from hr_organization_units
2762: p_rows_inserted out nocopy number) as
2763: l_budget_start_date date;
2764: l_budget_end_date date;
2765: cursor c0 is select budget_start_date,budget_end_date
2766: from pqh_budgets bgt, pqh_worksheets wks
2767: where wks.budget_id = bgt.budget_id
2768: and wks.worksheet_id = p_worksheet_id;
2769: cursor c1 is select hier.organization_id_child
2770: from per_org_structure_elements hier, hr_organization_units org