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_TRANSACTIONS

Line 18: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

14:
15: ---------- private function to get item type for current transaction ---------
16: -------------------------------------------------------------------------------
17: function get_item_type
18: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
19: return varchar2 is
20: c_item_type varchar2(50);
21:
22: begin

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

22: begin
23:
24: begin
25: if g_debug then
26: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);
27: end if;
28: select t.item_type
29: into c_item_type
30: from hr_api_transactions t

Line 30: from hr_api_transactions t

26: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);
27: end if;
28: select t.item_type
29: into c_item_type
30: from hr_api_transactions t
31: where transaction_id=get_item_type.p_transaction_id;
32: exception
33: when no_data_found then
34: -- get the data from the steps

Line 61: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

57: ---------- private function to get item key for current transaction ---------
58: -------------------------------------------------------------------------------
59:
60: function get_item_key
61: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
62: return varchar2 is
63: c_item_key varchar2(50);
64:
65: begin

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

65: begin
66:
67: begin
68: if g_debug then
69: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);
70: end if;
71: select t.item_key
72: into get_item_key.c_item_key
73: from hr_api_transactions t

Line 73: from hr_api_transactions t

69: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);
70: end if;
71: select t.item_key
72: into get_item_key.c_item_key
73: from hr_api_transactions t
74: where transaction_id=get_item_key.p_transaction_id;
75: exception
76: when no_data_found then
77: -- get the data from the steps

Line 97: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

93:
94: end get_item_key;
95:
96: function get_process_name
97: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
98: return varchar2 is
99:
100: c_process_name varchar2(100);
101: c_item_type varchar2(50);

Line 111: from hr_api_transactions t

107: c_item_key := get_item_key(p_transaction_id);
108:
109: select t.process_name
110: into get_process_name.c_process_name
111: from hr_api_transactions t
112: where transaction_id=get_process_name.p_transaction_id;
113:
114: return c_process_name;
115: EXCEPTION

Line 206: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

202: raise;
203: end;
204:
205: Function isHrHelpDeskAgent
206: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
207: return varchar2 IS
208:
209: p_item_key hr_api_transactions.item_key%TYPE;
210: p_item_type hr_api_transactions.item_type%TYPE;

Line 209: p_item_key hr_api_transactions.item_key%TYPE;

205: Function isHrHelpDeskAgent
206: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
207: return varchar2 IS
208:
209: p_item_key hr_api_transactions.item_key%TYPE;
210: p_item_type hr_api_transactions.item_type%TYPE;
211: p_hrhd_val varchar2(1);
212:
213: Begin

Line 210: p_item_type hr_api_transactions.item_type%TYPE;

206: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
207: return varchar2 IS
208:
209: p_item_key hr_api_transactions.item_key%TYPE;
210: p_item_type hr_api_transactions.item_type%TYPE;
211: p_hrhd_val varchar2(1);
212:
213: Begin
214: p_item_type := get_item_type(p_transaction_id);

Line 232: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

228: End isHrHelpDeskAgent;
229:
230:
231: FUNCTION get_requestor_person_id
232: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
233: return number is
234: -- local variables
235: lv_procedure_name constant varchar2(23) := 'get_requestor_person_id';
236: ln_requestor_person_id number;

Line 237: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;

233: return number is
234: -- local variables
235: lv_procedure_name constant varchar2(23) := 'get_requestor_person_id';
236: ln_requestor_person_id number;
237: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
238: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
239:
240: p_hrhd varchar2(1);
241:

Line 238: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;

234: -- local variables
235: lv_procedure_name constant varchar2(23) := 'get_requestor_person_id';
236: ln_requestor_person_id number;
237: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
238: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
239:
240: p_hrhd varchar2(1);
241:
242: BEGIN

Line 253: -- get the selected person_id from hr_api_transactions

249: p_hrhd := isHrHelpDeskAgent(p_transaction_id);
250:
251: if p_hrhd = 'Y' then
252:
253: -- get the selected person_id from hr_api_transactions
254: -- this would be for HR helpdesk approvals.
255: begin
256: select selected_person_id
257: into ln_requestor_person_id

Line 258: from hr_api_transactions

254: -- this would be for HR helpdesk approvals.
255: begin
256: select selected_person_id
257: into ln_requestor_person_id
258: from hr_api_transactions
259: where transaction_id=p_transaction_id;
260: exception
261: when others then
262: raise;

Line 267: -- get the creator person_id from hr_api_transactions

