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_TRANSACTION_API dependencies on HR_API

Line 25: from hr_api_transaction_steps hats

21: --
22: cursor csr_hats is
23: select hats.transaction_step_id
24: ,hats.object_version_number
25: from hr_api_transaction_steps hats
26: where hats.item_type = p_item_type
27: and hats.item_key = p_item_key
28: and hats.activity_id = p_activity_id;
29: --

Line 71: from hr_api_transaction_steps hats

67: -- -------------------------------------------------------------------
68: cursor csr_hats is
69: select hats.transaction_step_id
70: ,hats.object_version_number
71: from hr_api_transaction_steps hats
72: where hats.item_type = p_item_type
73: and hats.item_key = p_item_key
74: and hats.activity_id = p_activity_id
75: order by hats.transaction_step_id, hats.object_version_number;

Line 116: from hr_api_transaction_steps hats

112: -- -------------------------------------------------------------------
113: cursor csr_hats is
114: select hats.transaction_step_id
115: ,hats.object_version_number
116: from hr_api_transaction_steps hats
117: where hats.item_type = p_item_type
118: and hats.item_key = p_item_key
119: order by hats.transaction_step_id, hats.object_version_number;
120: --

Line 160: from hr_api_transaction_steps hats

156: cursor csr_hats is
157: select hats.item_type
158: ,hats.item_key
159: ,hats.activity_id
160: from hr_api_transaction_steps hats
161: where hats.transaction_step_id = p_transaction_step_id;
162: --
163: begin
164: g_debug := hr_utility.debug_enabled;

Line 206: from hr_api_transaction_steps hats

202: -- -------------------------------------------------------------------
203: cursor csr_hapi is
204: select hats.transaction_step_id
205: ,hats.api_name
206: from hr_api_transaction_steps hats
207: where hats.item_type = p_item_type
208: and hats.item_key = p_item_key
209: and hats.activity_id = p_activity_id
210: order by hats.transaction_step_id, hats.object_version_number;

Line 215: from hr_api_transaction_steps hats

211: --
212: cursor csr_hapi_nAct is
213: select hats.transaction_step_id
214: ,hats.api_name
215: from hr_api_transaction_steps hats
216: where hats.item_type = p_item_type
217: and hats.item_key = p_item_key
218: order by hats.transaction_step_id, hats.object_version_number;
219: --

Line 271: l_object_version_number hr_api_transaction_steps.object_version_number%type;

267: -- --------------------------------------------------------------------------
268: -- declare local variables
269: -- --------------------------------------------------------------------------
270: l_proc constant varchar2(100) := g_package || ' transaction_step_exist';
271: l_object_version_number hr_api_transaction_steps.object_version_number%type;
272: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
273: l_return boolean := true;
274: --
275: begin

Line 272: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

268: -- declare local variables
269: -- --------------------------------------------------------------------------
270: l_proc constant varchar2(100) := g_package || ' transaction_step_exist';
271: l_object_version_number hr_api_transaction_steps.object_version_number%type;
272: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
273: l_return boolean := true;
274: --
275: begin
276: g_debug := hr_utility.debug_enabled;

Line 307: l_transaction_id hr_api_transactions.transaction_id%type;

303: -- --------------------------------------------------------------------------
304: -- declare local variables
305: -- --------------------------------------------------------------------------
306: l_proc constant varchar2(100) := g_package || ' get_transaction_id';
307: l_transaction_id hr_api_transactions.transaction_id%type;
308: -- cursor to select the transaction_id of the step
309: cursor csr_hats is
310: select hats.transaction_id
311: from hr_api_transaction_steps hats

Line 311: from hr_api_transaction_steps hats

307: l_transaction_id hr_api_transactions.transaction_id%type;
308: -- cursor to select the transaction_id of the step
309: cursor csr_hats is
310: select hats.transaction_id
311: from hr_api_transaction_steps hats
312: where hats.transaction_step_id = p_transaction_step_id;
313:
314: begin
315:

Line 349: l_creator_person_id hr_api_transactions.creator_person_id%type;

345: -- --------------------------------------------------------------------------
346: -- declare local variables
347: -- --------------------------------------------------------------------------
348: l_proc constant varchar2(100) := g_package || 'check_transaction_privilege';
349: l_creator_person_id hr_api_transactions.creator_person_id%type;
350: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
351: -- cursor to select the privilege
352: cursor csr_hat is
353: select hat.creator_person_id

Line 350: l_transaction_privilege hr_api_transactions.transaction_privilege%type;

