APPS.PQH_WKS_BUDGET dependencies on PQH_WORKSHEET_PERIODS

Line 1317: pqh_worksheet_periods_api.create_worksheet_period

1313: p_budget_unit3_available => p_worksheet_unit1_value);
1314: hr_utility.set_location('ovn of wkd after is'||p_wkd_ovn||l_proc,90);
1315: else
1316: hr_utility.set_location('inserting worksheet period '||l_proc,100);
1317: pqh_worksheet_periods_api.create_worksheet_period
1318: (
1319: p_worksheet_period_id => p_worksheet_period_id
1320: ,p_end_time_period_id => l_end_time_period_id
1321: ,p_worksheet_detail_id => p_worksheet_detail_id

Line 1668: from pqh_worksheet_periods where worksheet_detail_id = p_worksheet_detail_id;

1664:
1665: procedure purge_wkd(p_worksheet_detail_id in number,
1666: p_budget_style_cd in varchar2) is
1667: cursor c_worksheet_periods is select worksheet_period_id,object_version_number
1668: from pqh_worksheet_periods where worksheet_detail_id = p_worksheet_detail_id;
1669: cursor c_worksheet_budget_sets(p_worksheet_period_id number) is
1670: select worksheet_budget_set_id,object_version_number
1671: from pqh_worksheet_budget_sets where worksheet_period_id = p_worksheet_period_id;
1672: cursor c_worksheet_bdgt_elmnts (p_worksheet_budget_set_id number) is

Line 1701: pqh_worksheet_periods_api.DELETE_WORKSHEET_PERIOD(

1697: P_WORKSHEET_BUDGET_SET_ID => j.worksheet_budget_set_id,
1698: P_EFFECTIVE_DATE => trunc(sysdate),
1699: P_OBJECT_VERSION_NUMBER => j.object_version_number);
1700: end loop;
1701: pqh_worksheet_periods_api.DELETE_WORKSHEET_PERIOD(
1702: P_WORKSHEET_PERIOD_ID => i.worksheet_period_id,
1703: P_EFFECTIVE_DATE => trunc(sysdate),
1704: P_OBJECT_VERSION_NUMBER => i.object_version_number);
1705: end loop;