263: end;
264:
265: else
266:
267: -- get the creator person_id from hr_api_transactions
268: -- this would be the default for all SSHR approvals.
269:
270: begin
271: select creator_person_id

Line 273: from hr_api_transactions

269:
270: begin
271: select creator_person_id
272: into ln_requestor_person_id
273: from hr_api_transactions
274: where transaction_id=p_transaction_id;
275: exception
276: when others then
277: raise;

Line 287: from hr_api_transactions

283: -- Main Appraiser chain for approvals.
284: begin
285: select transaction_ref_table,transaction_ref_id
286: into lv_transaction_ref_table,lv_transaction_ref_id
287: from hr_api_transactions
288: where transaction_id=p_transaction_id;
289:
290: if(lv_transaction_ref_table='PER_APPRAISALS') then
291: begin

Line 304: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'||

300: end;
301: end if;
302: exception
303: when others then
304: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'||
305: lv_transaction_ref_table||' : ' || sqlerrm);
306: -- just log the message no need to raise it
307: end;
308:

Line 324: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

320:
321: END get_requestor_person_id;
322:
323: function get_sel_person_assignment_id
324: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
325: return number is
326: c_assignment_id number;
327: c_item_type varchar2(50);
328: c_item_key varchar2(100);

Line 342: select assignment_id into c_assignment_id from hr_api_transactions

338: aname => 'CURRENT_ASSIGNMENT_ID',
339: ignore_notfound => true);
340:
341: else
342: select assignment_id into c_assignment_id from hr_api_transactions
343: where transaction_id = p_transaction_id;
344: end if;
345:
346: return fnd_number.number_to_canonical(c_assignment_id);

Line 357: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

353: end get_sel_person_assignment_id ;
354:
355:
356: FUNCTION get_payrate_step_id
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;

Line 396: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

392: END get_payrate_step_id;
393:
394:
395: FUNCTION get_assignment_step_id
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;

Line 436: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

432: END get_assignment_step_id;
433:
434:
435: FUNCTION get_supeversior_Chg_step_id
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;

Line 474: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

470: END get_supeversior_Chg_step_id;
471:
472:
473: FUNCTION get_loa_step_id
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;

Line 512: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

508: END get_loa_step_id;
509:
510:
511: FUNCTION get_termination_step_id
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;

Line 549: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

545:
546: END get_termination_step_id;
547:
548: FUNCTION isChangePay
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;

Line 585: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

581: END isChangePay;
582:
583:
584: FUNCTION isAssignmentChange
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;

Line 620: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

616: END isAssignmentChange;
617:
618:
619: FUNCTION isSupervisorChange
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;

Line 657: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

653:
654:
655:
656: FUNCTION isLOAChange
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;

Line 694: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

690:
691:
692:
693: FUNCTION isTermination
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;

Line 729: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

725: END isTermination;
726:
727:
728: FUNCTION get_salary_percent_change
729: (p_transaction_id IN hr_api_transactions.transaction_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;

Line 810: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

806: END get_salary_percent_change;
807:
808:
809: FUNCTION get_salary_amount_change
810: (p_transaction_id IN hr_api_transactions.transaction_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;

Line 926: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

922: RAISE;
923: END is_new_change_pay;
924:
925: FUNCTION get_transaction_init_date
926: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
927: return varchar2 is
928: -- local variables
929: lv_procedure_name constant varchar2(25) := 'get_transaction_init_date';
930: lv_creation_date_string varchar2(30) default null;

Line 940: from hr_api_transactions

936: end if;
937: begin
938: select ame_util.versiondatetostring(creation_date)
939: into lv_creation_date_string
940: from hr_api_transactions
941: where transaction_id=p_transaction_id;
942: exception
943: when others then
944: raise;

Line 963: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

959:
960:
961:
962: FUNCTION get_transaction_effective_date
963: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
964: return varchar2 is
965: -- local variables
966: lv_procedure_name constant varchar2(30) := 'get_transaction_effective_date';
967: lv_effective_date_string varchar2(30) default null;

Line 988: select transaction_effective_date into lv_effective_date_string from hr_api_transactions

984: aname => 'CURRENT_EFFECTIVE_DATE',
985: ignore_notfound => true));
986:
987: else
988: select transaction_effective_date into lv_effective_date_string from hr_api_transactions
989: where transaction_id = p_transaction_id;
990: end if;
991:
992: if(hr_utility.debug_enabled) then