346: -- declare local variables
347: -- --------------------------------------------------------------------------
348: l_proc constant varchar2(100) := g_package || 'check_transaction_privilege';
349: l_creator_person_id hr_api_transactions.creator_person_id%type;
350: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
351: -- cursor to select the privilege
352: cursor csr_hat is
353: select hat.creator_person_id
354: ,hat.transaction_privilege

Line 355: from hr_api_transactions hat

351: -- cursor to select the privilege
352: cursor csr_hat is
353: select hat.creator_person_id
354: ,hat.transaction_privilege
355: from hr_api_transactions hat
356: where hat.transaction_id = p_transaction_id;
357:
358: begin
359:

Line 426: raise hr_api.validate_enabled;

422: --
423: -- when in validation only mode raise the Validate_Enabled exception
424: --
425: if p_validate then
426: raise hr_api.validate_enabled;
427: end if;
428: --
429:
430: IF g_debug THEN

Line 435: when hr_api.validate_enabled then

431: hr_utility.set_location(' Leaving:'||l_proc, 10);
432: END IF;
433:
434: exception
435: when hr_api.validate_enabled then
436:
437: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
438: --
439: -- As the Validate_Enabled exception has been raised

Line 534: raise hr_api.validate_enabled;

530: --
531: -- when in validation only mode raise the Validate_Enabled exception
532: --
533: if p_validate then
534: raise hr_api.validate_enabled;
535: end if;
536: --
537:
538: IF g_debug THEN

Line 549: when hr_api.validate_enabled then

545: when url_too_long then
546: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
547: p_transaction_id := null;
548: hr_utility.trace(' exception in ' || 'Url too long, it supports only 4000 characters' );
549: when hr_api.validate_enabled then
550:
551: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
552: --
553: -- As the Validate_Enabled exception has been raised

Line 574: ,p_status in varchar2 default hr_api.g_varchar2

570: -- New procedure to accept transaction state and/or date_option as a parameter
571: procedure update_transaction
572: (p_validate in boolean default false
573: ,p_transaction_id in number
574: ,p_status in varchar2 default hr_api.g_varchar2
575: ,p_transaction_state in varchar2 default hr_api.g_varchar2
576: ,p_transaction_effective_date in date default hr_api.g_date
577: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
578: ,p_item_key in varchar2 default hr_api.g_varchar2

Line 575: ,p_transaction_state in varchar2 default hr_api.g_varchar2

571: procedure update_transaction
572: (p_validate in boolean default false
573: ,p_transaction_id in number
574: ,p_status in varchar2 default hr_api.g_varchar2
575: ,p_transaction_state in varchar2 default hr_api.g_varchar2
576: ,p_transaction_effective_date in date default hr_api.g_date
577: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
578: ,p_item_key in varchar2 default hr_api.g_varchar2
579: ) is

Line 576: ,p_transaction_effective_date in date default hr_api.g_date

572: (p_validate in boolean default false
573: ,p_transaction_id in number
574: ,p_status in varchar2 default hr_api.g_varchar2
575: ,p_transaction_state in varchar2 default hr_api.g_varchar2
576: ,p_transaction_effective_date in date default hr_api.g_date
577: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
578: ,p_item_key in varchar2 default hr_api.g_varchar2
579: ) is
580: ------

Line 577: ,p_effective_date_option in varchar2 default hr_api.g_varchar2

573: ,p_transaction_id in number
574: ,p_status in varchar2 default hr_api.g_varchar2
575: ,p_transaction_state in varchar2 default hr_api.g_varchar2
576: ,p_transaction_effective_date in date default hr_api.g_date
577: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
578: ,p_item_key in varchar2 default hr_api.g_varchar2
579: ) is
580: ------
581: l_proc constant varchar2(100) := g_package || ' update_transaction';

Line 578: ,p_item_key in varchar2 default hr_api.g_varchar2

574: ,p_status in varchar2 default hr_api.g_varchar2
575: ,p_transaction_state in varchar2 default hr_api.g_varchar2
576: ,p_transaction_effective_date in date default hr_api.g_date
577: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
578: ,p_item_key in varchar2 default hr_api.g_varchar2
579: ) is
580: ------
581: l_proc constant varchar2(100) := g_package || ' update_transaction';
582: begin

Line 874: raise hr_api.validate_enabled;

870: --
871: -- when in validation only mode raise the Validate_Enabled exception
872: --
873: if p_validate then
874: raise hr_api.validate_enabled;
875: end if;
876: --
877:
878: IF g_debug THEN

