eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BUDGET_DATA_MIGRATION dependencies on PQH_DFLT_BUDGET_SETS

Line 30: p_budget_set_name IN pqh_dflt_budget_sets.dflt_budget_set_name%TYPE,

26: (
27: errbuf OUT NOCOPY VARCHAR2,
28: retcode OUT NOCOPY VARCHAR2,
29: p_budget_name IN per_budgets.name%TYPE DEFAULT NULL,
30: p_budget_set_name IN pqh_dflt_budget_sets.dflt_budget_set_name%TYPE,
31: p_business_group_id IN per_budgets.business_group_id%TYPE
32: )
33: IS
34: -- local variables and cursors

Line 845: p_budget_set_name IN pqh_dflt_budget_sets.dflt_budget_set_name%TYPE

841:
842: PROCEDURE populate_period_details
843: (
844: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
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

Line 850: pqh_dflt_budget_sets, elements and fund srcs

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

Line 856: l_dflt_budget_sets_rec pqh_dflt_budget_sets%ROWTYPE;

852: -- local variables and cursors
853:
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;

Line 869: CURSOR pqh_dflt_budget_sets_cur (p_budget_set_name IN pqh_dflt_budget_sets.dflt_budget_set_name%TYPE) IS

865: SELECT *
866: FROM pqh_budget_periods
867: WHERE budget_period_id = p_budget_period_id;
868:
869: CURSOR pqh_dflt_budget_sets_cur (p_budget_set_name IN pqh_dflt_budget_sets.dflt_budget_set_name%TYPE) IS
870: SELECT *
871: FROM pqh_dflt_budget_sets
872: WHERE dflt_budget_set_name = p_budget_set_name;
873:

Line 871: FROM pqh_dflt_budget_sets

867: WHERE budget_period_id = p_budget_period_id;
868:
869: CURSOR pqh_dflt_budget_sets_cur (p_budget_set_name IN pqh_dflt_budget_sets.dflt_budget_set_name%TYPE) IS
870: SELECT *
871: FROM pqh_dflt_budget_sets
872: WHERE dflt_budget_set_name = p_budget_set_name;
873:
874: CURSOR pqh_dflt_budget_elements_cur (p_dflt_budget_set_id IN pqh_dflt_budget_elements.dflt_budget_set_id%TYPE) IS
875: SELECT *

Line 896: OPEN pqh_dflt_budget_sets_cur(p_budget_set_name => p_budget_set_name);

892: FETCH budget_periods_csr INTO l_budget_periods_rec;
893: CLOSE budget_periods_csr;
894:
895:
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

Line 898: FETCH pqh_dflt_budget_sets_cur INTO l_dflt_budget_sets_rec;

894:
895:
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: (

Line 899: EXIT WHEN pqh_dflt_budget_sets_cur%NOTFOUND;

895:
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,

Line 945: CLOSE pqh_dflt_budget_sets_cur;

941: END LOOP; -- loop 2
942: CLOSE pqh_dflt_budget_elements_cur;
943:
944: END LOOP; -- loop 1
945: CLOSE pqh_dflt_budget_sets_cur;
946:
947:
948: END IF; -- p_budget_period_id is not null
949:

Line 962: p_dflt_budget_sets_rec IN pqh_dflt_budget_sets%ROWTYPE,

958: --------------------------------------------------------------------------------------------------------------
959:
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

Line 1166: -- table_route_id for pqh_dflt_budget_sets

1162: OPEN csr_table_route (p_table_alias => 'P_BPR');
1163: FETCH csr_table_route INTO g_table_route_id_p_bpr;
1164: CLOSE csr_table_route;
1165:
1166: -- table_route_id for pqh_dflt_budget_sets
1167: OPEN csr_table_route (p_table_alias => 'DST');
1168: FETCH csr_table_route INTO g_table_route_id_dst;
1169: CLOSE csr_table_route;
1170:

Line 1426: p_budget_set_name IN pqh_dflt_budget_sets.dflt_budget_set_name%TYPE,

1422: --------------------------------------------------------------------------------------------------------------
1423: PROCEDURE check_params
1424: (
1425: p_budget_name IN per_budgets.name%TYPE,
1426: p_budget_set_name IN pqh_dflt_budget_sets.dflt_budget_set_name%TYPE,
1427: p_business_group_id IN per_budgets.business_group_id%TYPE
1428: ) IS
1429: /*
1430: This procedure will check at the input params are valid else it will log error and abort the program

Line 1434: The budget_set_name must exist in pqh_dflt_budget_sets ( dflt_budget_set_name )

1430: This procedure will check at the input params are valid else it will log error and abort the program
1431: Valid Params :
1432: There should atleast be one record in per_budgets with name = p_budget_name and budget_type_code <> OTA_BUDGET
1433: as we are not migrating OTA_BUDGETS
1434: The budget_set_name must exist in pqh_dflt_budget_sets ( dflt_budget_set_name )
1435: */
1436:
1437: l_proc varchar2(72) := g_package||'check_params';
1438: l_bdg_cnt number := 0;

Line 1452: FROM pqh_dflt_budget_sets

1448: AND NVL(budget_type_code,'X') <> 'OTA_BUDGET' ;
1449:
1450: CURSOR bdg_sets_csr IS
1451: SELECT COUNT(*)
1452: FROM pqh_dflt_budget_sets
1453: WHERE dflt_budget_set_name = p_budget_set_name;
1454:
1455: BEGIN
1456:

Line 1587: FROM pqh_dflt_budget_sets

1583: Where budget_id = p_budget_id;
1584: --
1585: CURSOR bdg_sets_csr IS
1586: SELECT dflt_budget_set_name
1587: FROM pqh_dflt_budget_sets
1588: WHERE dflt_budget_set_id = p_dflt_budget_set_id;
1589: --
1590: l_name per_budgets.name%type;
1591: l_business_group_id per_budgets.business_group_id%type;

Line 1592: l_bset_name pqh_dflt_budget_sets.dflt_budget_set_name%type;

1588: WHERE dflt_budget_set_id = p_dflt_budget_set_id;
1589: --
1590: l_name per_budgets.name%type;
1591: l_business_group_id per_budgets.business_group_id%type;
1592: l_bset_name pqh_dflt_budget_sets.dflt_budget_set_name%type;
1593: --
1594: begin
1595: --
1596: Open csr_budget;