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 837: pqh_budget.update_worksheet_detail(

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

Line 863: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;

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

Line 864: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;

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

Line 867: from pqh_budgets bgt, pqh_budget_versions bgv

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

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

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

Line 892: pqh_budget_details_api.create_budget_detail(

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

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

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

Line 929: from pqh_budgets bgt, pqh_budget_versions bgv

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

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

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

Line 951: pqh_budget_details_api.create_budget_detail(

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

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

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

Line 989: from pqh_budgets bgt, pqh_budget_versions bgv

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

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

995: and pos.business_group_id = p_business_group_id
996: and pos.organization_id = org.organization_id
997: and pos.effective_start_date < l_budget_end_date
998: and pos.effective_end_date > l_budget_start_date
999: and pqh_budget.already_budgeted_pos(position_id) = 'FALSE'
1000: and get_position_budget_flag(pos.availability_status_id) = 'Y';
1001: cursor c2 is select distinct --Added Distinct to eliminate duplicates from the cursor to fix the bug#10284825.
1002: position_id,job_id,organization_id
1003: from ( select organization_id_child from pqh_worksheet_organizations_v

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

1008: and org_structure_version_id = p_org_hier_ver
1009: union
1010: select p_start_organization_id organization_id_child from dual )x,
1011: hr_positions_f
1012: where pqh_budget.already_budgeted_pos(position_id) = 'FALSE'
1013: and get_position_budget_flag(availability_status_id) = 'Y'
1014: and effective_start_date < l_budget_end_date
1015: and effective_end_date > l_budget_start_date
1016: and organization_id = x.organization_id_child ;

Line 1033: pqh_budget_details_api.create_budget_detail(

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

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

1051: ,p_budget_unit3_available => ''
1052: ,p_budget_unit3_value_type_cd => ''
1053: ,p_object_version_number => l_object_version_number
1054: );
1055: pqh_budget.insert_pos_is_bud(i.position_id);
1056: hr_utility.set_location('position inserted '||i.position_id||l_proc,40);
1057: end loop;
1058: else
1059: hr_utility.set_location('Org hierarchy cursor selected '||l_proc,45);

Line 1062: pqh_budget_details_api.create_budget_detail(

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

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

1080: ,p_budget_unit3_available => ''
1081: ,p_budget_unit3_value_type_cd => ''
1082: ,p_object_version_number => l_object_version_number
1083: );
1084: pqh_budget.insert_pos_is_bud(i.position_id);
1085: hr_utility.set_location('position inserted '||i.position_id||l_proc,50);
1086: end loop;
1087: end if;
1088: p_rows_inserted := l_rows_inserted;

Line 1102: from pqh_budgets bgt, pqh_budget_versions bgv

1098: p_rows_inserted out nocopy number) is
1099: l_budget_start_date date;
1100: l_budget_end_date date;
1101: cursor c0 is select budget_start_date,budget_end_date
1102: from pqh_budgets bgt, pqh_budget_versions bgv
1103: where bgv.budget_id = bgt.budget_id
1104: and bgv.budget_version_id = p_budget_version_id;
1105: cursor c1 is select organization_id
1106: from hr_all_organization_units

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

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

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

1113: and pqh_budget.already_budgeted_org(organization_id) = 'FALSE';
1114: cursor c2 is select w.organization_id_child organization_id
1115: from pqh_worksheet_organizations_v w
1116: where org_structure_version_id = p_org_hier_ver
1117: and pqh_budget.already_budgeted_org(w.organization_id_child) = 'FALSE'
1118: and exists
1119: (select null
1120: from hr_all_organization_units hao
1121: where organization_id = w.organization_id_child

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

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

Line 1159: pqh_budget_details_api.create_budget_detail(

1155: hr_utility.set_location('bg is used '||l_proc,20);
1156: for i in c1 loop
1157: hr_utility.set_location('in loop for '||i.organization_id||l_proc,25);
1158: l_rows_inserted := l_rows_inserted + 1;
1159: pqh_budget_details_api.create_budget_detail(
1160: p_validate => FALSE
1161: ,p_budget_detail_id => l_budget_detail_id
1162: ,p_budget_version_id => p_budget_version_id
1163: ,p_organization_id => i.organization_id

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

1178: ,p_budget_unit3_value_type_cd => ''
1179: ,p_object_version_number => l_object_version_number
1180: );
1181: hr_utility.set_location('inserting '||i.organization_id||l_proc,30);
1182: pqh_budget.insert_org_is_bud(i.organization_id);
1183: end loop;
1184: else
1185: hr_utility.set_location('oh is used '||l_proc,40);
1186: for i in c2 loop

Line 1188: pqh_budget_details_api.create_budget_detail(

1184: else
1185: hr_utility.set_location('oh is used '||l_proc,40);
1186: for i in c2 loop
1187: l_rows_inserted := l_rows_inserted + 1;
1188: pqh_budget_details_api.create_budget_detail(
1189: p_validate => FALSE
1190: ,p_budget_detail_id => l_budget_detail_id
1191: ,p_budget_version_id => p_budget_version_id
1192: ,p_organization_id => i.organization_id

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

1207: ,p_budget_unit3_value_type_cd => ''
1208: ,p_object_version_number => l_object_version_number
1209: );
1210: hr_utility.set_location('inserting '||i.organization_id||l_proc,50);
1211: pqh_budget.insert_org_is_bud(i.organization_id);
1212: end loop;
1213: end if;
1214: p_rows_inserted := l_rows_inserted;
1215: hr_utility.set_location('entering '||l_proc,60);

Line 1244: from pqh_budget_versions bgv, pqh_budget_details bgd

1240: return l_budget_id;
1241: end get_wkd_budget;
1242: function get_bgd_budget( p_budget_detail_id in number) return number is
1243: cursor c1 is select budget_id
1244: from pqh_budget_versions bgv, pqh_budget_details bgd
1245: where bgd.budget_detail_id = p_budget_detail_id
1246: and bgd.budget_version_id = bgv.budget_version_id ;
1247: l_budget_id number;
1248: begin

Line 1295: from pqh_budgets

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

Line 1312: pqh_budget.update_worksheet_detail(

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

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

1364: p_wkd_ovn => l_wkd_ovn,
1365: p_wks_ovn => l_wks_ovn);
1366: hr_utility.set_location(l_proc||'wks_ovn is '||l_wks_ovn,20);
1367: hr_utility.set_location(l_proc||'wkd_ovn is '||l_wkd_ovn,30);
1368: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,
1369: p_transaction_category_id => p_transaction_category_id,
1370: p_result_status => 'SUBMITTED',
1371: p_wkd_object_version_number => p_wkd_ovn,
1372: p_wks_object_version_number => p_wks_ovn);

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

1387: l_working_users varchar2(2000);
1388: l_proc varchar2(61) := g_package||'pending_wks' ;
1389: BEGIN
1390: hr_utility.set_location('entering'||l_proc,10);
1391: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,
1392: p_transaction_category_id => p_transaction_category_id,
1393: p_result_status => 'PENDING',
1394: p_wkd_object_version_number => p_wkd_ovn,
1395: p_wks_object_version_number => p_wks_ovn);

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

1410: l_working_users varchar2(2000);
1411: l_proc varchar2(61) := g_package||'approve_wks' ;
1412: BEGIN
1413: hr_utility.set_location('entering'||l_proc,10);
1414: pqh_budget.lock_all_children(p_worksheet_detail_id => p_transaction_id,
1415: p_transaction_category_id => p_transaction_category_id,
1416: p_status => l_status,
1417: p_working_users => l_working_users);
1418: hr_utility.set_location('child locked'||l_proc,20);

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

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

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

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

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

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

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

1478: hr_utility.raise_error;
1479: end if;
1480: else
1481: hr_utility.set_location('changing status'||l_proc,70);
1482: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,
1483: p_transaction_category_id => p_transaction_category_id,
1484: p_result_status => 'PENDING',
1485: p_wkd_object_version_number => p_wkd_ovn,
1486: p_wks_object_version_number => p_wks_ovn);

Line 1770: from pqh_budgets where budget_id = l_budget_id;

1766: fetch c_worksheet_detail into l_position_id,l_worksheet_detail_id;
1767: if c_worksheet_detail%found then
1768: l_budget_id := get_wkd_budget(p_worksheet_detail_id);
1769: select budgeted_entity_cd,budget_style_cd into l_budgeted_entity_cd,l_budget_style_cd
1770: from pqh_budgets where budget_id = l_budget_id;
1771: if l_budgeted_entity_cd ='POSITION' then
1772: if l_position_id is not null then
1773: update_wkd_pot(p_worksheet_detail_id => p_worksheet_detail_id);
1774: else