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 815: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

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

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

Line 889: ln_api_name hr_api_transaction_steps.api_name%type;

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

Line 900: from hr_api_transaction_steps

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

Line 901: where hr_api_transaction_steps.transaction_step_id=p_transaction_step_id;

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

Line 1014: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 1111: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 1161: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 1210: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 1263: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 1421: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

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

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

Line 1456: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 1504: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 1591: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 1643: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 1770: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 1861: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 1871: from hr_api_transaction_steps

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

Line 1872: where hr_api_transaction_steps.transaction_id=p_transaction_id

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

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

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

Line 1899: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 1937: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 1947: from hr_api_transaction_steps

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

Line 1948: where hr_api_transaction_steps.transaction_id=p_transaction_id

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

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

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

Line 1975: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 2011: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 2021: from hr_api_transaction_steps

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

Line 2022: where hr_api_transaction_steps.transaction_id=p_transaction_id

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

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

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

Line 2052: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 2089: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 2099: from hr_api_transaction_steps

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

Line 2100: where hr_api_transaction_steps.transaction_id=p_transaction_id

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

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

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

Line 2127: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 2163: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 2202: ln_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 2214: l_asg_txn_step_id hr_api_transaction_steps.transaction_step_id%type

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