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_AMEUTIL_SS dependencies on HR_API_TRANSACTION_STEPS

Line 36: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);

32: exception
33: when no_data_found then
34: -- get the data from the steps
35: if g_debug then
36: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);
37: end if;
38: select ts.item_type
39: into get_item_type.c_item_type
40: from hr_api_transaction_steps ts

Line 40: from hr_api_transaction_steps ts

36: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);
37: end if;
38: select ts.item_type
39: into get_item_type.c_item_type
40: from hr_api_transaction_steps ts
41: where ts.transaction_id=get_item_type.p_transaction_id
42: and ts.item_type is not null and rownum <=1;
43: end;
44:

Line 79: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);

75: exception
76: when no_data_found then
77: -- get the data from the steps
78: if g_debug then
79: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);
80: end if;
81: select ts.item_key
82: into get_item_key.c_item_key
83: from hr_api_transaction_steps ts

Line 83: from hr_api_transaction_steps ts

79: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);
80: end if;
81: select ts.item_key
82: into get_item_key.c_item_key
83: from hr_api_transaction_steps ts
84: where ts.transaction_id=get_item_key.p_transaction_id
85: and ts.item_type is not null and rownum <=1;
86: end;
87:

Line 128: p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%TYPE)

124: -- Params: transaction_step_id
125: -- Returns: varchar2
126: ------------------------------------------------------------------
127: function get_transaction_category (
128: p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%TYPE)
129: return varchar2 is
130:
131: -- local variables
132: lv_procedure_name constant varchar2(24) := 'get_transaction_category';

Line 189: from hr_api_transaction_steps hats

185: 'PQH_PROCESS_EMP_REVIEW.PROCESS_API',l_category_undefined,
186: 'PQH_PROCESS_TENURE_STATUS.PROCESS_API',l_category_undefined,
187: l_category_undefined)
188: into l_transaction_category
189: from hr_api_transaction_steps hats
190: where hats.transaction_step_id = p_transaction_step_id;
191:
192: END;
193:

Line 361: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

357: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
358: return number is
359: -- local variables
360: lv_procedure_name constant varchar2(19) := 'get_payrate_step_id';
361: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
362: BEGIN
363: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
364: if(hr_utility.debug_enabled) then
365: -- write debug statements

Line 371: from hr_api_transaction_steps

367: end if;
368: begin
369: select transaction_step_id
370: into ln_step_id
371: from hr_api_transaction_steps
372: where hr_api_transaction_steps.transaction_id=p_transaction_id
373: -- and hr_api_transaction_steps.api_name='HR_PAY_RATE_SS.PROCESS_API';
374: and hr_api_transaction_steps.api_name in ('PER_SSHR_CHANGE_PAY.PROCESS_API', 'HR_PAY_RATE_SS.PROCESS_API');
375: exception

Line 372: where hr_api_transaction_steps.transaction_id=p_transaction_id

368: begin
369: select transaction_step_id
370: into ln_step_id
371: from hr_api_transaction_steps
372: where hr_api_transaction_steps.transaction_id=p_transaction_id
373: -- and hr_api_transaction_steps.api_name='HR_PAY_RATE_SS.PROCESS_API';
374: and hr_api_transaction_steps.api_name in ('PER_SSHR_CHANGE_PAY.PROCESS_API', 'HR_PAY_RATE_SS.PROCESS_API');
375: exception
376: when no_data_found then

Line 373: -- and hr_api_transaction_steps.api_name='HR_PAY_RATE_SS.PROCESS_API';

369: select transaction_step_id
370: into ln_step_id
371: from hr_api_transaction_steps
372: where hr_api_transaction_steps.transaction_id=p_transaction_id
373: -- and hr_api_transaction_steps.api_name='HR_PAY_RATE_SS.PROCESS_API';
374: and hr_api_transaction_steps.api_name in ('PER_SSHR_CHANGE_PAY.PROCESS_API', 'HR_PAY_RATE_SS.PROCESS_API');
375: exception
376: when no_data_found then
377: return null;