Line 883: when hr_api.validate_enabled then

879: hr_utility.set_location(' Leaving:'||l_proc, 10);
880: END IF;
881:
882: exception
883: when hr_api.validate_enabled then
884:
885: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
886: --
887: -- As the Validate_Enabled exception has been raised

Line 956: from hr_api_transaction_values hatv

952: l_proc constant varchar2(100) := g_package || ' update_transaction_step';
953: --
954: cursor csr_hatv is
955: select hatv.transaction_value_id
956: from hr_api_transaction_values hatv
957: where hatv.transaction_step_id = p_transaction_step_id;
958: --
959: begin
960: g_debug := hr_utility.debug_enabled;

Line 988: raise hr_api.validate_enabled;

984: --
985: -- when in validation only mode raise the Validate_Enabled exception
986: --
987: if p_validate then
988: raise hr_api.validate_enabled;
989: end if;
990: --
991:
992: IF g_debug THEN

Line 997: when hr_api.validate_enabled then

993: hr_utility.set_location(' Leaving:'||l_proc, 10);
994: END IF;
995:
996: exception
997: when hr_api.validate_enabled then
998: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
999: --
1000: -- As the Validate_Enabled exception has been raised
1001: -- we must rollback to the savepoint

Line 1040: delete from hr_api_transaction_values

