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_BUDGET dependencies on PQH_BUDGET

Line 102: from pqh_budgets bgt,pqh_worksheets wks, pqh_worksheet_details wkd

98: p_unit1_desc out nocopy varchar2,
99: p_unit2_desc out nocopy varchar2,
100: p_unit3_desc out nocopy varchar2) is
101: cursor c1 is select budget_unit1_id,budget_unit2_id,budget_unit3_id
102: from pqh_budgets bgt,pqh_worksheets wks, pqh_worksheet_details wkd
103: where wkd.worksheet_id = wks.worksheet_id
104: and wks.budget_id = bgt.budget_id
105: and wkd.worksheet_detail_id = p_worksheet_detail_id;
106: l_budget_unit1_id pqh_budgets.budget_unit1_id%type;

Line 106: l_budget_unit1_id pqh_budgets.budget_unit1_id%type;

102: from pqh_budgets bgt,pqh_worksheets wks, pqh_worksheet_details wkd
103: where wkd.worksheet_id = wks.worksheet_id
104: and wks.budget_id = bgt.budget_id
105: and wkd.worksheet_detail_id = p_worksheet_detail_id;
106: l_budget_unit1_id pqh_budgets.budget_unit1_id%type;
107: l_budget_unit2_id pqh_budgets.budget_unit1_id%type;
108: l_budget_unit3_id pqh_budgets.budget_unit1_id%type;
109: begin
110: if p_worksheet_detail_id is not null then

Line 107: l_budget_unit2_id pqh_budgets.budget_unit1_id%type;

103: where wkd.worksheet_id = wks.worksheet_id
104: and wks.budget_id = bgt.budget_id
105: and wkd.worksheet_detail_id = p_worksheet_detail_id;
106: l_budget_unit1_id pqh_budgets.budget_unit1_id%type;
107: l_budget_unit2_id pqh_budgets.budget_unit1_id%type;
108: l_budget_unit3_id pqh_budgets.budget_unit1_id%type;
109: begin
110: if p_worksheet_detail_id is not null then
111: begin

Line 108: l_budget_unit3_id pqh_budgets.budget_unit1_id%type;

104: and wks.budget_id = bgt.budget_id
105: and wkd.worksheet_detail_id = p_worksheet_detail_id;
106: l_budget_unit1_id pqh_budgets.budget_unit1_id%type;
107: l_budget_unit2_id pqh_budgets.budget_unit1_id%type;
108: l_budget_unit3_id pqh_budgets.budget_unit1_id%type;
109: begin
110: if p_worksheet_detail_id is not null then
111: begin
112: open c1;

Line 343: from pqh_budgets

339: p_unit1_precision out nocopy number,
340: p_unit2_precision out nocopy number,
341: p_unit3_precision out nocopy number ) is
342: cursor c1 is select currency_code,budget_unit1_id,budget_unit2_id,budget_unit3_id
343: from pqh_budgets
344: where budget_id = p_budget_id;
345: l_currency_code varchar2(15);
346: l_unit1_id number;
347: l_unit2_id number;

Line 436: from pqh_worksheets wks, pqh_budgets bgt

432: p_unit1_aggregate out nocopy varchar2,
433: p_unit2_aggregate out nocopy varchar2,
434: p_unit3_aggregate out nocopy varchar2 ) is
435: cursor c1 is select bgt.budget_unit1_aggregate,bgt.budget_unit2_aggregate,bgt.budget_unit3_aggregate
436: from pqh_worksheets wks, pqh_budgets bgt
437: where wks.worksheet_id = p_worksheet_id
438: and wks.budget_id = bgt.budget_id;
439: begin
440: for i in c1 loop

Line 456: from pqh_worksheets wks, pqh_worksheet_details wkd, pqh_budgets bgt