Line 374: and hr_api_transaction_steps.api_name in ('PER_SSHR_CHANGE_PAY.PROCESS_API', 'HR_PAY_RATE_SS.PROCESS_API');

370: into ln_step_id
371: from hr_api_transaction_steps
372: where hr_api_transaction_steps.transaction_id=p_transaction_id
373: -- and hr_api_transaction_steps.api_name='HR_PAY_RATE_SS.PROCESS_API';
374: and hr_api_transaction_steps.api_name in ('PER_SSHR_CHANGE_PAY.PROCESS_API', 'HR_PAY_RATE_SS.PROCESS_API');
375: exception
376: when no_data_found then
377: return null;
378: when others then

Line 400: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

396: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
397: return number is
398: -- local variables
399: lv_procedure_name constant varchar2(22) := 'get_assignment_step_id';
400: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
401: BEGIN
402: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
403: if(hr_utility.debug_enabled) then
404: -- write debug statements

Line 410: from hr_api_transaction_steps

406: end if;
407: begin
408: select transaction_step_id
409: into ln_step_id
410: from hr_api_transaction_steps
411: where hr_api_transaction_steps.transaction_id=p_transaction_id
412: and hr_api_transaction_steps.api_name='HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
413: return ln_step_id;
414: exception

Line 411: where hr_api_transaction_steps.transaction_id=p_transaction_id

407: begin
408: select transaction_step_id
409: into ln_step_id
410: from hr_api_transaction_steps
411: where hr_api_transaction_steps.transaction_id=p_transaction_id
412: and hr_api_transaction_steps.api_name='HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
413: return ln_step_id;
414: exception
415: when no_data_found then

Line 412: and hr_api_transaction_steps.api_name='HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';

408: select transaction_step_id
409: into ln_step_id
410: from hr_api_transaction_steps
411: where hr_api_transaction_steps.transaction_id=p_transaction_id
412: and hr_api_transaction_steps.api_name='HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
413: return ln_step_id;
414: exception
415: when no_data_found then
416: return null;

Line 440: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

436: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
437: return number is
438: -- local variables
439: lv_procedure_name constant varchar2(27) := 'get_supeversior_Chg_step_id';
440: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
441: BEGIN
442: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
443: if(hr_utility.debug_enabled) then
444: -- write debug statements

Line 450: from hr_api_transaction_steps

446: end if;
447: begin
448: select transaction_step_id
449: into ln_step_id
450: from hr_api_transaction_steps
451: where hr_api_transaction_steps.transaction_id=p_transaction_id
452: and hr_api_transaction_steps.api_name='HR_SUPERVISOR_SS.PROCESS_API';
453: exception
454: when no_data_found then

Line 451: where hr_api_transaction_steps.transaction_id=p_transaction_id

447: begin
448: select transaction_step_id
449: into ln_step_id
450: from hr_api_transaction_steps
451: where hr_api_transaction_steps.transaction_id=p_transaction_id
452: and hr_api_transaction_steps.api_name='HR_SUPERVISOR_SS.PROCESS_API';
453: exception
454: when no_data_found then
455: return null;

Line 452: and hr_api_transaction_steps.api_name='HR_SUPERVISOR_SS.PROCESS_API';

448: select transaction_step_id
449: into ln_step_id
450: from hr_api_transaction_steps
451: where hr_api_transaction_steps.transaction_id=p_transaction_id
452: and hr_api_transaction_steps.api_name='HR_SUPERVISOR_SS.PROCESS_API';
453: exception
454: when no_data_found then
455: return null;
456: when others then

Line 478: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

474: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
475: return number is
476: -- local variables
477: lv_procedure_name constant varchar2(15) default 'get_loa_step_id';
478: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
479: BEGIN
480: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
481: if(hr_utility.debug_enabled) then
482: -- write debug statements