1036: -- delete each transaction value
1037: -- Do this using direct SQL rather than in a loop using the row handler
1038: -- to improve performance.
1039: --
1040: delete from hr_api_transaction_values
1041: where transaction_step_id = p_transaction_step_id;
1042: -- delete the transaction step
1043: hr_trs_del.del
1044: (p_transaction_step_id => p_transaction_step_id

Line 1047: raise hr_api.validate_enabled;

1043: hr_trs_del.del
1044: (p_transaction_step_id => p_transaction_step_id
1045: ,p_object_version_number => p_object_version_number);
1046: if p_validate then
1047: raise hr_api.validate_enabled;
1048: end if;
1049: hr_utility.set_location('Leaving: '|| l_proc,10);
1050: exception
1051: when hr_api.validate_enabled then

Line 1051: when hr_api.validate_enabled then

1047: raise hr_api.validate_enabled;
1048: end if;
1049: hr_utility.set_location('Leaving: '|| l_proc,10);
1050: exception
1051: when hr_api.validate_enabled then
1052: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1053: --
1054: -- As the Validate_Enabled exception has been raised
1055: -- we must rollback to the savepoint

Line 1080: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;

1076: -- declare local variables
1077: -- --------------------------------------------------------------------------
1078: l_proc constant varchar2(100) := g_package || ' set_value';
1079: l_insert boolean := false;
1080: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1081: l_name hr_api_transaction_values.name%type;
1082: --
1083: l_current_value varchar2(2000); --ns
1084: l_original_value varchar2(2000);

Line 1081: l_name hr_api_transaction_values.name%type;

1077: -- --------------------------------------------------------------------------
1078: l_proc constant varchar2(100) := g_package || ' set_value';
1079: l_insert boolean := false;
1080: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1081: l_name hr_api_transaction_values.name%type;
1082: --
1083: l_current_value varchar2(2000); --ns
1084: l_original_value varchar2(2000);
1085: --

Line 1090: from hr_api_transaction_values hatv

1086: cursor csr_hatv is
1087: select hatv.transaction_value_id,
1088: varchar2_value || fnd_date.date_to_canonical(date_value) || number_value current_value, --ns
1089: original_varchar2_value || fnd_date.date_to_canonical(original_date_value) || original_number_value original_value
1090: from hr_api_transaction_values hatv
1091: where hatv.transaction_step_id = p_transaction_step_id
1092: and hatv.name = l_name;
1093: --
1094: begin

Line 1147: ,p_transaction_step_id => hr_api.g_number -- remove from RH API interface

1143: g_update_flag := 'Y';
1144: hr_trv_upd.upd
1145: (p_validate => false
1146: ,p_transaction_value_id => l_transaction_value_id
1147: ,p_transaction_step_id => hr_api.g_number -- remove from RH API interface
1148: ,p_datatype => hr_api.g_varchar2 -- remove from RH API interface
1149: ,p_name => hr_api.g_varchar2 -- remove from RH API interface
1150: ,p_varchar2_value => p_varchar2_value
1151: ,p_number_value => p_number_value

Line 1148: ,p_datatype => hr_api.g_varchar2 -- remove from RH API interface

1144: hr_trv_upd.upd
1145: (p_validate => false
1146: ,p_transaction_value_id => l_transaction_value_id
1147: ,p_transaction_step_id => hr_api.g_number -- remove from RH API interface
1148: ,p_datatype => hr_api.g_varchar2 -- remove from RH API interface
1149: ,p_name => hr_api.g_varchar2 -- remove from RH API interface
1150: ,p_varchar2_value => p_varchar2_value
1151: ,p_number_value => p_number_value
1152: ,p_date_value => p_date_value

Line 1149: ,p_name => hr_api.g_varchar2 -- remove from RH API interface

1145: (p_validate => false
1146: ,p_transaction_value_id => l_transaction_value_id
1147: ,p_transaction_step_id => hr_api.g_number -- remove from RH API interface
1148: ,p_datatype => hr_api.g_varchar2 -- remove from RH API interface
1149: ,p_name => hr_api.g_varchar2 -- remove from RH API interface
1150: ,p_varchar2_value => p_varchar2_value
1151: ,p_number_value => p_number_value
1152: ,p_date_value => p_date_value
1153: ,p_original_varchar2_value => p_original_varchar2_value -- remove from RH API interface --ns

Line 1162: raise hr_api.validate_enabled;

1158: --
1159: -- when in validation only mode raise the Validate_Enabled exception
1160: --
1161: if p_validate then
1162: raise hr_api.validate_enabled;
1163: end if;
1164: --
1165:
1166: IF g_debug THEN

Line 1171: when hr_api.validate_enabled then

1167: hr_utility.set_location(' Leaving:'||l_proc, 10);
1168: END IF;
1169:
1170: exception
1171: when hr_api.validate_enabled then
1172:
1173: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1174: --
1175: -- As the Validate_Enabled exception has been raised

Line 1196: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;

1192: -- --------------------------------------------------------------------------
1193: -- declare local variables
1194: -- --------------------------------------------------------------------------
1195: l_proc constant varchar2(100) := g_package || ' set_varchar2_value';
1196: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1197: --
1198: begin
1199: g_debug := hr_utility.debug_enabled;
1200:

Line 1237: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;

1233: -- --------------------------------------------------------------------------
1234: -- declare local variables
1235: -- --------------------------------------------------------------------------
1236: l_proc constant varchar2(100) := g_package || ' set_number_value';
1237: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1238: --
1239: begin
1240: g_debug := hr_utility.debug_enabled;
1241:

Line 1278: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;

1274: -- --------------------------------------------------------------------------
1275: -- declare local variables
1276: -- --------------------------------------------------------------------------
1277: l_proc constant varchar2(100) := g_package || ' set_date_value';
1278: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1279: --
1280: begin
1281: g_debug := hr_utility.debug_enabled;
1282:

Line 1319: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;

1315: -- --------------------------------------------------------------------------
1316: -- declare local variables
1317: -- --------------------------------------------------------------------------
1318: l_proc constant varchar2(100) := g_package || ' set_boolean_value';
1319: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1320: l_value varchar2(30);
1321: l_original_value varchar2(30); --ns
1322: --
1323: begin

Line 1381: l_name hr_api_transaction_values.name%type;

1377: -- declare local variables
1378: -- --------------------------------------------------------------------------
1379: l_proc constant varchar2(100) := g_package || ' get_value';
1380: l_insert boolean := false;
1381: l_name hr_api_transaction_values.name%type;
1382: --
1383: cursor csr_hatv is
1384: select hatv.datatype
1385: ,hatv.varchar2_value

Line 1388: from hr_api_transaction_values hatv

1384: select hatv.datatype
1385: ,hatv.varchar2_value
1386: ,hatv.number_value
1387: ,hatv.date_value
1388: from hr_api_transaction_values hatv
1389: where hatv.transaction_step_id = p_transaction_step_id
1390: and hatv.name = l_name;
1391: --
1392: begin

Line 1428: l_datatype hr_api_transaction_values.datatype%type;

1424: -- --------------------------------------------------------------------------
1425: -- declare local variables
1426: -- --------------------------------------------------------------------------
1427: l_proc constant varchar2(100) := g_package || ' get_varchar2_value';
1428: l_datatype hr_api_transaction_values.datatype%type;
1429: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1430: l_number hr_api_transaction_values.number_value%type;
1431: l_date hr_api_transaction_values.date_value%type;
1432: --

Line 1429: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1425: -- declare local variables
1426: -- --------------------------------------------------------------------------
1427: l_proc constant varchar2(100) := g_package || ' get_varchar2_value';
1428: l_datatype hr_api_transaction_values.datatype%type;
1429: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1430: l_number hr_api_transaction_values.number_value%type;
1431: l_date hr_api_transaction_values.date_value%type;
1432: --
1433: begin

Line 1430: l_number hr_api_transaction_values.number_value%type;

1426: -- --------------------------------------------------------------------------
1427: l_proc constant varchar2(100) := g_package || ' get_varchar2_value';
1428: l_datatype hr_api_transaction_values.datatype%type;
1429: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1430: l_number hr_api_transaction_values.number_value%type;
1431: l_date hr_api_transaction_values.date_value%type;
1432: --
1433: begin
1434: g_debug := hr_utility.debug_enabled;

Line 1431: l_date hr_api_transaction_values.date_value%type;

1427: l_proc constant varchar2(100) := g_package || ' get_varchar2_value';
1428: l_datatype hr_api_transaction_values.datatype%type;
1429: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1430: l_number hr_api_transaction_values.number_value%type;
1431: l_date hr_api_transaction_values.date_value%type;
1432: --
1433: begin
1434: g_debug := hr_utility.debug_enabled;
1435:

Line 1467: l_datatype hr_api_transaction_values.datatype%type;

1463: -- --------------------------------------------------------------------------
1464: -- declare local variables
1465: -- --------------------------------------------------------------------------
1466: l_proc constant varchar2(100) := g_package || ' get_number_value';
1467: l_datatype hr_api_transaction_values.datatype%type;
1468: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1469: l_number hr_api_transaction_values.number_value%type;
1470: l_date hr_api_transaction_values.date_value%type;
1471: --

Line 1468: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1464: -- declare local variables
1465: -- --------------------------------------------------------------------------
1466: l_proc constant varchar2(100) := g_package || ' get_number_value';
1467: l_datatype hr_api_transaction_values.datatype%type;
1468: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1469: l_number hr_api_transaction_values.number_value%type;
1470: l_date hr_api_transaction_values.date_value%type;
1471: --
1472: begin

Line 1469: l_number hr_api_transaction_values.number_value%type;

1465: -- --------------------------------------------------------------------------
1466: l_proc constant varchar2(100) := g_package || ' get_number_value';
1467: l_datatype hr_api_transaction_values.datatype%type;
1468: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1469: l_number hr_api_transaction_values.number_value%type;
1470: l_date hr_api_transaction_values.date_value%type;
1471: --
1472: begin
1473: g_debug := hr_utility.debug_enabled;

Line 1470: l_date hr_api_transaction_values.date_value%type;

1466: l_proc constant varchar2(100) := g_package || ' get_number_value';
1467: l_datatype hr_api_transaction_values.datatype%type;
1468: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1469: l_number hr_api_transaction_values.number_value%type;
1470: l_date hr_api_transaction_values.date_value%type;
1471: --
1472: begin
1473: g_debug := hr_utility.debug_enabled;
1474:

Line 1508: l_datatype hr_api_transaction_values.datatype%type;

1504: -- --------------------------------------------------------------------------
1505: -- declare local variables
1506: -- --------------------------------------------------------------------------
1507: l_proc constant varchar2(100) := g_package || ' get_date_value';
1508: l_datatype hr_api_transaction_values.datatype%type;
1509: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1510: l_number hr_api_transaction_values.number_value%type;
1511: l_date hr_api_transaction_values.date_value%type;
1512: --

Line 1509: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1505: -- declare local variables
1506: -- --------------------------------------------------------------------------
1507: l_proc constant varchar2(100) := g_package || ' get_date_value';
1508: l_datatype hr_api_transaction_values.datatype%type;
1509: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1510: l_number hr_api_transaction_values.number_value%type;
1511: l_date hr_api_transaction_values.date_value%type;
1512: --
1513: begin

Line 1510: l_number hr_api_transaction_values.number_value%type;

1506: -- --------------------------------------------------------------------------
1507: l_proc constant varchar2(100) := g_package || ' get_date_value';
1508: l_datatype hr_api_transaction_values.datatype%type;
1509: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1510: l_number hr_api_transaction_values.number_value%type;
1511: l_date hr_api_transaction_values.date_value%type;
1512: --
1513: begin
1514: g_debug := hr_utility.debug_enabled;

Line 1511: l_date hr_api_transaction_values.date_value%type;

1507: l_proc constant varchar2(100) := g_package || ' get_date_value';
1508: l_datatype hr_api_transaction_values.datatype%type;
1509: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1510: l_number hr_api_transaction_values.number_value%type;
1511: l_date hr_api_transaction_values.date_value%type;
1512: --
1513: begin
1514: g_debug := hr_utility.debug_enabled;
1515:

Line 1550: l_datatype hr_api_transaction_values.datatype%type;

1546: -- --------------------------------------------------------------------------
1547: -- declare local variables
1548: -- --------------------------------------------------------------------------
1549: l_proc constant varchar2(100) := g_package || ' get_date2char_value';
1550: l_datatype hr_api_transaction_values.datatype%type;
1551: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1552: l_number hr_api_transaction_values.number_value%type;
1553: l_date hr_api_transaction_values.date_value%type;
1554: l_char_date varchar2(200);

Line 1551: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1547: -- declare local variables
1548: -- --------------------------------------------------------------------------
1549: l_proc constant varchar2(100) := g_package || ' get_date2char_value';
1550: l_datatype hr_api_transaction_values.datatype%type;
1551: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1552: l_number hr_api_transaction_values.number_value%type;
1553: l_date hr_api_transaction_values.date_value%type;
1554: l_char_date varchar2(200);
1555: --

Line 1552: l_number hr_api_transaction_values.number_value%type;

1548: -- --------------------------------------------------------------------------
1549: l_proc constant varchar2(100) := g_package || ' get_date2char_value';
1550: l_datatype hr_api_transaction_values.datatype%type;
1551: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1552: l_number hr_api_transaction_values.number_value%type;
1553: l_date hr_api_transaction_values.date_value%type;
1554: l_char_date varchar2(200);
1555: --
1556: begin

Line 1553: l_date hr_api_transaction_values.date_value%type;

1549: l_proc constant varchar2(100) := g_package || ' get_date2char_value';
1550: l_datatype hr_api_transaction_values.datatype%type;
1551: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1552: l_number hr_api_transaction_values.number_value%type;
1553: l_date hr_api_transaction_values.date_value%type;
1554: l_char_date varchar2(200);
1555: --
1556: begin
1557: g_debug := hr_utility.debug_enabled;

Line 1596: l_datatype hr_api_transaction_values.datatype%type;

1592: -- --------------------------------------------------------------------------
1593: -- declare local variables
1594: -- --------------------------------------------------------------------------
1595: l_proc constant varchar2(100) := g_package || ' get_boolean_value';
1596: l_datatype hr_api_transaction_values.datatype%type;
1597: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1598: l_number hr_api_transaction_values.number_value%type;
1599: l_date hr_api_transaction_values.date_value%type;
1600: l_boolean boolean;

Line 1597: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1593: -- declare local variables
1594: -- --------------------------------------------------------------------------
1595: l_proc constant varchar2(100) := g_package || ' get_boolean_value';
1596: l_datatype hr_api_transaction_values.datatype%type;
1597: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1598: l_number hr_api_transaction_values.number_value%type;
1599: l_date hr_api_transaction_values.date_value%type;
1600: l_boolean boolean;
1601: --

Line 1598: l_number hr_api_transaction_values.number_value%type;

1594: -- --------------------------------------------------------------------------
1595: l_proc constant varchar2(100) := g_package || ' get_boolean_value';
1596: l_datatype hr_api_transaction_values.datatype%type;
1597: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1598: l_number hr_api_transaction_values.number_value%type;
1599: l_date hr_api_transaction_values.date_value%type;
1600: l_boolean boolean;
1601: --
1602: begin

Line 1599: l_date hr_api_transaction_values.date_value%type;

1595: l_proc constant varchar2(100) := g_package || ' get_boolean_value';
1596: l_datatype hr_api_transaction_values.datatype%type;
1597: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1598: l_number hr_api_transaction_values.number_value%type;
1599: l_date hr_api_transaction_values.date_value%type;
1600: l_boolean boolean;
1601: --
1602: begin
1603: g_debug := hr_utility.debug_enabled;

Line 1648: l_name hr_api_transaction_values.name%type;

1644: -- declare local variables
1645: -- --------------------------------------------------------------------------
1646: l_proc constant varchar2(100) := g_package || ' get_original_value';
1647: l_insert boolean := false;
1648: l_name hr_api_transaction_values.name%type;
1649: --
1650: cursor csr_hatv is
1651: select hatv.datatype
1652: ,hatv.original_varchar2_value

Line 1655: from hr_api_transaction_values hatv

1651: select hatv.datatype
1652: ,hatv.original_varchar2_value
1653: ,hatv.original_number_value
1654: ,hatv.original_date_value
1655: from hr_api_transaction_values hatv
1656: where hatv.transaction_step_id = p_transaction_step_id
1657: and hatv.name = l_name;
1658: --
1659: begin

Line 1701: l_datatype hr_api_transaction_values.datatype%type;

1697: -- --------------------------------------------------------------------------
1698: -- declare local variables
1699: -- --------------------------------------------------------------------------
1700: l_proc constant varchar2(100) := g_package || ' get_original_varchar2_value';
1701: l_datatype hr_api_transaction_values.datatype%type;
1702: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1703: l_number hr_api_transaction_values.number_value%type;
1704: l_date hr_api_transaction_values.date_value%type;
1705: --

Line 1702: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1698: -- declare local variables
1699: -- --------------------------------------------------------------------------
1700: l_proc constant varchar2(100) := g_package || ' get_original_varchar2_value';
1701: l_datatype hr_api_transaction_values.datatype%type;
1702: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1703: l_number hr_api_transaction_values.number_value%type;
1704: l_date hr_api_transaction_values.date_value%type;
1705: --
1706: begin

Line 1703: l_number hr_api_transaction_values.number_value%type;

1699: -- --------------------------------------------------------------------------
1700: l_proc constant varchar2(100) := g_package || ' get_original_varchar2_value';
1701: l_datatype hr_api_transaction_values.datatype%type;
1702: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1703: l_number hr_api_transaction_values.number_value%type;
1704: l_date hr_api_transaction_values.date_value%type;
1705: --
1706: begin
1707: g_debug := hr_utility.debug_enabled;

Line 1704: l_date hr_api_transaction_values.date_value%type;

1700: l_proc constant varchar2(100) := g_package || ' get_original_varchar2_value';
1701: l_datatype hr_api_transaction_values.datatype%type;
1702: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1703: l_number hr_api_transaction_values.number_value%type;
1704: l_date hr_api_transaction_values.date_value%type;
1705: --
1706: begin
1707: g_debug := hr_utility.debug_enabled;
1708:

Line 1740: l_datatype hr_api_transaction_values.datatype%type;

1736: -- --------------------------------------------------------------------------
1737: -- declare local variables
1738: -- --------------------------------------------------------------------------
1739: l_proc constant varchar2(100) := g_package || ' get_original_number_value';
1740: l_datatype hr_api_transaction_values.datatype%type;
1741: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1742: l_number hr_api_transaction_values.number_value%type;
1743: l_date hr_api_transaction_values.date_value%type;
1744: --

Line 1741: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1737: -- declare local variables
1738: -- --------------------------------------------------------------------------
1739: l_proc constant varchar2(100) := g_package || ' get_original_number_value';
1740: l_datatype hr_api_transaction_values.datatype%type;
1741: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1742: l_number hr_api_transaction_values.number_value%type;
1743: l_date hr_api_transaction_values.date_value%type;
1744: --
1745: begin

Line 1742: l_number hr_api_transaction_values.number_value%type;

1738: -- --------------------------------------------------------------------------
1739: l_proc constant varchar2(100) := g_package || ' get_original_number_value';
1740: l_datatype hr_api_transaction_values.datatype%type;
1741: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1742: l_number hr_api_transaction_values.number_value%type;
1743: l_date hr_api_transaction_values.date_value%type;
1744: --
1745: begin
1746: g_debug := hr_utility.debug_enabled;

Line 1743: l_date hr_api_transaction_values.date_value%type;

1739: l_proc constant varchar2(100) := g_package || ' get_original_number_value';
1740: l_datatype hr_api_transaction_values.datatype%type;
1741: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1742: l_number hr_api_transaction_values.number_value%type;
1743: l_date hr_api_transaction_values.date_value%type;
1744: --
1745: begin
1746: g_debug := hr_utility.debug_enabled;
1747:

Line 1779: l_datatype hr_api_transaction_values.datatype%type;

1775: -- --------------------------------------------------------------------------
1776: -- declare local variables
1777: -- --------------------------------------------------------------------------
1778: l_proc constant varchar2(100) := g_package || ' get_original_date_value';
1779: l_datatype hr_api_transaction_values.datatype%type;
1780: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1781: l_number hr_api_transaction_values.number_value%type;
1782: l_date hr_api_transaction_values.date_value%type;
1783: --

Line 1780: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1776: -- declare local variables
1777: -- --------------------------------------------------------------------------
1778: l_proc constant varchar2(100) := g_package || ' get_original_date_value';
1779: l_datatype hr_api_transaction_values.datatype%type;
1780: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1781: l_number hr_api_transaction_values.number_value%type;
1782: l_date hr_api_transaction_values.date_value%type;
1783: --
1784: begin

Line 1781: l_number hr_api_transaction_values.number_value%type;

1777: -- --------------------------------------------------------------------------
1778: l_proc constant varchar2(100) := g_package || ' get_original_date_value';
1779: l_datatype hr_api_transaction_values.datatype%type;
1780: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1781: l_number hr_api_transaction_values.number_value%type;
1782: l_date hr_api_transaction_values.date_value%type;
1783: --
1784: begin
1785: g_debug := hr_utility.debug_enabled;

Line 1782: l_date hr_api_transaction_values.date_value%type;

1778: l_proc constant varchar2(100) := g_package || ' get_original_date_value';
1779: l_datatype hr_api_transaction_values.datatype%type;
1780: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1781: l_number hr_api_transaction_values.number_value%type;
1782: l_date hr_api_transaction_values.date_value%type;
1783: --
1784: begin
1785: g_debug := hr_utility.debug_enabled;
1786:

Line 1818: l_datatype hr_api_transaction_values.datatype%type;

1814: -- --------------------------------------------------------------------------
1815: -- declare local variables
1816: -- --------------------------------------------------------------------------
1817: l_proc constant varchar2(100) := g_package || ' get_original_boolean_value';
1818: l_datatype hr_api_transaction_values.datatype%type;
1819: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1820: l_number hr_api_transaction_values.number_value%type;
1821: l_date hr_api_transaction_values.date_value%type;
1822: l_boolean boolean;

Line 1819: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1815: -- declare local variables
1816: -- --------------------------------------------------------------------------
1817: l_proc constant varchar2(100) := g_package || ' get_original_boolean_value';
1818: l_datatype hr_api_transaction_values.datatype%type;
1819: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1820: l_number hr_api_transaction_values.number_value%type;
1821: l_date hr_api_transaction_values.date_value%type;
1822: l_boolean boolean;
1823: --

Line 1820: l_number hr_api_transaction_values.number_value%type;

1816: -- --------------------------------------------------------------------------
1817: l_proc constant varchar2(100) := g_package || ' get_original_boolean_value';
1818: l_datatype hr_api_transaction_values.datatype%type;
1819: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1820: l_number hr_api_transaction_values.number_value%type;
1821: l_date hr_api_transaction_values.date_value%type;
1822: l_boolean boolean;
1823: --
1824: begin

Line 1821: l_date hr_api_transaction_values.date_value%type;

1817: l_proc constant varchar2(100) := g_package || ' get_original_boolean_value';
1818: l_datatype hr_api_transaction_values.datatype%type;
1819: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1820: l_number hr_api_transaction_values.number_value%type;
1821: l_date hr_api_transaction_values.date_value%type;
1822: l_boolean boolean;
1823: --
1824: begin
1825: g_debug := hr_utility.debug_enabled;

Line 1893: from hr_api_transaction_values trv

1889: ,p_validate in boolean default false) is
1890: -- cursor to select all transaction values for a transaction
1891: cursor csr_trv(c_transaction_step_id number) is
1892: select trv.transaction_value_id
1893: from hr_api_transaction_values trv
1894: where trv.transaction_step_id = c_transaction_step_id;
1895: -- cursor to select all transaction steps for a transaction
1896: cursor csr_trs is
1897: select trs.transaction_step_id

Line 1899: from hr_api_transaction_steps trs

1895: -- cursor to select all transaction steps for a transaction
1896: cursor csr_trs is
1897: select trs.transaction_step_id
1898: ,trs.object_version_number
1899: from hr_api_transaction_steps trs
1900: where trs.transaction_id = p_transaction_id;
1901: --
1902: cursor csr_hist is
1903: select action

Line 1975: raise hr_api.validate_enabled;

1971: delete from ben_icd_transaction where transaction_id = p_transaction_id and status <> 'SP';
1972: -- when in validation only mode raise the Validate_Enabled exception
1973: --
1974: if p_validate then
1975: raise hr_api.validate_enabled;
1976: end if;
1977: --
1978: exception
1979: when hr_api.validate_enabled then

Line 1979: when hr_api.validate_enabled then

1975: raise hr_api.validate_enabled;
1976: end if;
1977: --
1978: exception
1979: when hr_api.validate_enabled then
1980: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1981: --
1982: -- As the Validate_Enabled exception has been raised
1983: -- we must rollback to the savepoint