452: p_unit1_aggregate out nocopy varchar2,
453: p_unit2_aggregate out nocopy varchar2,
454: p_unit3_aggregate out nocopy varchar2 ) is
455: cursor c1 is select bgt.budget_unit1_aggregate,bgt.budget_unit2_aggregate,bgt.budget_unit3_aggregate
456: from pqh_worksheets wks, pqh_worksheet_details wkd, pqh_budgets bgt
457: where wks.worksheet_id = wkd.worksheet_id
458: and wks.budget_id = bgt.budget_id
459: and wkd.worksheet_detail_id = p_worksheet_detail_id;
460: begin

Line 546: select count(*) into l_count from pqh_budget_elements

542: if p_dflt_budget_set_id is null then
543: hr_utility.set_message(8302,'PQH_WKS_MIG_INV_SET');
544: hr_utility.raise_error;
545: else
546: select count(*) into l_count from pqh_budget_elements
547: where budget_set_id = p_budget_set_id ;
548: if l_count = 0 then
549: for i in c1 loop
550: pqh_budget_elements_api.create_budget_element(

Line 550: pqh_budget_elements_api.create_budget_element(

546: select count(*) into l_count from pqh_budget_elements
547: where budget_set_id = p_budget_set_id ;
548: if l_count = 0 then
549: for i in c1 loop
550: pqh_budget_elements_api.create_budget_element(
551: p_validate => FALSE
552: ,p_budget_set_id => p_budget_set_id
553: ,p_budget_element_id => l_budget_element_id
554: ,p_element_type_id => i.element_type_id

Line 559: pqh_budget_fund_srcs_api.create_budget_fund_src(

555: ,p_object_version_number => l_object_version_number
556: ,p_distribution_percentage => i.dflt_dist_percentage
557: );
558: for j in c2(i.dflt_budget_element_id) loop
559: pqh_budget_fund_srcs_api.create_budget_fund_src(
560: p_validate => FALSE
561: ,p_budget_fund_src_id => l_budget_fund_src_id
562: ,p_budget_element_id => l_budget_element_id
563: ,p_cost_allocation_keyflex_id => j.cost_allocation_keyflex_id

Line 637: pqh_budget.update_worksheet_detail(

633: raise;
634: end;
635: hr_utility.set_location('going to update status'||l_proc,60);
636: l_object_version_number := i.object_version_number;
637: pqh_budget.update_worksheet_detail(
638: p_worksheet_detail_id => i.worksheet_detail_id,
639: p_effective_date => trunc(sysdate),
640: p_object_version_number => l_object_version_number,
641: p_status => 'DELEGATED'

Line 656: cursor c0 is select max(version_number) from pqh_budget_versions

652: p_wks_ll_date out nocopy date,
653: p_wks_ul_date out nocopy date,
654: p_status out nocopy varchar2) is
655: l_max_version number;
656: cursor c0 is select max(version_number) from pqh_budget_versions
657: where budget_id = p_budget_id ;
658: cursor c1 is select 'x' from pqh_budget_versions
659: where budget_version_id = p_budget_version_id
660: and budget_id = p_budget_id;

Line 658: cursor c1 is select 'x' from pqh_budget_versions

654: p_status out nocopy varchar2) is
655: l_max_version number;
656: cursor c0 is select max(version_number) from pqh_budget_versions
657: where budget_id = p_budget_id ;
658: cursor c1 is select 'x' from pqh_budget_versions
659: where budget_version_id = p_budget_version_id
660: and budget_id = p_budget_id;
661: cursor c2 is select date_to from pqh_budget_versions
662: where version_number = l_max_version

Line 661: cursor c2 is select date_to from pqh_budget_versions

657: where budget_id = p_budget_id ;
658: cursor c1 is select 'x' from pqh_budget_versions
659: where budget_version_id = p_budget_version_id
660: and budget_id = p_budget_id;
661: cursor c2 is select date_to from pqh_budget_versions
662: where version_number = l_max_version
663: and budget_id = p_budget_id;
664: cursor c3 is select version_number from pqh_budget_versions
665: where budget_version_id = p_budget_version_id;

Line 664: cursor c3 is select version_number from pqh_budget_versions

660: and budget_id = p_budget_id;
661: cursor c2 is select date_to from pqh_budget_versions
662: where version_number = l_max_version
663: and budget_id = p_budget_id;
664: cursor c3 is select version_number from pqh_budget_versions
665: where budget_version_id = p_budget_version_id;
666: l_max_end_date date;
667: l_ver_chk varchar2(15);
668: l_version_number number;

Line 833: pqh_budget.update_worksheet_detail(

829: end if;
830: p_budget_unit1_value := nvl(p_budget_unit1_value,0) - nvl(i.old_unit1_value,0) + nvl(l_budget_unit1_value,0) ;
831: p_budget_unit1_value := nvl(p_budget_unit1_value,0) - nvl(i.old_unit1_value,0) + nvl(l_budget_unit1_value,0) ;
832: p_budget_unit1_value := nvl(p_budget_unit1_value,0) - nvl(i.old_unit1_value,0) + nvl(i.budget_unit1_value,0) ;
833: pqh_budget.update_worksheet_detail(
834: p_worksheet_detail_id => i.worksheet_detail_id,
835: p_object_version_number => l_object_version_number,
836: p_effective_date => trunc(sysdate),
837: p_budget_unit1_value => l_budget_unit1_value,

Line 859: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;

855: p_business_group_id in number,
856: p_rows_inserted out nocopy number) is
857: l_budget_start_date date;
858: l_budget_end_date date;
859: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;
860: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;
861:
862: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
863: from pqh_budgets bgt, pqh_budget_versions bgv

Line 860: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;

856: p_rows_inserted out nocopy number) is
857: l_budget_start_date date;
858: l_budget_end_date date;
859: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;
860: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;
861:
862: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
863: from pqh_budgets bgt, pqh_budget_versions bgv
864: where bgv.budget_id = bgt.budget_id

Line 863: from pqh_budgets bgt, pqh_budget_versions bgv

859: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;
860: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;
861:
862: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
863: from pqh_budgets bgt, pqh_budget_versions bgv
864: where bgv.budget_id = bgt.budget_id
865: and bgv.budget_version_id = p_budget_version_id;
866: cursor c1 is select grade_id from per_grades a
867: where business_group_id = p_business_group_id

Line 874: and pqh_budget.already_budgeted_grd(a.grade_id) = 'FALSE' ;

870: where b.date_from < l_budget_end_date
871: and (b.date_to > l_budget_start_date or b.date_to is null)))
872: or (nvl(l_valid_grade_flag,'N') = 'N' and date_from < l_budget_end_date
873: and (date_to > l_budget_start_date or date_to is null)))
874: and pqh_budget.already_budgeted_grd(a.grade_id) = 'FALSE' ;
875: l_budget_detail_id number;
876: l_rows_inserted number := 0;
877: l_object_version_number number := 1;
878: l_proc varchar2(100) := g_package||'populate_bud_grades' ;

Line 888: pqh_budget_details_api.create_budget_detail(

884: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);
885: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);
886: for i in c1 loop
887: l_rows_inserted := l_rows_inserted + 1;
888: pqh_budget_details_api.create_budget_detail(
889: p_validate => FALSE
890: ,p_budget_detail_id => l_budget_detail_id
891: ,p_budget_version_id => p_budget_version_id
892: ,p_organization_id => ''

Line 910: pqh_budget.insert_grd_is_bud(i.grade_id);

906: ,p_budget_unit3_available => ''
907: ,p_budget_unit3_value_type_cd => ''
908: ,p_object_version_number => l_object_version_number
909: );
910: pqh_budget.insert_grd_is_bud(i.grade_id);
911: end loop;
912: p_rows_inserted := l_rows_inserted;
913: hr_utility.set_location('exiting '||l_proc,1000);
914: exception when others then