Line 488: from hr_api_transaction_steps

484: end if;
485: begin
486: select transaction_step_id
487: into ln_step_id
488: from hr_api_transaction_steps
489: where hr_api_transaction_steps.transaction_id=p_transaction_id
490: and hr_api_transaction_steps.api_name='HR_PERSON_ABSENCE_SWI.PROCESS_API';
491: exception
492: when no_data_found then

Line 489: where hr_api_transaction_steps.transaction_id=p_transaction_id

485: begin
486: select transaction_step_id
487: into ln_step_id
488: from hr_api_transaction_steps
489: where hr_api_transaction_steps.transaction_id=p_transaction_id
490: and hr_api_transaction_steps.api_name='HR_PERSON_ABSENCE_SWI.PROCESS_API';
491: exception
492: when no_data_found then
493: return null;

Line 490: and hr_api_transaction_steps.api_name='HR_PERSON_ABSENCE_SWI.PROCESS_API';

486: select transaction_step_id
487: into ln_step_id
488: from hr_api_transaction_steps
489: where hr_api_transaction_steps.transaction_id=p_transaction_id
490: and hr_api_transaction_steps.api_name='HR_PERSON_ABSENCE_SWI.PROCESS_API';
491: exception
492: when no_data_found then
493: return null;
494: when others then

Line 516: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

512: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
513: return number is
514: -- local variables
515: lv_procedure_name constant varchar2(23) := 'get_termination_step_id';
516: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
517: BEGIN
518: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
519: if(hr_utility.debug_enabled) then
520: -- write debug statements

Line 526: from hr_api_transaction_steps

522: end if;
523: begin
524: select transaction_step_id
525: into ln_step_id
526: from hr_api_transaction_steps
527: where hr_api_transaction_steps.transaction_id=p_transaction_id
528: and hr_api_transaction_steps.api_name='HR_TERMINATION_SS.PROCESS_API';
529: exception
530: when no_data_found then

Line 527: where hr_api_transaction_steps.transaction_id=p_transaction_id

523: begin
524: select transaction_step_id
525: into ln_step_id
526: from hr_api_transaction_steps
527: where hr_api_transaction_steps.transaction_id=p_transaction_id
528: and hr_api_transaction_steps.api_name='HR_TERMINATION_SS.PROCESS_API';
529: exception
530: when no_data_found then
531: return null;

Line 528: and hr_api_transaction_steps.api_name='HR_TERMINATION_SS.PROCESS_API';

524: select transaction_step_id
525: into ln_step_id
526: from hr_api_transaction_steps
527: where hr_api_transaction_steps.transaction_id=p_transaction_id
528: and hr_api_transaction_steps.api_name='HR_TERMINATION_SS.PROCESS_API';
529: exception
530: when no_data_found then
531: return null;
532: when others then

Line 553: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

549: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
550: return varchar2 is
551: -- local variables
552: lv_procedure_name constant varchar2(11) := 'isChangePay';
553: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
554: lv_status varchar2(10);
555: BEGIN
556: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
557: if(hr_utility.debug_enabled) then

Line 589: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

585: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
586: return varchar2 is
587: -- local variables
588: lv_procedure_name constant varchar2(18) := 'isAssignmentChange';
589: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
590: lv_status varchar2(10);
591: BEGIN
592: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
593: if(hr_utility.debug_enabled) then

Line 624: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

620: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
621: return varchar2 is
622: -- local variables
623: lv_procedure_name constant varchar2(18) := 'isSupervisorChange';
624: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
625: lv_status varchar2(10);
626: BEGIN
627: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
628: if(hr_utility.debug_enabled) then

Line 661: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

657: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
658: return varchar2 is
659: -- local variables
660: lv_procedure_name constant varchar2(11) := 'isLOAChange';
661: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
662: lv_status varchar2(10);
663: BEGIN
664: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
665: if(hr_utility.debug_enabled) then

