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 811: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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

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

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

Line 942: from hr_api_transactions

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

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

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

Line 990: select transaction_effective_date into lv_effective_date_string from hr_api_transactions

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

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

1008:
1009:
1010:
1011: FUNCTION get_sel_person_prop_sup_id
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;

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

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

Line 1089: select selected_person_id into lv_selected_person_id from hr_api_transactions

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

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

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

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

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

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

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

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

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

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

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

Line 1311: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;

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

Line 1312: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;

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

Line 1324: from hr_api_transactions

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

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

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

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

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

Line 1363: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;

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

Line 1364: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;

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

Line 1377: from hr_api_transactions

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

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

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

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

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

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

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

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

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

Line 1549: select transaction_effective_date into ld_effective_date from hr_api_transactions

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1931:
1932:
1933:
1934: FUNCTION get_person_address_step_id
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;

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

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

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

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

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

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

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

2083:
2084:
2085:
2086: FUNCTION get_caed_step_id
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;

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

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

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

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

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

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

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

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

Line 2333: hr_api_transactions hat

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