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.HR_RATE_VALUES_SWI dependencies on HR_API

Line 133: (p_validate in number default hr_api.g_false_num

129: -- ----------------------------------------------------------------------------
130: -- |---------------------------< create_rate_value >--------------------------|
131: -- ----------------------------------------------------------------------------
132: PROCEDURE create_rate_value
133: (p_validate in number default hr_api.g_false_num
134: ,p_effective_date in date
135: ,p_business_group_id in number
136: ,p_rate_id in number
137: ,p_grade_or_spinal_point_id in number

Line 177: hr_api.constant_to_boolean

173: --
174: -- Convert constant values to their corresponding boolean value
175: --
176: l_validate :=
177: hr_api.constant_to_boolean
178: (p_constant_value => p_validate);
179: --
180: -- Register Surrogate ID or user key values
181: --

Line 269: ,p_currency_code in varchar2 default hr_api.g_varchar2

265: (p_validate in boolean default false
266: ,p_grade_rule_id in number
267: ,p_effective_date in date
268: ,p_datetrack_mode in varchar2
269: ,p_currency_code in varchar2 default hr_api.g_varchar2
270: ,p_value in varchar2 default hr_api.g_varchar2
271: ,p_object_version_number in out nocopy number
272: ,p_effective_start_date out nocopy date
273: ,p_effective_end_date out nocopy date

Line 270: ,p_value in varchar2 default hr_api.g_varchar2

266: ,p_grade_rule_id in number
267: ,p_effective_date in date
268: ,p_datetrack_mode in varchar2
269: ,p_currency_code in varchar2 default hr_api.g_varchar2
270: ,p_value in varchar2 default hr_api.g_varchar2
271: ,p_object_version_number in out nocopy number
272: ,p_effective_start_date out nocopy date
273: ,p_effective_end_date out nocopy date
274: ,p_return_status out nocopy varchar2

Line 369: (p_validate in number default hr_api.g_false_num

365: -- ----------------------------------------------------------------------------
366: -- |---------------------------< update_rate_value >--------------------------|
367: -- ----------------------------------------------------------------------------
368: PROCEDURE update_rate_value
369: (p_validate in number default hr_api.g_false_num
370: ,p_grade_rule_id in number
371: ,p_effective_date in date
372: ,p_datetrack_mode in varchar2
373: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 373: ,p_currency_code in varchar2 default hr_api.g_varchar2

369: (p_validate in number default hr_api.g_false_num
370: ,p_grade_rule_id in number
371: ,p_effective_date in date
372: ,p_datetrack_mode in varchar2
373: ,p_currency_code in varchar2 default hr_api.g_varchar2
374: ,p_maximum in varchar2 default hr_api.g_varchar2
375: ,p_mid_value in varchar2 default hr_api.g_varchar2
376: ,p_minimum in varchar2 default hr_api.g_varchar2
377: ,p_sequence in number default hr_api.g_number

Line 374: ,p_maximum in varchar2 default hr_api.g_varchar2

370: ,p_grade_rule_id in number
371: ,p_effective_date in date
372: ,p_datetrack_mode in varchar2
373: ,p_currency_code in varchar2 default hr_api.g_varchar2
374: ,p_maximum in varchar2 default hr_api.g_varchar2
375: ,p_mid_value in varchar2 default hr_api.g_varchar2
376: ,p_minimum in varchar2 default hr_api.g_varchar2
377: ,p_sequence in number default hr_api.g_number
378: ,p_value in varchar2 default hr_api.g_varchar2

Line 375: ,p_mid_value in varchar2 default hr_api.g_varchar2

371: ,p_effective_date in date
372: ,p_datetrack_mode in varchar2
373: ,p_currency_code in varchar2 default hr_api.g_varchar2
374: ,p_maximum in varchar2 default hr_api.g_varchar2
375: ,p_mid_value in varchar2 default hr_api.g_varchar2
376: ,p_minimum in varchar2 default hr_api.g_varchar2
377: ,p_sequence in number default hr_api.g_number
378: ,p_value in varchar2 default hr_api.g_varchar2
379: ,p_object_version_number in out nocopy number

Line 376: ,p_minimum in varchar2 default hr_api.g_varchar2

372: ,p_datetrack_mode in varchar2
373: ,p_currency_code in varchar2 default hr_api.g_varchar2
374: ,p_maximum in varchar2 default hr_api.g_varchar2
375: ,p_mid_value in varchar2 default hr_api.g_varchar2
376: ,p_minimum in varchar2 default hr_api.g_varchar2
377: ,p_sequence in number default hr_api.g_number
378: ,p_value in varchar2 default hr_api.g_varchar2
379: ,p_object_version_number in out nocopy number
380: ,p_effective_start_date out nocopy date

Line 377: ,p_sequence in number default hr_api.g_number

373: ,p_currency_code in varchar2 default hr_api.g_varchar2
374: ,p_maximum in varchar2 default hr_api.g_varchar2
375: ,p_mid_value in varchar2 default hr_api.g_varchar2
376: ,p_minimum in varchar2 default hr_api.g_varchar2
377: ,p_sequence in number default hr_api.g_number
378: ,p_value in varchar2 default hr_api.g_varchar2
379: ,p_object_version_number in out nocopy number
380: ,p_effective_start_date out nocopy date
381: ,p_effective_end_date out nocopy date

Line 378: ,p_value in varchar2 default hr_api.g_varchar2

374: ,p_maximum in varchar2 default hr_api.g_varchar2
375: ,p_mid_value in varchar2 default hr_api.g_varchar2
376: ,p_minimum in varchar2 default hr_api.g_varchar2
377: ,p_sequence in number default hr_api.g_number
378: ,p_value in varchar2 default hr_api.g_varchar2
379: ,p_object_version_number in out nocopy number
380: ,p_effective_start_date out nocopy date
381: ,p_effective_end_date out nocopy date
382: ,p_return_status out nocopy varchar2

Line 411: hr_api.constant_to_boolean

407: --
408: -- Convert constant values to their corresponding boolean value
409: --
410: l_validate :=
411: hr_api.constant_to_boolean
412: (p_constant_value => p_validate);
413: --
414: -- Register Surrogate ID or user key values
415: --

Line 596: (p_validate in number default hr_api.g_false_num

592: -- ----------------------------------------------------------------------------
593: -- |---------------------------< delete_rate_value >--------------------------|
594: -- ----------------------------------------------------------------------------
595: PROCEDURE delete_rate_value
596: (p_validate in number default hr_api.g_false_num
597: ,p_grade_rule_id in number
598: ,p_datetrack_mode in varchar2
599: ,p_effective_date in date
600: ,p_object_version_number in out nocopy number

Line 632: hr_api.constant_to_boolean

628: --
629: -- Convert constant values to their corresponding boolean value
630: --
631: l_validate :=
632: hr_api.constant_to_boolean
633: (p_constant_value => p_validate);
634: --
635: -- Register Surrogate ID or user key values
636: --

Line 825: select name, number_value from hr_api_transaction_values

821: l_stp_value_name varchar2(20);
822: l_po_installed boolean default false;
823:
824: cursor get_step_values (p_transaction_step_id in number) is
825: select name, number_value from hr_api_transaction_values
826: where transaction_step_id = p_transaction_step_id
827: and name = 'P_PO_LINE_ID';
828:
829: not_a_valid_po_txn exception;

Line 908: ,p_item_type in VARCHAR2 default hr_api.g_varchar2

904:
905: PROCEDURE process_save
906: (p_mode in VARCHAR2 default '#'
907: ,p_flow_mode in VARCHAR2 default NULL
908: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
909: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
910: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
911: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
912: ,p_asg_rate_tab in HR_ASG_RATE_TABLE

Line 909: ,p_item_key in VARCHAR2 default hr_api.g_varchar2

905: PROCEDURE process_save
906: (p_mode in VARCHAR2 default '#'
907: ,p_flow_mode in VARCHAR2 default NULL
908: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
909: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
910: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
911: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
912: ,p_asg_rate_tab in HR_ASG_RATE_TABLE
913: ,p_return_status out nocopy VARCHAR2

Line 910: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2

906: (p_mode in VARCHAR2 default '#'
907: ,p_flow_mode in VARCHAR2 default NULL
908: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
909: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
910: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
911: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
912: ,p_asg_rate_tab in HR_ASG_RATE_TABLE
913: ,p_return_status out nocopy VARCHAR2
914: ,p_transaction_step_id out nocopy NUMBER

Line 911: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2

907: ,p_flow_mode in VARCHAR2 default NULL
908: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
909: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
910: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
911: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
912: ,p_asg_rate_tab in HR_ASG_RATE_TABLE
913: ,p_return_status out nocopy VARCHAR2
914: ,p_transaction_step_id out nocopy NUMBER
915: ) is

Line 975: (trunc(l_asg_rate_rec.effective_end_date) <> trunc(hr_api.g_eot)))

971: then
972: -- New Record - INSERT MODE
973: close csr_basetb_data;
974: if (l_asg_rate_rec.effective_end_date is not null and
975: (trunc(l_asg_rate_rec.effective_end_date) <> trunc(hr_api.g_eot)))
976: then
977: l_record_status := g_insert_delete;
978: else
979: l_record_status := g_insert_only;

Line 993: -- l_asg_rate_rec.effective_end_date := hr_api.g_eot;

989: then
990: l_record_status := g_delete_only;
991: --if l_asg_rate_rec.effective_end_date is null
992: --then
993: -- l_asg_rate_rec.effective_end_date := hr_api.g_eot;
994: --end if;
995: end if;
996: else
997: if is_date_change_required(l_asg_rate_rec.effective_end_date,

Line 1003: -- l_asg_rate_rec.effective_end_date := hr_api.g_eot;

999: then
1000: l_record_status := g_update_delete;
1001: --if l_asg_rate_rec.effective_end_date is null
1002: --then
1003: -- l_asg_rate_rec.effective_end_date := hr_api.g_eot;
1004: --end if;
1005: else
1006: l_record_status := g_update_only;
1007: end if;

Line 1015: delete from hr_api_transaction_values

1011: if l_record_status = g_no_change
1012: then
1013: if l_asg_rate_rec.transaction_step_id is not null
1014: then
1015: delete from hr_api_transaction_values
1016: where transaction_step_id = l_asg_rate_rec.transaction_step_id;
1017: delete from hr_api_transaction_steps
1018: where transaction_step_id = l_asg_rate_rec.transaction_step_id;
1019: end if;

Line 1017: delete from hr_api_transaction_steps

1013: if l_asg_rate_rec.transaction_step_id is not null
1014: then
1015: delete from hr_api_transaction_values
1016: where transaction_step_id = l_asg_rate_rec.transaction_step_id;
1017: delete from hr_api_transaction_steps
1018: where transaction_step_id = l_asg_rate_rec.transaction_step_id;
1019: end if;
1020: goto end_of_process;
1021: end if;

Line 1197: ,p_item_type in VARCHAR2 default hr_api.g_varchar2

1193:
1194: PROCEDURE po_process_save
1195: (p_mode in VARCHAR2 default '#'
1196: ,p_flow_mode in VARCHAR2 default NULL
1197: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
1198: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
1199: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
1200: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
1201: ,p_po_line_id in NUMBER

Line 1198: ,p_item_key in VARCHAR2 default hr_api.g_varchar2

1194: PROCEDURE po_process_save
1195: (p_mode in VARCHAR2 default '#'
1196: ,p_flow_mode in VARCHAR2 default NULL
1197: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
1198: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
1199: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
1200: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
1201: ,p_po_line_id in NUMBER
1202: ,p_return_status out nocopy VARCHAR2

Line 1199: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2

1195: (p_mode in VARCHAR2 default '#'
1196: ,p_flow_mode in VARCHAR2 default NULL
1197: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
1198: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
1199: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
1200: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
1201: ,p_po_line_id in NUMBER
1202: ,p_return_status out nocopy VARCHAR2
1203: ,p_transaction_step_id out nocopy NUMBER

Line 1200: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2

1196: ,p_flow_mode in VARCHAR2 default NULL
1197: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
1198: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
1199: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
1200: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
1201: ,p_po_line_id in NUMBER
1202: ,p_return_status out nocopy VARCHAR2
1203: ,p_transaction_step_id out nocopy NUMBER
1204: ) is

Line 1376: decode(trunc(g.date_value), trunc(hr_api.g_eot), null, g.date_value) effective_end_date,

1372: c.varchar2_value rate_basis_name,
1373: d.varchar2_value currency_name,
1374: e.varchar2_value value,
1375: f.date_value effective_start_date,
1376: decode(trunc(g.date_value), trunc(hr_api.g_eot), null, g.date_value) effective_end_date,
1377: h.number_value object_version_number,
1378: i.number_value grade_rule_id,
1379: j.varchar2_value currency_code,
1380: to_char(s.transaction_step_id) transaction_step_id

Line 1381: FROM hr_api_transaction_steps s,

1377: h.number_value object_version_number,
1378: i.number_value grade_rule_id,
1379: j.varchar2_value currency_code,
1380: to_char(s.transaction_step_id) transaction_step_id
1381: FROM hr_api_transaction_steps s,
1382: hr_api_transaction_values a, hr_api_transaction_values b,
1383: hr_api_transaction_values c, hr_api_transaction_values d,
1384: hr_api_transaction_values e, hr_api_transaction_values f,
1385: hr_api_transaction_values g, hr_api_transaction_values h,

Line 1382: hr_api_transaction_values a, hr_api_transaction_values b,

1378: i.number_value grade_rule_id,
1379: j.varchar2_value currency_code,
1380: to_char(s.transaction_step_id) transaction_step_id
1381: FROM hr_api_transaction_steps s,
1382: hr_api_transaction_values a, hr_api_transaction_values b,
1383: hr_api_transaction_values c, hr_api_transaction_values d,
1384: hr_api_transaction_values e, hr_api_transaction_values f,
1385: hr_api_transaction_values g, hr_api_transaction_values h,
1386: hr_api_transaction_values i, hr_api_transaction_values j

Line 1383: hr_api_transaction_values c, hr_api_transaction_values d,

1379: j.varchar2_value currency_code,
1380: to_char(s.transaction_step_id) transaction_step_id
1381: FROM hr_api_transaction_steps s,
1382: hr_api_transaction_values a, hr_api_transaction_values b,
1383: hr_api_transaction_values c, hr_api_transaction_values d,
1384: hr_api_transaction_values e, hr_api_transaction_values f,
1385: hr_api_transaction_values g, hr_api_transaction_values h,
1386: hr_api_transaction_values i, hr_api_transaction_values j
1387: WHERE s.item_type = p_item_type

Line 1384: hr_api_transaction_values e, hr_api_transaction_values f,

1380: to_char(s.transaction_step_id) transaction_step_id
1381: FROM hr_api_transaction_steps s,
1382: hr_api_transaction_values a, hr_api_transaction_values b,
1383: hr_api_transaction_values c, hr_api_transaction_values d,
1384: hr_api_transaction_values e, hr_api_transaction_values f,
1385: hr_api_transaction_values g, hr_api_transaction_values h,
1386: hr_api_transaction_values i, hr_api_transaction_values j
1387: WHERE s.item_type = p_item_type
1388: AND s.item_key = p_item_key

Line 1385: hr_api_transaction_values g, hr_api_transaction_values h,

1381: FROM hr_api_transaction_steps s,
1382: hr_api_transaction_values a, hr_api_transaction_values b,
1383: hr_api_transaction_values c, hr_api_transaction_values d,
1384: hr_api_transaction_values e, hr_api_transaction_values f,
1385: hr_api_transaction_values g, hr_api_transaction_values h,
1386: hr_api_transaction_values i, hr_api_transaction_values j
1387: WHERE s.item_type = p_item_type
1388: AND s.item_key = p_item_key
1389: AND s.api_name = g_package||'.PROCESS_API'

Line 1386: hr_api_transaction_values i, hr_api_transaction_values j

1382: hr_api_transaction_values a, hr_api_transaction_values b,
1383: hr_api_transaction_values c, hr_api_transaction_values d,
1384: hr_api_transaction_values e, hr_api_transaction_values f,
1385: hr_api_transaction_values g, hr_api_transaction_values h,
1386: hr_api_transaction_values i, hr_api_transaction_values j
1387: WHERE s.item_type = p_item_type
1388: AND s.item_key = p_item_key
1389: AND s.api_name = g_package||'.PROCESS_API'
1390: AND a.transaction_step_id = s.transaction_step_id

Line 1420: decode(trunc(pgr.effective_end_date), trunc(hr_api.g_eot), null, pgr.effective_end_date) effective_end_date,

1416: pgr.rate_basis_name,
1417: pgr.currency_name,
1418: pgr.value,
1419: pgr.effective_start_date,
1420: decode(trunc(pgr.effective_end_date), trunc(hr_api.g_eot), null, pgr.effective_end_date) effective_end_date,
1421: pgr.object_version_number,
1422: pgr.grade_rule_id,
1423: pgr.currency_code,
1424: NULL transaction_step_id

Line 1430: FROM hr_api_transaction_steps s,

1426: WHERE pgr.rate_type = 'A'
1427: AND pgr.assignment_id = to_number(p_assignment_id)
1428: AND pgr.business_group_id = to_number(p_business_gp_id)
1429: AND pgr.grade_rule_id NOT IN (SELECT nvl(a.number_value, -1)
1430: FROM hr_api_transaction_steps s,
1431: hr_api_transaction_values a
1432: WHERE s.item_type = p_item_type
1433: AND s.item_key = p_item_key
1434: AND s.api_name = g_package||'.PROCESS_API'

Line 1431: hr_api_transaction_values a

1427: AND pgr.assignment_id = to_number(p_assignment_id)
1428: AND pgr.business_group_id = to_number(p_business_gp_id)
1429: AND pgr.grade_rule_id NOT IN (SELECT nvl(a.number_value, -1)
1430: FROM hr_api_transaction_steps s,
1431: hr_api_transaction_values a
1432: WHERE s.item_type = p_item_type
1433: AND s.item_key = p_item_key
1434: AND s.api_name = g_package||'.PROCESS_API'
1435: AND a.transaction_step_id = s.transaction_step_id

Line 1517: if trunc(p_asg_rate_rec.effective_start_date) > trunc(nvl(p_asg_rate_rec.effective_end_date, hr_api.g_eot))

1513: p_record_status = g_insert_delete or
1514: p_record_status = g_delete_only)
1515: then
1516: hr_multi_message.enable_message_list;
1517: if trunc(p_asg_rate_rec.effective_start_date) > trunc(nvl(p_asg_rate_rec.effective_end_date, hr_api.g_eot))
1518: then
1519: hr_utility.set_message(800, 'HR_ASG_RATE_INV_END_DATE');
1520: l_temp := hr_multi_message.exception_add
1521: (p_associated_column1 => 'PAY_GRADE_RULES_F.EFFECTIVE_END_DATE');

Line 1596: if trunc(l_rec_end_date) <> trunc(hr_api.g_eot)

1592: p_record_status = g_delete_only)
1593: then
1594: begin
1595: savepoint record_delete_point;
1596: if trunc(l_rec_end_date) <> trunc(hr_api.g_eot)
1597: then
1598: delete_rate_value
1599: (p_validate => l_validate
1600: ,p_grade_rule_id => l_grade_rule_id

Line 1667: delete from hr_api_transaction_values

1663: PROCEDURE delete_transaction_step
1664: (p_transaction_step_id in VARCHAR2
1665: ) is
1666: begin
1667: delete from hr_api_transaction_values
1668: where transaction_step_id = p_transaction_step_id;
1669: delete from hr_api_transaction_steps
1670: where transaction_step_id = p_transaction_step_id;
1671: end delete_transaction_step;

Line 1669: delete from hr_api_transaction_steps

1665: ) is
1666: begin
1667: delete from hr_api_transaction_values
1668: where transaction_step_id = p_transaction_step_id;
1669: delete from hr_api_transaction_steps
1670: where transaction_step_id = p_transaction_step_id;
1671: end delete_transaction_step;
1672:
1673: FUNCTION is_date_change_required

Line 1681: if trunc(p_old_date) = trunc(hr_api.g_eot)

1677: l_date_change_status boolean;
1678: begin
1679: if p_new_date is null
1680: then
1681: if trunc(p_old_date) = trunc(hr_api.g_eot)
1682: then
1683: l_date_change_status := false;
1684: else
1685: l_date_change_status := true; -- in this case defaulting to hr_api.g_eot

Line 1685: l_date_change_status := true; -- in this case defaulting to hr_api.g_eot

1681: if trunc(p_old_date) = trunc(hr_api.g_eot)
1682: then
1683: l_date_change_status := false;
1684: else
1685: l_date_change_status := true; -- in this case defaulting to hr_api.g_eot
1686: end if;
1687: else
1688: if trunc(p_new_date) = trunc(hr_api.g_eot)
1689: then

Line 1688: if trunc(p_new_date) = trunc(hr_api.g_eot)

1684: else
1685: l_date_change_status := true; -- in this case defaulting to hr_api.g_eot
1686: end if;
1687: else
1688: if trunc(p_new_date) = trunc(hr_api.g_eot)
1689: then
1690: if trunc(p_old_date) = trunc(hr_api.g_eot)
1691: then
1692: l_date_change_status := false;

Line 1690: if trunc(p_old_date) = trunc(hr_api.g_eot)

1686: end if;
1687: else
1688: if trunc(p_new_date) = trunc(hr_api.g_eot)
1689: then
1690: if trunc(p_old_date) = trunc(hr_api.g_eot)
1691: then
1692: l_date_change_status := false;
1693: else
1694: l_date_change_status := true;