Line 698: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

694: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
695: return varchar2 is
696: -- local variables
697: lv_procedure_name constant varchar2(18) := 'isAssignmentChange';
698: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
699: lv_status varchar2(10);
700: BEGIN
701: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
702: if(hr_utility.debug_enabled) then

Line 734: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

730: return number is
731: -- local variables
732: lv_procedure_name constant varchar2(25) := 'get_salary_percent_change';
733: ln_salary_percent_change number default null;
734: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
735: ln_no_of_components NUMBER ;
736: lv_param_name hr_api_transaction_values.varchar2_value%type;
737: p_sum_percentage per_pay_transactions.change_percentage%type;
738: BEGIN

Line 816: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

812: return varchar2 is
813: -- local variables
814: lv_procedure_name constant varchar2(24) := 'get_salary_amount_change';
815: ln_salary_amt_change number default null;
816: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
817: ln_no_of_components NUMBER ;
818: lv_param_name hr_api_transaction_values.varchar2_value%type;
819: p_sum_amount per_pay_transactions.change_amount_n%type;
820: BEGIN

Line 887: FUNCTION is_new_change_pay(p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%TYPE)

883: END get_salary_amount_change;
884:
885: --function added by schowdhu Bug#6919576
886:
887: FUNCTION is_new_change_pay(p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%TYPE)
888: return varchar2 is
889: -- local variables
890: lv_procedure_name constant varchar2(19) := 'is_new_change_pay';
891: ln_api_name hr_api_transaction_steps.api_name%type;

Line 891: ln_api_name hr_api_transaction_steps.api_name%type;

887: FUNCTION is_new_change_pay(p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%TYPE)
888: return varchar2 is
889: -- local variables
890: lv_procedure_name constant varchar2(19) := 'is_new_change_pay';
891: ln_api_name hr_api_transaction_steps.api_name%type;
892: lv_status varchar2(10);
893: BEGIN
894: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
895: if(hr_utility.debug_enabled) then

Line 902: from hr_api_transaction_steps

898: end if;
899: begin
900: select api_name
901: into ln_api_name
902: from hr_api_transaction_steps
903: where hr_api_transaction_steps.transaction_step_id=p_transaction_step_id;
904: exception
905: when no_data_found then
906: return null;

Line 903: where hr_api_transaction_steps.transaction_step_id=p_transaction_step_id;

899: begin
900: select api_name
901: into ln_api_name
902: from hr_api_transaction_steps
903: where hr_api_transaction_steps.transaction_step_id=p_transaction_step_id;
904: exception
905: when no_data_found then
906: return null;
907: when others then

Line 1016: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1012: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1013: return varchar2 is
1014: -- local variables
1015: lv_procedure_name constant varchar2(26) := 'get_sel_person_prop_sup_id';
1016: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1017: ln_sel_person_prop_sup_id varchar2(10);
1018: ln_new_sel_person_prop_sup_id number;
1019: ln_old_sel_person_prop_sup_id number;
1020:

Line 1113: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1109: return varchar2 is
1110: -- local variables
1111: lv_procedure_name constant varchar2(19) := 'get_proposed_job_id';
1112: lv_job_id varchar2(15);
1113: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1114: ln_new_job_id number;
1115: ln_orginal_job_id number;
1116: BEGIN
1117: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

Line 1163: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1159: return varchar2 is
1160: -- local variables
1161: lv_procedure_name constant varchar2(24) := 'get_proposed_position_id';
1162: lv_position_id varchar2(15);
1163: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1164: ln_new_position_id number;
1165: ln_orginal_position_id number;
1166: BEGIN
1167: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

Line 1212: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1208: return varchar2 is
1209: -- local variables
1210: lv_procedure_name constant varchar2(21) := 'get_proposed_grade_id';
1211: lv_grade_id varchar2(15);
1212: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1213:
1214: ln_new_id number;
1215: ln_orginal_id number;
1216:

