APPS.PQH_WKS_BUDGET dependencies on PQH_WORKSHEET_FUND_SRCS

Line 506: pqh_worksheet_fund_srcs_api.create_worksheet_fund_src(

502: ,p_object_version_number => l_object_version_number
503: ,p_distribution_percentage => i.dflt_dist_percentage
504: );
505: for j in c2(i.dflt_budget_element_id) loop
506: pqh_worksheet_fund_srcs_api.create_worksheet_fund_src(
507: p_validate => FALSE
508: ,p_worksheet_fund_src_id => l_worksheet_fund_src_id
509: ,p_worksheet_bdgt_elmnt_id => l_worksheet_bdgt_elmnt_id
510: ,p_cost_allocation_keyflex_id => j.cost_allocation_keyflex_id

Line 1682: from pqh_worksheet_fund_srcs where worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;

1678: select worksheet_bdgt_elmnt_id,object_version_number
1679: from pqh_worksheet_bdgt_elmnts where worksheet_budget_set_id = p_worksheet_budget_set_id;
1680: cursor c_worksheet_fund_srcs (p_worksheet_bdgt_elmnt_id number) is
1681: select worksheet_fund_src_id,object_version_number
1682: from pqh_worksheet_fund_srcs where worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
1683: l_parent_wkd_id number;
1684: l_budget_unit1_value number;
1685: l_budget_unit2_value number;
1686: l_budget_unit3_value number;

Line 1693: pqh_worksheet_fund_srcs_api.DELETE_WORKSHEET_FUND_SRC(

1689: for i in c_worksheet_periods loop
1690: for j in c_worksheet_budget_sets(i.worksheet_period_id) loop
1691: for k in c_worksheet_bdgt_elmnts(j.worksheet_budget_set_id) loop
1692: for l in c_worksheet_fund_srcs(k.worksheet_bdgt_elmnt_id) loop
1693: pqh_worksheet_fund_srcs_api.DELETE_WORKSHEET_FUND_SRC(
1694: P_WORKSHEET_FUND_SRC_ID => l.worksheet_fund_src_id,
1695: P_OBJECT_VERSION_NUMBER => l.object_version_number);
1696: end loop;
1697: pqh_worksheet_bdgt_elmnts_api.DELETE_WORKSHEET_BDGT_ELMNT(