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_BUDGET_VERSIONS

Line 64: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

60: l_per_budget_rec per_budgets%ROWTYPE;
61: l_budget_id pqh_budgets.budget_id%TYPE;
62: l_tot_budget_val per_budget_values.value%TYPE;
63: l_per_budget_ver_rec per_budget_versions%ROWTYPE;
64: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
65: l_per_budget_elmnt_rec per_budget_elements%ROWTYPE;
66: l_budget_detail_id pqh_budget_details.budget_detail_id%TYPE;
67: l_budget_unit1_value pqh_budget_details.budget_unit1_value%TYPE;
68: l_per_budget_val_rec per_budget_values%ROWTYPE;

Line 161: -- create records in pqh_budget_versions

157: p_level => 2,
158: p_log_context => l_log_context
159: );
160:
161: -- create records in pqh_budget_versions
162: populate_budget_versions
163: (
164: p_per_budget_ver_rec => l_per_budget_ver_rec,
165: p_budget_id => l_budget_id,

Line 265: -- populate pqh_budget_versions with default row for those budgets that do not have child rows

261: END LOOP; -- loop 1
262: CLOSE per_budget_cur;
263:
264:
265: -- populate pqh_budget_versions with default row for those budgets that do not have child rows
266: -- in pqh_budget_versions
267:
268: populate_empty_budget_versions;
269:

Line 266: -- in pqh_budget_versions

262: CLOSE per_budget_cur;
263:
264:
265: -- populate pqh_budget_versions with default row for those budgets that do not have child rows
266: -- in pqh_budget_versions
267:
268: populate_empty_budget_versions;
269:
270: -- commit the work;

Line 451: p_budget_version_id_o OUT NOCOPY pqh_budget_versions.budget_version_id%TYPE

447: PROCEDURE populate_budget_versions
448: (
449: p_per_budget_ver_rec IN per_budget_versions%ROWTYPE,
450: p_budget_id IN pqh_budgets.budget_id%TYPE,
451: p_budget_version_id_o OUT NOCOPY pqh_budget_versions.budget_version_id%TYPE
452: )
453: IS
454: -- local variables and cursors
455:

Line 457: l_object_version_number pqh_budget_versions.object_version_number%TYPE;

453: IS
454: -- local variables and cursors
455:
456: l_proc varchar2(72) := g_package||'populate_budget_versions';
457: l_object_version_number pqh_budget_versions.object_version_number%TYPE;
458: l_budget_unit1_value pqh_budget_versions.budget_unit1_value%TYPE;
459: l_budget_unit1_available pqh_budget_versions.budget_unit1_available%TYPE := 0;
460:
461:

Line 458: l_budget_unit1_value pqh_budget_versions.budget_unit1_value%TYPE;

454: -- local variables and cursors
455:
456: l_proc varchar2(72) := g_package||'populate_budget_versions';
457: l_object_version_number pqh_budget_versions.object_version_number%TYPE;
458: l_budget_unit1_value pqh_budget_versions.budget_unit1_value%TYPE;
459: l_budget_unit1_available pqh_budget_versions.budget_unit1_available%TYPE := 0;
460:
461:
462: -- cursor for unit1_value

Line 459: l_budget_unit1_available pqh_budget_versions.budget_unit1_available%TYPE := 0;

455:
456: l_proc varchar2(72) := g_package||'populate_budget_versions';
457: l_object_version_number pqh_budget_versions.object_version_number%TYPE;
458: l_budget_unit1_value pqh_budget_versions.budget_unit1_value%TYPE;
459: l_budget_unit1_available pqh_budget_versions.budget_unit1_available%TYPE := 0;
460:
461:
462: -- cursor for unit1_value
463: CURSOR unit1_val_cur IS

Line 483: pqh_budget_versions_api.create_budget_version

479: FETCH unit1_val_cur INTO l_budget_unit1_value;
480: CLOSE unit1_val_cur;
481:
482: -- call insert API
483: pqh_budget_versions_api.create_budget_version
484: (
485: p_validate => false
486: ,p_budget_version_id => p_budget_version_id_o
487: ,p_budget_id => p_budget_id

Line 521: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

517:
518: PROCEDURE populate_budget_details
519: (
520: p_per_budget_elmnt_rec IN per_budget_elements%ROWTYPE,
521: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
522: p_tot_budget_val IN per_budget_values.value%TYPE,
523: p_budget_detail_id_o OUT NOCOPY pqh_budget_details.budget_detail_id%TYPE,
524: p_budget_unit1_value_o OUT NOCOPY pqh_budget_details.budget_unit1_value%TYPE
525: )

Line 785: This procedure will populate one row in pqh_budget_versions table for those budgets that have on row

781: --------------------------------------------------------------------------------------------------------------
782: PROCEDURE populate_empty_budget_versions
783: IS
784: /*
785: This procedure will populate one row in pqh_budget_versions table for those budgets that have on row
786: here. This is a new rqmt that thete cannot be a row in pqh_budgets table without any child rows in
787: pqh_budget_versions
788: */
789: -- local variables and cursors

Line 787: pqh_budget_versions

783: IS
784: /*
785: This procedure will populate one row in pqh_budget_versions table for those budgets that have on row
786: here. This is a new rqmt that thete cannot be a row in pqh_budgets table without any child rows in
787: pqh_budget_versions
788: */
789: -- local variables and cursors
790:
791: l_proc varchar2(72) := g_package||'populate_empty_budget_versions';

Line 793: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

789: -- local variables and cursors
790:
791: l_proc varchar2(72) := g_package||'populate_empty_budget_versions';
792: l_budget_rec pqh_budgets%ROWTYPE;
793: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
794: l_object_version_number pqh_budget_versions.object_version_number%TYPE;
795:
796: CURSOR budgets_csr is
797: SELECT * FROM pqh_budgets

Line 794: l_object_version_number pqh_budget_versions.object_version_number%TYPE;

790:
791: l_proc varchar2(72) := g_package||'populate_empty_budget_versions';
792: l_budget_rec pqh_budgets%ROWTYPE;
793: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
794: l_object_version_number pqh_budget_versions.object_version_number%TYPE;
795:
796: CURSOR budgets_csr is
797: SELECT * FROM pqh_budgets
798: WHERE budget_id NOT IN ( SELECT DISTINCT budget_id

Line 799: FROM pqh_budget_versions );

795:
796: CURSOR budgets_csr is
797: SELECT * FROM pqh_budgets
798: WHERE budget_id NOT IN ( SELECT DISTINCT budget_id
799: FROM pqh_budget_versions );
800:
801: BEGIN
802:
803: hr_utility.set_location('Entering: '||l_proc, 5);

Line 812: pqh_budget_versions_api.create_budget_version

808: FETCH budgets_csr INTO l_budget_rec;
809: EXIT WHEN budgets_csr%NOTFOUND;
810:
811: -- call insert API
812: pqh_budget_versions_api.create_budget_version
813: (
814: p_validate => false
815: ,p_budget_version_id => l_budget_version_id
816: ,p_budget_id => l_budget_rec.budget_id