APPS.PQH_BUDGET_DATA_MIGRATION dependencies on PQH_BUDGET_FUND_SRCS

Line 861: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;

857: l_dflt_budget_elements_rec pqh_dflt_budget_elements%ROWTYPE;
858: l_dflt_fund_srcs pqh_dflt_fund_srcs%ROWTYPE;
859: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;
860: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;
861: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
862:
863:
864: CURSOR budget_periods_csr IS
865: SELECT *

Line 928: -- create records in pqh_budget_fund_srcs

924: OPEN pqh_dflt_fund_srcs_cur(p_dflt_budget_element_id => l_dflt_budget_elements_rec.dflt_budget_element_id);
925: LOOP -- loop 3
926: FETCH pqh_dflt_fund_srcs_cur INTO l_dflt_fund_srcs;
927: EXIT WHEN pqh_dflt_fund_srcs_cur%NOTFOUND;
928: -- create records in pqh_budget_fund_srcs
929: populate_budget_fund_srcs
930: (
931: p_dflt_fund_srcs => l_dflt_fund_srcs,
932: p_budget_element_id => l_budget_element_id,

Line 1087: p_budget_fund_src_id_o OUT NOCOPY pqh_budget_fund_srcs.budget_fund_src_id%TYPE

1083: PROCEDURE populate_budget_fund_srcs
1084: (
1085: p_dflt_fund_srcs IN pqh_dflt_fund_srcs%ROWTYPE,
1086: p_budget_element_id IN pqh_budget_elements.budget_element_id%TYPE,
1087: p_budget_fund_src_id_o OUT NOCOPY pqh_budget_fund_srcs.budget_fund_src_id%TYPE
1088: )
1089: IS
1090: -- local variables and cursors
1091:

Line 1102: pqh_budget_fund_srcs_api.create_budget_fund_src

1098:
1099: IF p_budget_element_id IS NOT NULL THEN
1100:
1101: -- call insert API
1102: pqh_budget_fund_srcs_api.create_budget_fund_src
1103: (
1104: p_validate => false
1105: ,p_budget_fund_src_id => p_budget_fund_src_id_o
1106: ,p_budget_element_id => p_budget_element_id