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_BUDGETS

Line 61: l_budget_id pqh_budgets.budget_id%TYPE;

57:
58:
59: l_proc varchar2(72) := g_package||'extract_data';
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;

Line 130: -- create records in pqh_budgets

126: p_per_budgets_rec => l_per_budget_rec,
127: p_valid => l_valid
128: );
129:
130: -- create records in pqh_budgets
131: populate_budgets
132: (
133: p_per_budgets_rec => l_per_budget_rec,
134: p_valid => l_valid,

Line 289: p_budget_id_o OUT NOCOPY pqh_budgets.budget_id%TYPE,

285: PROCEDURE populate_budgets
286: (
287: p_per_budgets_rec IN per_budgets%ROWTYPE,
288: p_valid IN varchar2,
289: p_budget_id_o OUT NOCOPY pqh_budgets.budget_id%TYPE,
290: p_tot_budget_val_o OUT NOCOPY per_budget_values.value%TYPE
291: )
292: IS
293: -- local variables and cursors

Line 296: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE := 'OPEN';

292: IS
293: -- local variables and cursors
294:
295: l_proc varchar2(72) := g_package||'populate_budgets';
296: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE := 'OPEN';
297: l_budget_style_cd pqh_budgets.budget_style_cd%TYPE := 'BOTTOM';
298: l_budget_start_date pqh_budgets.budget_start_date%TYPE;
299: l_budget_end_date pqh_budgets.budget_end_date%TYPE;
300: l_object_version_number pqh_budgets.object_version_number%TYPE;

Line 297: l_budget_style_cd pqh_budgets.budget_style_cd%TYPE := 'BOTTOM';

293: -- local variables and cursors
294:
295: l_proc varchar2(72) := g_package||'populate_budgets';
296: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE := 'OPEN';
297: l_budget_style_cd pqh_budgets.budget_style_cd%TYPE := 'BOTTOM';
298: l_budget_start_date pqh_budgets.budget_start_date%TYPE;
299: l_budget_end_date pqh_budgets.budget_end_date%TYPE;
300: l_object_version_number pqh_budgets.object_version_number%TYPE;
301: l_tot_budget_val per_budget_values.value%TYPE;

Line 298: l_budget_start_date pqh_budgets.budget_start_date%TYPE;

294:
295: l_proc varchar2(72) := g_package||'populate_budgets';
296: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE := 'OPEN';
297: l_budget_style_cd pqh_budgets.budget_style_cd%TYPE := 'BOTTOM';
298: l_budget_start_date pqh_budgets.budget_start_date%TYPE;
299: l_budget_end_date pqh_budgets.budget_end_date%TYPE;
300: l_object_version_number pqh_budgets.object_version_number%TYPE;
301: l_tot_budget_val per_budget_values.value%TYPE;
302: l_shared_type_id pqh_budgets.budget_unit1_id%TYPE;

Line 299: l_budget_end_date pqh_budgets.budget_end_date%TYPE;

295: l_proc varchar2(72) := g_package||'populate_budgets';
296: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE := 'OPEN';
297: l_budget_style_cd pqh_budgets.budget_style_cd%TYPE := 'BOTTOM';
298: l_budget_start_date pqh_budgets.budget_start_date%TYPE;
299: l_budget_end_date pqh_budgets.budget_end_date%TYPE;
300: l_object_version_number pqh_budgets.object_version_number%TYPE;
301: l_tot_budget_val per_budget_values.value%TYPE;
302: l_shared_type_id pqh_budgets.budget_unit1_id%TYPE;
303: l_status pqh_budgets.status%TYPE;

Line 300: l_object_version_number pqh_budgets.object_version_number%TYPE;

296: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE := 'OPEN';
297: l_budget_style_cd pqh_budgets.budget_style_cd%TYPE := 'BOTTOM';
298: l_budget_start_date pqh_budgets.budget_start_date%TYPE;
299: l_budget_end_date pqh_budgets.budget_end_date%TYPE;
300: l_object_version_number pqh_budgets.object_version_number%TYPE;
301: l_tot_budget_val per_budget_values.value%TYPE;
302: l_shared_type_id pqh_budgets.budget_unit1_id%TYPE;
303: l_status pqh_budgets.status%TYPE;
304: l_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE := 'ACCUMULATE';

Line 302: l_shared_type_id pqh_budgets.budget_unit1_id%TYPE;

298: l_budget_start_date pqh_budgets.budget_start_date%TYPE;
299: l_budget_end_date pqh_budgets.budget_end_date%TYPE;
300: l_object_version_number pqh_budgets.object_version_number%TYPE;
301: l_tot_budget_val per_budget_values.value%TYPE;
302: l_shared_type_id pqh_budgets.budget_unit1_id%TYPE;
303: l_status pqh_budgets.status%TYPE;
304: l_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE := 'ACCUMULATE';
305:
306:

Line 303: l_status pqh_budgets.status%TYPE;

299: l_budget_end_date pqh_budgets.budget_end_date%TYPE;
300: l_object_version_number pqh_budgets.object_version_number%TYPE;
301: l_tot_budget_val per_budget_values.value%TYPE;
302: l_shared_type_id pqh_budgets.budget_unit1_id%TYPE;
303: l_status pqh_budgets.status%TYPE;
304: l_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE := 'ACCUMULATE';
305:
306:
307: -- cursor to compute budget start and end dates

Line 304: l_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE := 'ACCUMULATE';

300: l_object_version_number pqh_budgets.object_version_number%TYPE;
301: l_tot_budget_val per_budget_values.value%TYPE;
302: l_shared_type_id pqh_budgets.budget_unit1_id%TYPE;
303: l_status pqh_budgets.status%TYPE;
304: l_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE := 'ACCUMULATE';
305:
306:
307: -- cursor to compute budget start and end dates
308:

Line 398: pqh_budgets_api.create_budget

394:
395: hr_utility.set_location('l_budget_unit1_aggregate : '||l_budget_unit1_aggregate,26);
396:
397: -- call insert API
398: pqh_budgets_api.create_budget
399: (
400: p_validate => false
401: ,p_budget_id => p_budget_id_o
402: ,p_business_group_id => p_per_budgets_rec.business_group_id

Line 450: p_budget_id IN pqh_budgets.budget_id%TYPE,

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

Line 786: here. This is a new rqmt that thete cannot be a row in pqh_budgets table without any child rows in

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

Line 792: l_budget_rec pqh_budgets%ROWTYPE;

788: */
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

Line 797: SELECT * FROM pqh_budgets

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
799: FROM pqh_budget_versions );
800:
801: BEGIN