DBA Data[Home] [Help]

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 1677: from pqh_worksheet_fund_srcs where worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;

1673: select worksheet_bdgt_elmnt_id,object_version_number
1674: from pqh_worksheet_bdgt_elmnts where worksheet_budget_set_id = p_worksheet_budget_set_id;
1675: cursor c_worksheet_fund_srcs (p_worksheet_bdgt_elmnt_id number) is
1676: select worksheet_fund_src_id,object_version_number
1677: from pqh_worksheet_fund_srcs where worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
1678: l_parent_wkd_id number;
1679: l_budget_unit1_value number;
1680: l_budget_unit2_value number;
1681: l_budget_unit3_value number;

Line 1688: pqh_worksheet_fund_srcs_api.DELETE_WORKSHEET_FUND_SRC(

1684: for i in c_worksheet_periods loop
1685: for j in c_worksheet_budget_sets(i.worksheet_period_id) loop
1686: for k in c_worksheet_bdgt_elmnts(j.worksheet_budget_set_id) loop
1687: for l in c_worksheet_fund_srcs(k.worksheet_bdgt_elmnt_id) loop
1688: pqh_worksheet_fund_srcs_api.DELETE_WORKSHEET_FUND_SRC(
1689: P_WORKSHEET_FUND_SRC_ID => l.worksheet_fund_src_id,
1690: P_OBJECT_VERSION_NUMBER => l.object_version_number);
1691: end loop;
1692: pqh_worksheet_bdgt_elmnts_api.DELETE_WORKSHEET_BDGT_ELMNT(