Line 925: from pqh_budgets bgt, pqh_budget_versions bgv

921: p_rows_inserted out nocopy number) is
922: l_budget_start_date date;
923: l_budget_end_date date;
924: cursor c0 is select budget_start_date,budget_end_date
925: from pqh_budgets bgt, pqh_budget_versions bgv
926: where bgv.budget_id = bgt.budget_id
927: and bgv.budget_version_id = p_budget_version_id;
928: cursor c1 is select job_id from per_jobs job, per_job_groups jgr
929: where job.job_group_id = jgr.job_group_id and jgr.internal_name = 'HR_' || job.business_group_id

Line 933: and pqh_budget.already_budgeted_job(job_id) = 'FALSE';

929: where job.job_group_id = jgr.job_group_id and jgr.internal_name = 'HR_' || job.business_group_id
930: and job.business_group_id = p_business_group_id
931: and date_from < l_budget_end_date
932: and (date_to > l_budget_start_date or date_to is null)
933: and pqh_budget.already_budgeted_job(job_id) = 'FALSE';
934: l_budget_detail_id number;
935: l_rows_inserted number := 0;
936: l_object_version_number number := 1;
937: l_proc varchar2(100) := g_package||'populate_bud_jobs' ;

Line 947: pqh_budget_details_api.create_budget_detail(

943: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);
944: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);
945: for i in c1 loop
946: l_rows_inserted := l_rows_inserted + 1;
947: pqh_budget_details_api.create_budget_detail(
948: p_validate => FALSE
949: ,p_budget_detail_id => l_budget_detail_id
950: ,p_budget_version_id => p_budget_version_id
951: ,p_organization_id => ''

Line 969: pqh_budget.insert_job_is_bud(i.job_id);

965: ,p_budget_unit3_available => ''
966: ,p_budget_unit3_value_type_cd => ''
967: ,p_object_version_number => l_object_version_number
968: );
969: pqh_budget.insert_job_is_bud(i.job_id);
970: end loop;
971: p_rows_inserted := l_rows_inserted;
972: hr_utility.set_location('exiting '||l_proc,1000);
973: exception when others then