Line 1265: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1261: return varchar2 is
1262: -- local variables
1263: lv_procedure_name constant varchar2(24) := 'get_proposed_location_id';
1264: lv_location_id varchar2(15);
1265: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1266: ln_new_id number;
1267: ln_orginal_id number;
1268: BEGIN
1269: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

Line 1423: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1419: return number is
1420: -- local variables
1421: lv_procedure_name constant varchar2(19) := 'get_absence_type_id';
1422: lv_absence_type_id number;
1423: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1424: BEGIN
1425: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1426: if(hr_utility.debug_enabled) then
1427: -- write debug statements

Line 1433: select INFORMATION5 INTO lv_absence_type_id from hr_api_transaction_steps where transaction_step_id = ln_step_id;

1429: end if;
1430:
1431: ln_step_id := get_loa_step_id(p_transaction_id);
1432: if(ln_step_id is not null) then
1433: select INFORMATION5 INTO lv_absence_type_id from hr_api_transaction_steps where transaction_step_id = ln_step_id;
1434: else
1435: lv_absence_type_id:= null;
1436: end if;
1437:

Line 1458: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1454: -- local variables
1455: lv_procedure_name constant varchar2(23) := 'get_proposed_payroll_id';
1456:
1457: lv_payroll_id varchar2(15);
1458: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1459: ln_new_id number;
1460: ln_orginal_id number;
1461:
1462: BEGIN

Line 1506: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1502: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1503: return varchar2 is
1504: -- local variables
1505: lv_procedure_name constant varchar2(25) := 'get_proposed_salary_basis';
1506: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1507: lv_salary_basis VARCHAR2(30) default null;
1508: ln_pay_basis_id number;
1509: lv_item_type varchar2(50);
1510: lv_item_key varchar2(100);

Line 1593: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1589: return varchar2 is
1590: -- local variables
1591: lv_procedure_name constant varchar2(21) := 'get_asg_change_reason';
1592: lv_asg_change_reason VARCHAR2(30) default null;
1593: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1594: lv_new_value VARCHAR2(30);
1595: lv_orginal_value VARCHAR2(30);
1596:
1597: BEGIN

Line 1645: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1641: return varchar2 is
1642: -- local variables
1643: lv_procedure_name constant varchar2(18) := 'get_leaving_reason';
1644: lv_leaving_reason VARCHAR2(30) default null;
1645: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1646:
1647: BEGIN
1648: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1649: if(hr_utility.debug_enabled) then

Line 1772: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1768: return varchar2 is
1769: -- local variables
1770: lv_procedure_name constant varchar2(23) := 'get_assignment_category';
1771: lv_assignment_category VARCHAR2(30) default null;
1772: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1773: lv_new_value VARCHAR2(30);
1774: lv_orginal_value VARCHAR2(30);
1775: BEGIN
1776: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

Line 1863: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1859: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1860: return number is
1861: -- local variables
1862: lv_procedure_name constant varchar2(25) := 'get_basic_details_step_id';
1863: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1864: BEGIN
1865: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1866: if(hr_utility.debug_enabled) then
1867: -- write debug statements

Line 1873: from hr_api_transaction_steps

1869: end if;
1870: begin
1871: select transaction_step_id
1872: into ln_step_id
1873: from hr_api_transaction_steps
1874: where hr_api_transaction_steps.transaction_id=p_transaction_id
1875: and hr_api_transaction_steps.api_name='HR_PROCESS_PERSON_SS.PROCESS_API';
1876: exception
1877: when no_data_found then

Line 1874: where hr_api_transaction_steps.transaction_id=p_transaction_id

1870: begin
1871: select transaction_step_id
1872: into ln_step_id
1873: from hr_api_transaction_steps
1874: where hr_api_transaction_steps.transaction_id=p_transaction_id
1875: and hr_api_transaction_steps.api_name='HR_PROCESS_PERSON_SS.PROCESS_API';
1876: exception
1877: when no_data_found then
1878: return null;

