APPS.PQH_WKS_BUDGET dependencies on PQH_WORKSHEET_PERIODS

Line 1322: pqh_worksheet_periods_api.create_worksheet_period

1318: p_budget_unit3_available => p_worksheet_unit1_value);
1319: hr_utility.set_location('ovn of wkd after is'||p_wkd_ovn||l_proc,90);
1320: else
1321: hr_utility.set_location('inserting worksheet period '||l_proc,100);
1322: pqh_worksheet_periods_api.create_worksheet_period
1323: (
1324: p_worksheet_period_id => p_worksheet_period_id
1325: ,p_end_time_period_id => l_end_time_period_id
1326: ,p_worksheet_detail_id => p_worksheet_detail_id

Line 1673: from pqh_worksheet_periods where worksheet_detail_id = p_worksheet_detail_id;

1669:
1670: procedure purge_wkd(p_worksheet_detail_id in number,
1671: p_budget_style_cd in varchar2) is
1672: cursor c_worksheet_periods is select worksheet_period_id,object_version_number
1673: from pqh_worksheet_periods where worksheet_detail_id = p_worksheet_detail_id;
1674: cursor c_worksheet_budget_sets(p_worksheet_period_id number) is
1675: select worksheet_budget_set_id,object_version_number
1676: from pqh_worksheet_budget_sets where worksheet_period_id = p_worksheet_period_id;
1677: cursor c_worksheet_bdgt_elmnts (p_worksheet_budget_set_id number) is

Line 1706: pqh_worksheet_periods_api.DELETE_WORKSHEET_PERIOD(

1702: P_WORKSHEET_BUDGET_SET_ID => j.worksheet_budget_set_id,
1703: P_EFFECTIVE_DATE => trunc(sysdate),
1704: P_OBJECT_VERSION_NUMBER => j.object_version_number);
1705: end loop;
1706: pqh_worksheet_periods_api.DELETE_WORKSHEET_PERIOD(
1707: P_WORKSHEET_PERIOD_ID => i.worksheet_period_id,
1708: P_EFFECTIVE_DATE => trunc(sysdate),
1709: P_OBJECT_VERSION_NUMBER => i.object_version_number);
1710: end loop;