Line 985: from pqh_budgets bgt, pqh_budget_versions bgv

981: p_rows_inserted out nocopy number) is
982: l_budget_start_date date;
983: l_budget_end_date date;
984: cursor c0 is select budget_start_date,budget_end_date
985: from pqh_budgets bgt, pqh_budget_versions bgv
986: where bgv.budget_id = bgt.budget_id
987: and bgv.budget_version_id = p_budget_version_id;
988: cursor c1 is select position_id,job_id,pos.organization_id organization_id
989: from hr_positions pos,hr_organization_units org

Line 995: and pqh_budget.already_budgeted_pos(position_id) = 'FALSE'

991: and pos.business_group_id = p_business_group_id
992: and pos.organization_id = org.organization_id
993: and pos.effective_start_date < l_budget_end_date
994: and pos.effective_end_date > l_budget_start_date
995: and pqh_budget.already_budgeted_pos(position_id) = 'FALSE'
996: and get_position_budget_flag(pos.availability_status_id) = 'Y';
997: cursor c2 is select position_id,job_id,organization_id
998: from ( select organization_id_child from pqh_worksheet_organizations_v
999: where org_structure_version_id = p_org_hier_ver

Line 1007: where pqh_budget.already_budgeted_pos(position_id) = 'FALSE'

1003: and org_structure_version_id = p_org_hier_ver
1004: union
1005: select p_start_organization_id organization_id_child from dual )x,
1006: hr_positions_f
1007: where pqh_budget.already_budgeted_pos(position_id) = 'FALSE'
1008: and get_position_budget_flag(availability_status_id) = 'Y'
1009: and effective_start_date < l_budget_end_date
1010: and effective_end_date > l_budget_start_date
1011: and organization_id = x.organization_id_child ;