Line 1010: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1006:
1007:
1008:
1009: FUNCTION get_sel_person_prop_sup_id
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;

Line 1062: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1058:
1059: END get_sel_person_prop_sup_id;
1060:
1061: FUNCTION get_selected_person_id
1062: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1063: return varchar2 is
1064: -- local variables
1065: lv_procedure_name constant varchar2(22) := 'get_selected_person_id';
1066: lv_selected_person_id varchar2(10);

Line 1087: select selected_person_id into lv_selected_person_id from hr_api_transactions

1083: aname => 'CURRENT_PERSON_ID',
1084: ignore_notfound => true);
1085:
1086: else
1087: select selected_person_id into lv_selected_person_id from hr_api_transactions
1088: where transaction_id = p_transaction_id;
1089: end if;
1090:
1091: if(hr_utility.debug_enabled) then

Line 1106: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1102:
1103: END get_selected_person_id;
1104:
1105: FUNCTION get_proposed_job_id
1106: (p_transaction_id IN hr_api_transactions.transaction_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);

Line 1156: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1152: END get_proposed_job_id;
1153:
1154:
1155: FUNCTION get_proposed_position_id
1156: (p_transaction_id IN hr_api_transactions.transaction_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);

Line 1205: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1201: END get_proposed_position_id;
1202:
1203:
1204: FUNCTION get_proposed_grade_id
1205: (p_transaction_id IN hr_api_transactions.transaction_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);

Line 1258: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1254:
1255: END get_proposed_grade_id;
1256:
1257: FUNCTION get_proposed_location_id
1258: (p_transaction_id IN hr_api_transactions.transaction_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);

Line 1305: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1301:
1302: END get_proposed_location_id;
1303:
1304: FUNCTION get_appraisal_type
1305: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1306: return varchar2 is
1307: -- local variables
1308: lv_procedure_name constant varchar2(18) := 'get_appraisal_type';
1309: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;

Line 1309: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;

1305: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1306: return varchar2 is
1307: -- local variables
1308: lv_procedure_name constant varchar2(18) := 'get_appraisal_type';
1309: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1310: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1311: lv_system_type VARCHAR2(30) default null;
1312: BEGIN
1313: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

Line 1310: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;

1306: return varchar2 is
1307: -- local variables
1308: lv_procedure_name constant varchar2(18) := 'get_appraisal_type';
1309: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1310: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1311: lv_system_type VARCHAR2(30) default null;
1312: BEGIN
1313: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1314: if(hr_utility.debug_enabled) then

Line 1322: from hr_api_transactions

1318:
1319: begin
1320: select transaction_ref_table,transaction_ref_id
1321: into lv_transaction_ref_table,lv_transaction_ref_id
1322: from hr_api_transactions
1323: where transaction_id=p_transaction_id;
1324:
1325: if(lv_transaction_ref_table='PER_APPRAISALS') then
1326: begin

Line 1339: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'|| sqlerrm);

1335: end;
1336: end if;
1337: exception
1338: when others then
1339: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'|| sqlerrm);
1340: -- just log the message no need to raise it
1341: end;
1342: if(hr_utility.debug_enabled) then
1343: -- write debug statements

Line 1357: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1353: END get_appraisal_type;
1354:
1355:
1356: FUNCTION get_overall_appraisal_rating
1357: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1358: return number is
1359: -- local variables
1360: lv_procedure_name constant varchar2(28) := 'get_overall_appraisal_rating';
1361: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;

Line 1361: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;

1357: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1358: return number is
1359: -- local variables
1360: lv_procedure_name constant varchar2(28) := 'get_overall_appraisal_rating';
1361: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1362: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1363: ln_overall_rating number;
1364:
1365: BEGIN

Line 1362: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;

1358: return number is
1359: -- local variables
1360: lv_procedure_name constant varchar2(28) := 'get_overall_appraisal_rating';
1361: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1362: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1363: ln_overall_rating number;
1364:
1365: BEGIN
1366: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

Line 1375: from hr_api_transactions

1371:
1372: begin
1373: select transaction_ref_table,transaction_ref_id
1374: into lv_transaction_ref_table,lv_transaction_ref_id
1375: from hr_api_transactions
1376: where transaction_id=p_transaction_id;
1377:
1378: if(lv_transaction_ref_table='PER_APPRAISALS') then
1379: begin

Line 1393: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'|| sqlerrm);

1389: end;
1390: end if;
1391: exception
1392: when others then
1393: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'|| sqlerrm);
1394: -- just log the message no need to raise it
1395: end;
1396:
1397:

