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 PER_BUDGETS

Line 29: p_budget_name IN per_budgets.name%TYPE DEFAULT NULL,

25: PROCEDURE extract_data
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

Line 31: p_business_group_id IN per_budgets.business_group_id%TYPE

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

Line 38: FROM per_budgets

34: -- local variables and cursors
35:
36: CURSOR per_budget_cur IS
37: SELECT *
38: FROM per_budgets
39: WHERE name = NVL(p_budget_name, name)
40: AND business_group_id = p_business_group_id
41: AND NVL(budget_type_code,'X') <> 'OTA_BUDGET' ;
42:

Line 43: CURSOR per_budget_ver_cur (p_budget_id IN per_budgets.budget_id%TYPE) IS

39: WHERE name = NVL(p_budget_name, name)
40: AND business_group_id = p_business_group_id
41: AND NVL(budget_type_code,'X') <> 'OTA_BUDGET' ;
42:
43: CURSOR per_budget_ver_cur (p_budget_id IN per_budgets.budget_id%TYPE) IS
44: SELECT *
45: FROM per_budget_versions
46: WHERE budget_id = p_budget_id;
47:

Line 60: l_per_budget_rec per_budgets%ROWTYPE;

56: WHERE budget_element_id = p_budget_element_id;
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;

Line 126: p_per_budgets_rec => l_per_budget_rec,

122:
123: -- check if budget is valid
124: check_valid_budget
125: (
126: p_per_budgets_rec => l_per_budget_rec,
127: p_valid => l_valid
128: );
129:
130: -- create records in pqh_budgets

Line 133: p_per_budgets_rec => l_per_budget_rec,

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,
135: p_budget_id_o => l_budget_id,
136: p_tot_budget_val_o => l_tot_budget_val
137: );

Line 287: p_per_budgets_rec IN per_budgets%ROWTYPE,

283: --------------------------------------------------------------------------------------------------------------
284:
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: )

Line 320: AND ver.budget_id = p_per_budgets_rec.budget_id

316: per_budget_elements ele,
317: per_budget_versions ver
318: WHERE val.budget_element_id = ele.budget_element_id
319: AND ele.budget_version_id = ver.budget_version_id
320: AND ver.budget_id = p_per_budgets_rec.budget_id
321: );
322:
323:
324: -- cursor to compute budget start and end dates for budget with no child records

Line 330: WHERE period_set_name = p_per_budgets_rec.period_set_name;

326:
327: CURSOR budget_cal_cur IS
328: SELECT start_date, start_date
329: FROM pay_calendars
330: WHERE period_set_name = p_per_budgets_rec.period_set_name;
331:
332: -- cursor for unit1_value for ALL versions of the budget
333: -- this is used to compute the percentage at detail level
334:

Line 343: AND ver.budget_id = p_per_budgets_rec.budget_id

339: ( SELECT ele.budget_element_id
340: FROM per_budget_elements ele,
341: per_budget_versions ver
342: WHERE ele.budget_version_id = ver.budget_version_id
343: AND ver.budget_id = p_per_budgets_rec.budget_id
344: );
345:
346:
347: BEGIN

Line 371: hr_utility.set_location('Per Budget Id: '||p_per_budgets_rec.budget_id, 10);

367: FETCH budget_cal_cur INTO l_budget_start_date, l_budget_end_date;
368: CLOSE budget_cal_cur;
369: END IF;
370:
371: hr_utility.set_location('Per Budget Id: '||p_per_budgets_rec.budget_id, 10);
372: hr_utility.set_location('Start Date: '||l_budget_start_date, 15);
373: hr_utility.set_location('End Date: '||l_budget_end_date, 20);
374:
375: -- get the shared_type_id for UOM

Line 377: l_shared_type_id := get_shared_type_id (p_unit => p_per_budgets_rec.unit );

373: hr_utility.set_location('End Date: '||l_budget_end_date, 20);
374:
375: -- get the shared_type_id for UOM
376:
377: l_shared_type_id := get_shared_type_id (p_unit => p_per_budgets_rec.unit );
378:
379: -- compute budget status, if unit is null then status is null else status is FROZEN
380:
381: IF p_per_budgets_rec.unit IS NULL THEN