Line 1028: pqh_budget_details_api.create_budget_detail(

1024: if p_org_hier_ver is null then
1025: hr_utility.set_location('Business group cursor selected '||l_proc,20);
1026: for i in c1 loop
1027: l_rows_inserted := l_rows_inserted + 1;
1028: pqh_budget_details_api.create_budget_detail(
1029: p_validate => FALSE
1030: ,p_budget_detail_id => l_budget_detail_id
1031: ,p_budget_version_id => p_budget_version_id
1032: ,p_organization_id => i.organization_id

Line 1050: pqh_budget.insert_pos_is_bud(i.position_id);

1046: ,p_budget_unit3_available => ''
1047: ,p_budget_unit3_value_type_cd => ''
1048: ,p_object_version_number => l_object_version_number
1049: );
1050: pqh_budget.insert_pos_is_bud(i.position_id);
1051: hr_utility.set_location('position inserted '||i.position_id||l_proc,40);
1052: end loop;
1053: else
1054: hr_utility.set_location('Org hierarchy cursor selected '||l_proc,45);

Line 1057: pqh_budget_details_api.create_budget_detail(

1053: else
1054: hr_utility.set_location('Org hierarchy cursor selected '||l_proc,45);
1055: for i in c2 loop
1056: l_rows_inserted := l_rows_inserted + 1;
1057: pqh_budget_details_api.create_budget_detail(
1058: p_validate => FALSE
1059: ,p_budget_detail_id => l_budget_detail_id
1060: ,p_budget_version_id => p_budget_version_id
1061: ,p_organization_id => i.organization_id

Line 1079: pqh_budget.insert_pos_is_bud(i.position_id);

1075: ,p_budget_unit3_available => ''
1076: ,p_budget_unit3_value_type_cd => ''
1077: ,p_object_version_number => l_object_version_number
1078: );
1079: pqh_budget.insert_pos_is_bud(i.position_id);
1080: hr_utility.set_location('position inserted '||i.position_id||l_proc,50);
1081: end loop;
1082: end if;
1083: p_rows_inserted := l_rows_inserted;

Line 1097: from pqh_budgets bgt, pqh_budget_versions bgv

1093: p_rows_inserted out nocopy number) is
1094: l_budget_start_date date;
1095: l_budget_end_date date;
1096: cursor c0 is select budget_start_date,budget_end_date
1097: from pqh_budgets bgt, pqh_budget_versions bgv
1098: where bgv.budget_id = bgt.budget_id
1099: and bgv.budget_version_id = p_budget_version_id;
1100: cursor c1 is select organization_id
1101: from hr_all_organization_units

Line 1108: and pqh_budget.already_budgeted_org(organization_id) = 'FALSE';

1104: and (date_to > l_budget_start_date or date_to is null)
1105: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',
1106: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', ORGANIZATION_ID))='TRUE'
1107: --and decode(hr_general.get_xbg_profile,'Y', business_group_id , hr_general.get_business_group_id) = business_group_id
1108: and pqh_budget.already_budgeted_org(organization_id) = 'FALSE';
1109: cursor c2 is select w.organization_id_child organization_id
1110: from pqh_worksheet_organizations_v w
1111: where org_structure_version_id = p_org_hier_ver
1112: and pqh_budget.already_budgeted_org(w.organization_id_child) = 'FALSE'

Line 1112: and pqh_budget.already_budgeted_org(w.organization_id_child) = 'FALSE'

1108: and pqh_budget.already_budgeted_org(organization_id) = 'FALSE';
1109: cursor c2 is select w.organization_id_child organization_id
1110: from pqh_worksheet_organizations_v w
1111: where org_structure_version_id = p_org_hier_ver
1112: and pqh_budget.already_budgeted_org(w.organization_id_child) = 'FALSE'
1113: and exists
1114: (select null
1115: from hr_all_organization_units hao
1116: where organization_id = w.organization_id_child

Line 1130: and pqh_budget.already_budgeted_org(p_start_organization_id) = 'FALSE'

1126: union
1127: select organization_id
1128: from hr_all_organization_units hao
1129: where organization_id = p_start_organization_id
1130: and pqh_budget.already_budgeted_org(p_start_organization_id) = 'FALSE'
1131: and date_from < l_budget_end_date
1132: and (date_to > l_budget_start_date or date_to is null)
1133: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',
1134: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', HAO.ORGANIZATION_ID))='TRUE' ;

Line 1154: pqh_budget_details_api.create_budget_detail(

1150: hr_utility.set_location('bg is used '||l_proc,20);
1151: for i in c1 loop
1152: hr_utility.set_location('in loop for '||i.organization_id||l_proc,25);
1153: l_rows_inserted := l_rows_inserted + 1;
1154: pqh_budget_details_api.create_budget_detail(
1155: p_validate => FALSE
1156: ,p_budget_detail_id => l_budget_detail_id
1157: ,p_budget_version_id => p_budget_version_id
1158: ,p_organization_id => i.organization_id

Line 1177: pqh_budget.insert_org_is_bud(i.organization_id);

1173: ,p_budget_unit3_value_type_cd => ''
1174: ,p_object_version_number => l_object_version_number
1175: );
1176: hr_utility.set_location('inserting '||i.organization_id||l_proc,30);
1177: pqh_budget.insert_org_is_bud(i.organization_id);
1178: end loop;
1179: else
1180: hr_utility.set_location('oh is used '||l_proc,40);
1181: for i in c2 loop

Line 1183: pqh_budget_details_api.create_budget_detail(

1179: else
1180: hr_utility.set_location('oh is used '||l_proc,40);
1181: for i in c2 loop
1182: l_rows_inserted := l_rows_inserted + 1;
1183: pqh_budget_details_api.create_budget_detail(
1184: p_validate => FALSE
1185: ,p_budget_detail_id => l_budget_detail_id
1186: ,p_budget_version_id => p_budget_version_id
1187: ,p_organization_id => i.organization_id

Line 1206: pqh_budget.insert_org_is_bud(i.organization_id);

1202: ,p_budget_unit3_value_type_cd => ''
1203: ,p_object_version_number => l_object_version_number
1204: );
1205: hr_utility.set_location('inserting '||i.organization_id||l_proc,50);
1206: pqh_budget.insert_org_is_bud(i.organization_id);
1207: end loop;
1208: end if;
1209: p_rows_inserted := l_rows_inserted;
1210: hr_utility.set_location('entering '||l_proc,60);

Line 1239: from pqh_budget_versions bgv, pqh_budget_details bgd

1235: return l_budget_id;
1236: end get_wkd_budget;
1237: function get_bgd_budget( p_budget_detail_id in number) return number is
1238: cursor c1 is select budget_id
1239: from pqh_budget_versions bgv, pqh_budget_details bgd
1240: where bgd.budget_detail_id = p_budget_detail_id
1241: and bgd.budget_version_id = bgv.budget_version_id ;
1242: l_budget_id number;
1243: begin

Line 1290: from pqh_budgets

1286: l_budget_id := get_wkd_budget(p_worksheet_detail_id);
1287: hr_utility.set_location('budget id is '||l_budget_id||l_proc,20);
1288: select period_set_name,budget_start_date,budget_end_date
1289: into l_calendar,l_budget_start_date,l_budget_end_date
1290: from pqh_budgets
1291: where budget_id = l_budget_id;
1292: hr_utility.set_location('calendar id is '||l_calendar||l_proc,30);
1293: hr_utility.set_location('budget start date is '||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,40);
1294: hr_utility.set_location('budget_end date id is '||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,50);

Line 1307: pqh_budget.update_worksheet_detail(

1303: end if;
1304: close c1;
1305: if l_end_time_period_id is null then
1306: hr_utility.set_location('no period lies during budget life'||l_proc,80);
1307: pqh_budget.update_worksheet_detail(
1308: p_worksheet_detail_id => p_worksheet_detail_id,
1309: p_object_version_number => p_wkd_ovn,
1310: p_effective_date => trunc(sysdate),
1311: p_budget_unit1_available => p_worksheet_unit1_value,

Line 1363: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,

1359: p_wkd_ovn => l_wkd_ovn,
1360: p_wks_ovn => l_wks_ovn);
1361: hr_utility.set_location(l_proc||'wks_ovn is '||l_wks_ovn,20);
1362: hr_utility.set_location(l_proc||'wkd_ovn is '||l_wkd_ovn,30);
1363: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,
1364: p_transaction_category_id => p_transaction_category_id,
1365: p_result_status => 'SUBMITTED',
1366: p_wkd_object_version_number => p_wkd_ovn,
1367: p_wks_object_version_number => p_wks_ovn);

Line 1386: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,

1382: l_working_users varchar2(2000);
1383: l_proc varchar2(61) := g_package||'pending_wks' ;
1384: BEGIN
1385: hr_utility.set_location('entering'||l_proc,10);
1386: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,
1387: p_transaction_category_id => p_transaction_category_id,
1388: p_result_status => 'PENDING',
1389: p_wkd_object_version_number => p_wkd_ovn,
1390: p_wks_object_version_number => p_wks_ovn);

Line 1409: pqh_budget.lock_all_children(p_worksheet_detail_id => p_transaction_id,

1405: l_working_users varchar2(2000);
1406: l_proc varchar2(61) := g_package||'approve_wks' ;
1407: BEGIN
1408: hr_utility.set_location('entering'||l_proc,10);
1409: pqh_budget.lock_all_children(p_worksheet_detail_id => p_transaction_id,
1410: p_transaction_category_id => p_transaction_category_id,
1411: p_status => l_status,
1412: p_working_users => l_working_users);
1413: hr_utility.set_location('child locked'||l_proc,20);

Line 1417: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,

1413: hr_utility.set_location('child locked'||l_proc,20);
1414: if nvl(l_status,'Y') ='Y' then
1415: -- close notifications and change status
1416: hr_utility.set_location('changing status'||l_proc,30);
1417: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,
1418: p_transaction_category_id => p_transaction_category_id,
1419: p_result_status => 'APPROVED',
1420: p_wkd_object_version_number => p_wkd_ovn,
1421: p_wks_object_version_number => p_wks_ovn);

Line 1456: pqh_budget.lock_all_children(p_worksheet_detail_id => p_transaction_id,

1452: -- and all open notifications to be killed
1453: -- depending upon the initator of the delegated row
1454: if l_user is null or l_user = fnd_profile.value('USERNAME') then
1455: hr_utility.set_location('going for lock'||l_proc,30);
1456: pqh_budget.lock_all_children(p_worksheet_detail_id => p_transaction_id,
1457: p_transaction_category_id => p_transaction_category_id,
1458: p_status => l_status,
1459: p_working_users => l_working_users);
1460: hr_utility.set_location('locked'||l_proc,40);

Line 1464: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,

1460: hr_utility.set_location('locked'||l_proc,40);
1461: if nvl(l_status,'Y') ='Y' then
1462: -- notifications are to be closed and change status
1463: hr_utility.set_location('changing status'||l_proc,50);
1464: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,
1465: p_transaction_category_id => p_transaction_category_id,
1466: p_result_status => 'REJECT',
1467: p_wkd_object_version_number => p_wkd_ovn,
1468: p_wks_object_version_number => p_wks_ovn);

Line 1477: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,

1473: hr_utility.raise_error;
1474: end if;
1475: else
1476: hr_utility.set_location('changing status'||l_proc,70);
1477: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,
1478: p_transaction_category_id => p_transaction_category_id,
1479: p_result_status => 'PENDING',
1480: p_wkd_object_version_number => p_wkd_ovn,
1481: p_wks_object_version_number => p_wks_ovn);

Line 1765: from pqh_budgets where budget_id = l_budget_id;

1761: fetch c_worksheet_detail into l_position_id,l_worksheet_detail_id;
1762: if c_worksheet_detail%found then
1763: l_budget_id := get_wkd_budget(p_worksheet_detail_id);
1764: select budgeted_entity_cd,budget_style_cd into l_budgeted_entity_cd,l_budget_style_cd
1765: from pqh_budgets where budget_id = l_budget_id;
1766: if l_budgeted_entity_cd ='POSITION' then
1767: if l_position_id is not null then
1768: update_wkd_pot(p_worksheet_detail_id => p_worksheet_detail_id);
1769: else