Line 1875: and hr_api_transaction_steps.api_name='HR_PROCESS_PERSON_SS.PROCESS_API';

1871: select transaction_step_id
1872: into ln_step_id
1873: from hr_api_transaction_steps
1874: where hr_api_transaction_steps.transaction_id=p_transaction_id
1875: and hr_api_transaction_steps.api_name='HR_PROCESS_PERSON_SS.PROCESS_API';
1876: exception
1877: when no_data_found then
1878: return null;
1879: when others then

Line 1901: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1897: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1898: return varchar2 is
1899: -- local variables
1900: lv_procedure_name constant varchar2(21) := 'isPersonDetailsChange';
1901: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1902: lv_status varchar2(10);
1903: BEGIN
1904: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1905: if(hr_utility.debug_enabled) then

Line 1939: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1935: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1936: return number is
1937: -- local variables
1938: lv_procedure_name constant varchar2(26) := 'get_person_address_step_id';
1939: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1940: BEGIN
1941: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1942: if(hr_utility.debug_enabled) then
1943: -- write debug statements

Line 1949: from hr_api_transaction_steps

1945: end if;
1946: begin
1947: select transaction_step_id
1948: into ln_step_id
1949: from hr_api_transaction_steps
1950: where hr_api_transaction_steps.transaction_id=p_transaction_id
1951: and hr_api_transaction_steps.api_name='HR_PROCESS_ADDRESS_SS.PROCESS_API';
1952: exception
1953: when no_data_found then

Line 1950: where hr_api_transaction_steps.transaction_id=p_transaction_id

1946: begin
1947: select transaction_step_id
1948: into ln_step_id
1949: from hr_api_transaction_steps
1950: where hr_api_transaction_steps.transaction_id=p_transaction_id
1951: and hr_api_transaction_steps.api_name='HR_PROCESS_ADDRESS_SS.PROCESS_API';
1952: exception
1953: when no_data_found then
1954: return null;

Line 1951: and hr_api_transaction_steps.api_name='HR_PROCESS_ADDRESS_SS.PROCESS_API';

1947: select transaction_step_id
1948: into ln_step_id
1949: from hr_api_transaction_steps
1950: where hr_api_transaction_steps.transaction_id=p_transaction_id
1951: and hr_api_transaction_steps.api_name='HR_PROCESS_ADDRESS_SS.PROCESS_API';
1952: exception
1953: when no_data_found then
1954: return null;
1955: when others then

Line 1977: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

1973: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1974: return varchar2 is
1975: -- local variables
1976: lv_procedure_name constant varchar2(21) := 'isPersonAddressChange';
1977: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1978: lv_status varchar2(10);
1979: BEGIN
1980: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1981: if(hr_utility.debug_enabled) then

Line 2013: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

2009: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
2010: return number is
2011: -- local variables
2012: lv_procedure_name constant varchar2(30) := 'get_person_contact_step_id';
2013: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
2014: BEGIN
2015: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2016: if(hr_utility.debug_enabled) then
2017: -- write debug statements

Line 2023: from hr_api_transaction_steps