Line 381: IF p_per_budgets_rec.unit IS NULL THEN

377: l_shared_type_id := get_shared_type_id (p_unit => p_per_budgets_rec.unit );
378:
379: -- compute budget status, if unit is null then status is null else status is FROZEN
380:
381: IF p_per_budgets_rec.unit IS NULL THEN
382: l_status := '';
383: ELSE
384: l_status := 'FROZEN';
385: END IF;

Line 402: ,p_business_group_id => p_per_budgets_rec.business_group_id

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
403: ,p_start_organization_id => null
404: ,p_org_structure_version_id => null
405: ,p_budgeted_entity_cd => l_budgeted_entity_cd
406: ,p_budget_style_cd => l_budget_style_cd

Line 407: ,p_budget_name => p_per_budgets_rec.name

403: ,p_start_organization_id => null
404: ,p_org_structure_version_id => null
405: ,p_budgeted_entity_cd => l_budgeted_entity_cd
406: ,p_budget_style_cd => l_budget_style_cd
407: ,p_budget_name => p_per_budgets_rec.name
408: ,p_period_set_name => p_per_budgets_rec.period_set_name
409: ,p_budget_start_date => l_budget_start_date
410: ,p_budget_end_date => l_budget_end_date
411: ,p_budget_unit1_id => l_shared_type_id

Line 408: ,p_period_set_name => p_per_budgets_rec.period_set_name

404: ,p_org_structure_version_id => null
405: ,p_budgeted_entity_cd => l_budgeted_entity_cd
406: ,p_budget_style_cd => l_budget_style_cd
407: ,p_budget_name => p_per_budgets_rec.name
408: ,p_period_set_name => p_per_budgets_rec.period_set_name
409: ,p_budget_start_date => l_budget_start_date
410: ,p_budget_end_date => l_budget_end_date
411: ,p_budget_unit1_id => l_shared_type_id
412: ,p_budget_unit2_id => null

Line 674: FUNCTION get_shared_type_id (p_unit IN per_budgets.unit%TYPE ) RETURN number

670: );
671: END populate_budget_periods;
672:
673: --------------------------------------------------------------------------------------------------------------
674: FUNCTION get_shared_type_id (p_unit IN per_budgets.unit%TYPE ) RETURN number
675: IS
676:
677: CURSOR uom_csr IS
678: SELECT pst.shared_type_id

Line 1146: -- table_route_id for per_budgets

1142:
1143:
1144: -- get table_route_id for all the tables
1145:
1146: -- table_route_id for per_budgets
1147: OPEN csr_table_route (p_table_alias => 'P_BGT');
1148: FETCH csr_table_route INTO g_table_route_id_p_bgt;
1149: CLOSE csr_table_route;
1150:

Line 1205: p_budget_id IN per_budgets.budget_id%TYPE,

1201:
1202: --------------------------------------------------------------------------------------------------------------
1203: PROCEDURE set_p_bgt_log_context
1204: (
1205: p_budget_id IN per_budgets.budget_id%TYPE,
1206: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
1207: ) IS
1208: /*
1209: This procedure will set the log_context at per budgets level

Line 1209: This procedure will set the log_context at per budgets level

1205: p_budget_id IN per_budgets.budget_id%TYPE,
1206: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
1207: ) IS
1208: /*
1209: This procedure will set the log_context at per budgets level
1210: */
1211:
1212: l_proc varchar2(72) := g_package||'set_p_bgt_log_context';
1213: l_bdg_name per_budgets.name%TYPE;

Line 1213: l_bdg_name per_budgets.name%TYPE;

1209: This procedure will set the log_context at per budgets level
1210: */
1211:
1212: l_proc varchar2(72) := g_package||'set_p_bgt_log_context';
1213: l_bdg_name per_budgets.name%TYPE;
1214:
1215: CURSOR bdg_name_csr IS
1216: SELECT name
1217: FROM per_budgets

Line 1217: FROM per_budgets

1213: l_bdg_name per_budgets.name%TYPE;
1214:
1215: CURSOR bdg_name_csr IS
1216: SELECT name
1217: FROM per_budgets
1218: WHERE budget_id = p_budget_id;
1219:
1220: BEGIN
1221:

