APPS.PQH_BUDGET_DATA_MIGRATION dependencies on PQH_DFLT_FUND_SRCS

Line 858: l_dflt_fund_srcs pqh_dflt_fund_srcs%ROWTYPE;

854: l_proc varchar2(72) := g_package||'populate_period_details';
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:

Line 879: CURSOR pqh_dflt_fund_srcs_cur (p_dflt_budget_element_id IN pqh_dflt_fund_srcs.dflt_budget_element_id%TYPE) IS

875: SELECT *
876: FROM pqh_dflt_budget_elements
877: WHERE dflt_budget_set_id = p_dflt_budget_set_id;
878:
879: CURSOR pqh_dflt_fund_srcs_cur (p_dflt_budget_element_id IN pqh_dflt_fund_srcs.dflt_budget_element_id%TYPE) IS
880: SELECT *
881: FROM pqh_dflt_fund_srcs
882: WHERE dflt_budget_element_id = p_dflt_budget_element_id;
883:

Line 881: FROM pqh_dflt_fund_srcs

877: WHERE dflt_budget_set_id = p_dflt_budget_set_id;
878:
879: CURSOR pqh_dflt_fund_srcs_cur (p_dflt_budget_element_id IN pqh_dflt_fund_srcs.dflt_budget_element_id%TYPE) IS
880: SELECT *
881: FROM pqh_dflt_fund_srcs
882: WHERE dflt_budget_element_id = p_dflt_budget_element_id;
883:
884:
885: BEGIN

Line 924: OPEN pqh_dflt_fund_srcs_cur(p_dflt_budget_element_id => l_dflt_budget_elements_rec.dflt_budget_element_id);

920: );
921:
922:
923: -- open budget fund srcs cursor
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

Line 926: FETCH pqh_dflt_fund_srcs_cur INTO l_dflt_fund_srcs;

922:
923: -- open budget fund srcs cursor
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: (

Line 927: EXIT WHEN pqh_dflt_fund_srcs_cur%NOTFOUND;

923: -- open budget fund srcs cursor
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,

Line 938: CLOSE pqh_dflt_fund_srcs_cur;

934: );
935:
936:
937: END LOOP; -- loop 3
938: CLOSE pqh_dflt_fund_srcs_cur;
939:
940:
941: END LOOP; -- loop 2
942: CLOSE pqh_dflt_budget_elements_cur;

Line 1085: p_dflt_fund_srcs IN pqh_dflt_fund_srcs%ROWTYPE,

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