Line 1416: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1412:
1413: END get_overall_appraisal_rating;
1414:
1415: FUNCTION get_absence_type_id
1416: (p_transaction_id IN hr_api_transactions.transaction_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;

Line 1450: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1446:
1447: END get_absence_type_id;
1448:
1449: FUNCTION get_proposed_payroll_id
1450: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1451: return varchar2 is
1452: -- local variables
1453: lv_procedure_name constant varchar2(23) := 'get_proposed_payroll_id';
1454:

Line 1500: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1496: END get_proposed_payroll_id;
1497:
1498:
1499: FUNCTION get_proposed_salary_basis
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;

Line 1547: select transaction_effective_date into ld_effective_date from hr_api_transactions

1543: aname => 'CURRENT_EFFECTIVE_DATE',
1544: ignore_notfound => true);
1545:
1546: else
1547: select transaction_effective_date into ld_effective_date from hr_api_transactions
1548: where transaction_id = p_transaction_id;
1549: end if;
1550:
1551: select ppb.name

Line 1586: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1582: END get_proposed_salary_basis;
1583:
1584:
1585: FUNCTION get_asg_change_reason
1586: (p_transaction_id IN hr_api_transactions.transaction_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;

Line 1638: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1634:
1635: END get_asg_change_reason;
1636:
1637: FUNCTION get_leaving_reason
1638: (p_transaction_id IN hr_api_transactions.transaction_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;

Line 1675: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1671: END get_leaving_reason;
1672:
1673:
1674: FUNCTION get_person_type_id
1675: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1676: return varchar2 is
1677: -- local variables
1678: lv_procedure_name constant varchar2(18) := 'get_person_type_id';
1679: lv_person_type_id VARCHAR2(30) default null;

Line 1735: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1731: END getYOS;
1732:
1733:
1734: FUNCTION get_length_of_service
1735: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1736: return number is
1737: -- local variables
1738: lv_procedure_name constant varchar2(21) := 'get_length_of_service';
1739: ln_length_of_service number;

Line 1765: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1761:
1762:
1763:
1764: FUNCTION get_assignment_category
1765: (p_transaction_id IN hr_api_transactions.transaction_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;

Line 1815: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1811:
1812: END get_assignment_category;
1813:
1814: FUNCTION get_payroll_con_user_name
1815: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1816: return varchar2 is
1817: -- local variables
1818: lv_procedure_name constant varchar2(25) := 'get_payroll_con_user_name';
1819: lv_user_name varchar2(30) default null;

Line 1857: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1853: END get_payroll_con_user_name;
1854:
1855:
1856: FUNCTION get_basic_details_step_id
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;

Line 1895: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1891: END get_basic_details_step_id;
1892:
1893:
1894: FUNCTION isPersonDetailsChange
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;

Line 1933: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1929:
1930:
1931:
1932: FUNCTION get_person_address_step_id
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;

Line 1971: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1967: END get_person_address_step_id;
1968:
1969:
1970: FUNCTION isPersonAddressChange
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;

Line 2007: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

2003: END isPersonAddressChange;
2004:
2005:
2006: FUNCTION get_person_contact_step_id
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;

Line 2048: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

2044: END get_person_contact_step_id;
2045:
2046:
2047: FUNCTION isPersonContactChange
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;

Line 2085: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

2081:
2082:
2083:
2084: FUNCTION get_caed_step_id
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;

Line 2123: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

2119: END get_caed_step_id;
2120:
2121:
2122: FUNCTION isReleaseInformation
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;

Line 2159: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

2155: END isReleaseInformation;
2156:
2157:
2158: FUNCTION get_paybasis_id
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;

Line 2198: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

2194:
2195: END get_paybasis_id;
2196:
2197: FUNCTION isMidPayPayPeriodChange
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;

Line 2318: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

2314: END isMidPayPayPeriodChange;
2315:
2316:
2317: FUNCTION getRequestorPositionId
2318: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
2319: return number
2320: is
2321: -- local variable
2322: ln_position_id number;

Line 2331: hr_api_transactions hat

2327: select paf.position_id
2328: from per_all_assignments_f paf,
2329: per_all_people_f ppf,
2330: per_position_structures pps, per_pos_structure_versions ppsv,
2331: hr_api_transactions hat
2332: where hat.transaction_id = p_transaction_id
2333: and paf.person_id = hat.creator_person_id
2334: and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
2335: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date