2019: end if;
2020: begin
2021: select transaction_step_id
2022: into ln_step_id
2023: from hr_api_transaction_steps
2024: where hr_api_transaction_steps.transaction_id=p_transaction_id
2025: and hr_api_transaction_steps.api_name in ('HR_PROCESS_CONTACT_SS.PROCESS_API',
2026: 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API')
2027: and rownum<2;

Line 2024: where hr_api_transaction_steps.transaction_id=p_transaction_id

2020: begin
2021: select transaction_step_id
2022: into ln_step_id
2023: from hr_api_transaction_steps
2024: where hr_api_transaction_steps.transaction_id=p_transaction_id
2025: and hr_api_transaction_steps.api_name in ('HR_PROCESS_CONTACT_SS.PROCESS_API',
2026: 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API')
2027: and rownum<2;
2028:

Line 2025: and hr_api_transaction_steps.api_name in ('HR_PROCESS_CONTACT_SS.PROCESS_API',

2021: select transaction_step_id
2022: into ln_step_id
2023: from hr_api_transaction_steps
2024: where hr_api_transaction_steps.transaction_id=p_transaction_id
2025: and hr_api_transaction_steps.api_name in ('HR_PROCESS_CONTACT_SS.PROCESS_API',
2026: 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API')
2027: and rownum<2;
2028:
2029: exception

Line 2054: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

2050: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
2051: return varchar2 is
2052: -- local variables
2053: lv_procedure_name constant varchar2(21) := 'isPersonAddressChange';
2054: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
2055: lv_status varchar2(10);
2056: BEGIN
2057: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2058: if(hr_utility.debug_enabled) then

Line 2091: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

2087: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
2088: return number is
2089: -- local variables
2090: lv_procedure_name constant varchar2(16) := 'get_caed_step_id';
2091: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
2092: BEGIN
2093: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2094: if(hr_utility.debug_enabled) then
2095: -- write debug statements

Line 2101: from hr_api_transaction_steps

2097: end if;
2098: begin
2099: select transaction_step_id
2100: into ln_step_id
2101: from hr_api_transaction_steps
2102: where hr_api_transaction_steps.transaction_id=p_transaction_id
2103: and hr_api_transaction_steps.api_name='HR_CAED_SS.PROCESS_API';
2104: exception
2105: when no_data_found then

Line 2102: where hr_api_transaction_steps.transaction_id=p_transaction_id

2098: begin
2099: select transaction_step_id
2100: into ln_step_id
2101: from hr_api_transaction_steps
2102: where hr_api_transaction_steps.transaction_id=p_transaction_id
2103: and hr_api_transaction_steps.api_name='HR_CAED_SS.PROCESS_API';
2104: exception
2105: when no_data_found then
2106: return null;

Line 2103: and hr_api_transaction_steps.api_name='HR_CAED_SS.PROCESS_API';

2099: select transaction_step_id
2100: into ln_step_id
2101: from hr_api_transaction_steps
2102: where hr_api_transaction_steps.transaction_id=p_transaction_id
2103: and hr_api_transaction_steps.api_name='HR_CAED_SS.PROCESS_API';
2104: exception
2105: when no_data_found then
2106: return null;
2107: when others then

Line 2129: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

2125: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
2126: return varchar2 is
2127: -- local variables
2128: lv_procedure_name constant varchar2(20) := 'isReleaseInformation';
2129: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
2130: lv_status varchar2(10);
2131: BEGIN
2132: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2133: if(hr_utility.debug_enabled) then

Line 2165: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

2161: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
2162: return number is
2163: -- local variables
2164: lv_procedure_name constant varchar2(25) := 'get_proposed_salary_basis';
2165: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
2166: lv_salary_basis VARCHAR2(30) default null;
2167: ln_pay_basis_id number;
2168: lv_item_type varchar2(50);
2169: lv_item_key varchar2(100);

Line 2204: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

2200: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
2201: return varchar2 is
2202: -- local variables
2203: lv_procedure_name constant varchar2(25) := 'isMidPayPayPeriodChange';
2204: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
2205: lv_status varchar2(10);
2206: result varchar2(50);
2207:
2208:

Line 2216: l_asg_txn_step_id hr_api_transaction_steps.transaction_step_id%type

2212: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
2213: l_pay_period_start_date date default null;
2214: l_pay_period_end_date date default null;
2215:
2216: l_asg_txn_step_id hr_api_transaction_steps.transaction_step_id%type
2217: default null;
2218: l_effective_date date default null;
2219:
2220: