APPS.PQH_BUDGET_DATA_MIGRATION dependencies on PQH_BUDGET_ELEMENTS

Line 860: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;

856: l_dflt_budget_sets_rec pqh_dflt_budget_sets%ROWTYPE;
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

Line 914: -- create records in pqh_budget_elements

910: OPEN pqh_dflt_budget_elements_cur(p_dflt_budget_set_id => l_dflt_budget_sets_rec.dflt_budget_set_id);
911: LOOP -- loop 2
912: FETCH pqh_dflt_budget_elements_cur INTO l_dflt_budget_elements_rec;
913: EXIT WHEN pqh_dflt_budget_elements_cur%NOTFOUND;
914: -- create records in pqh_budget_elements
915: populate_budget_elements
916: (
917: p_dflt_budget_elements_rec => l_dflt_budget_elements_rec,
918: p_budget_set_id => l_budget_set_id,

Line 1045: p_budget_element_id_o OUT NOCOPY pqh_budget_elements.budget_element_id%TYPE

1041: PROCEDURE populate_budget_elements
1042: (
1043: p_dflt_budget_elements_rec IN pqh_dflt_budget_elements%ROWTYPE,
1044: p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE,
1045: p_budget_element_id_o OUT NOCOPY pqh_budget_elements.budget_element_id%TYPE
1046: )
1047: IS
1048:
1049: -- local variables and cursors

Line 1061: pqh_budget_elements_api.create_budget_element

1057:
1058: IF p_budget_set_id IS NOT NULL THEN
1059:
1060: -- call insert API
1061: pqh_budget_elements_api.create_budget_element
1062: (
1063: p_validate => false
1064: ,p_budget_element_id => p_budget_element_id_o
1065: ,p_budget_set_id => p_budget_set_id

Line 1086: p_budget_element_id IN pqh_budget_elements.budget_element_id%TYPE,

1082: --------------------------------------------------------------------------------------------------------------
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