APPS.PQH_BUDGET_DATA_MIGRATION dependencies on PQH_BUDGET_SETS

Line 849: This procedure will populate one rows in pqh_budget_sets, elements and funding srcs with rows from

845: p_budget_set_name IN pqh_dflt_budget_sets.dflt_budget_set_name%TYPE
846: )
847: IS
848: /*
849: This procedure will populate one rows in pqh_budget_sets, elements and funding srcs with rows from
850: pqh_dflt_budget_sets, elements and fund srcs
851: */
852: -- local variables and cursors
853:

Line 859: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;

855: l_budget_periods_rec pqh_budget_periods%ROWTYPE;
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:

Line 900: -- create records in pqh_budget_sets

896: OPEN pqh_dflt_budget_sets_cur(p_budget_set_name => p_budget_set_name);
897: LOOP -- loop 1
898: FETCH pqh_dflt_budget_sets_cur INTO l_dflt_budget_sets_rec;
899: EXIT WHEN pqh_dflt_budget_sets_cur%NOTFOUND;
900: -- create records in pqh_budget_sets
901: populate_budget_sets
902: (
903: p_dflt_budget_sets_rec => l_dflt_budget_sets_rec,
904: p_budget_period_id => p_budget_period_id,

Line 964: p_budget_set_id_o OUT NOCOPY pqh_budget_sets.budget_set_id%TYPE

960: PROCEDURE populate_budget_sets
961: (
962: p_dflt_budget_sets_rec IN pqh_dflt_budget_sets%ROWTYPE,
963: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
964: p_budget_set_id_o OUT NOCOPY pqh_budget_sets.budget_set_id%TYPE
965: )
966: IS
967: -- local variables and cursors
968:

Line 1006: pqh_budget_sets_api.create_budget_set

1002:
1003: -- unit2 and 3 are null in migrated data
1004:
1005: -- call insert API
1006: pqh_budget_sets_api.create_budget_set
1007: (
1008: p_validate => false
1009: ,p_budget_set_id => p_budget_set_id_o
1010: ,p_dflt_budget_set_id => p_dflt_budget_sets_rec.dflt_budget_set_id

Line 1044: p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE,

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