Line 1260: This procedure will set the log_context at per budgets level

1256: p_budget_version_id IN per_budget_versions.budget_version_id%TYPE,
1257: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
1258: ) IS
1259: /*
1260: This procedure will set the log_context at per budgets level
1261: */
1262:
1263: l_proc varchar2(72) := g_package||'set_p_bvr_log_context';
1264: l_bdg_ver_number per_budget_versions.version_number%TYPE;

Line 1307: This procedure will set the log_context at per budgets level

1303: p_budget_element_id IN per_budget_elements.budget_element_id%TYPE,
1304: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
1305: ) IS
1306: /*
1307: This procedure will set the log_context at per budgets level
1308: Display Order is P J O G ( which ever is not null
1309: */
1310: l_proc varchar2(72) := g_package||'set_p_bdt_log_context';
1311: l_budget_elements_rec per_budget_elements%ROWTYPE;

Line 1372: This procedure will set the log_context at per budgets level

1368: p_budget_value_id IN per_budget_values.budget_value_id%TYPE,
1369: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
1370: ) IS
1371: /*
1372: This procedure will set the log_context at per budgets level
1373: */
1374:
1375: l_proc varchar2(72) := g_package||'set_p_bpr_log_context';
1376: l_per_budget_values_rec per_budget_values%ROWTYPE;

Line 1425: p_budget_name IN per_budgets.name%TYPE,

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

Line 1427: p_business_group_id IN per_budgets.business_group_id%TYPE

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
1431: Valid Params :

Line 1432: There should atleast be one record in per_budgets with name = p_budget_name and budget_type_code <> OTA_BUDGET

1428: ) IS
1429: /*
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:

Line 1445: FROM per_budgets

1441:
1442:
1443: CURSOR cnt_budgets_csr IS
1444: SELECT COUNT(*)
1445: FROM per_budgets
1446: WHERE name = NVL(p_budget_name, name)
1447: AND business_group_id = p_business_group_id
1448: AND NVL(budget_type_code,'X') <> 'OTA_BUDGET' ;
1449:

Line 1493: p_per_budgets_rec IN per_budgets%ROWTYPE,

1489:
1490: --------------------------------------------------------------------------------------------------------------
1491: PROCEDURE check_valid_budget
1492: (
1493: p_per_budgets_rec IN per_budgets%ROWTYPE,
1494: p_valid OUT NOCOPY varchar2
1495: ) IS
1496: /*
1497: This procedure validates if the budget is valid. For budget to be valid there must be no

Line 1515: WHERE budget_id = p_per_budgets_rec.budget_id

1511: FROM per_budget_elements
1512: WHERE budget_version_id IN
1513: ( SELECT budget_version_id
1514: FROM per_budget_versions
1515: WHERE budget_id = p_per_budgets_rec.budget_id
1516: );
1517:
1518: CURSOR cnt_values IS
1519: SELECT COUNT(distinct budget_element_id)

Line 1527: WHERE budget_id = p_per_budgets_rec.budget_id

1523: FROM per_budget_elements
1524: WHERE budget_version_id IN
1525: ( SELECT budget_version_id
1526: FROM per_budget_versions
1527: WHERE budget_id = p_per_budgets_rec.budget_id
1528: )
1529: );
1530:
1531:

Line 1582: From per_budgets

1578: p_dflt_budget_set_id in number,
1579: p_request_number out nocopy number) is
1580: Cursor csr_budget is
1581: Select name,business_group_id
1582: From per_budgets
1583: Where budget_id = p_budget_id;
1584: --
1585: CURSOR bdg_sets_csr IS
1586: SELECT dflt_budget_set_name

Line 1590: l_name per_budgets.name%type;

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;
1592: l_bset_name pqh_dflt_budget_sets.dflt_budget_set_name%type;
1593: --
1594: begin

Line 1591: l_business_group_id per_budgets.business_group_id%type;

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;
1592: l_bset_name pqh_dflt_budget_sets.dflt_budget_set_name%type;
1593: --
1594: begin
1595: --