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.OTA_COMPETENCE_SS dependencies on HR_TRANSACTION_API

Line 35: l_competence_id := hr_transaction_api.get_varchar2_value

31:
32: begin
33:
34:
35: l_competence_id := hr_transaction_api.get_varchar2_value
36: (p_transaction_step_id => p_transaction_step_id
37: ,p_name => 'P_COMPETENCE');
38:
39:

Line 40: l_level_id := hr_transaction_api.get_varchar2_value

36: (p_transaction_step_id => p_transaction_step_id
37: ,p_name => 'P_COMPETENCE');
38:
39:
40: l_level_id := hr_transaction_api.get_varchar2_value
41: (p_transaction_step_id => p_transaction_step_id
42: ,p_name => 'P_LEVEL');
43:
44: l_level_override := hr_transaction_api.get_varchar2_value

Line 44: l_level_override := hr_transaction_api.get_varchar2_value

40: l_level_id := hr_transaction_api.get_varchar2_value
41: (p_transaction_step_id => p_transaction_step_id
42: ,p_name => 'P_LEVEL');
43:
44: l_level_override := hr_transaction_api.get_varchar2_value
45: (p_transaction_step_id => p_transaction_step_id
46: ,p_name => 'P_LEVELOVERRIDE');
47:
48:

Line 49: l_date_from := hr_transaction_api.get_varchar2_value

45: (p_transaction_step_id => p_transaction_step_id
46: ,p_name => 'P_LEVELOVERRIDE');
47:
48:
49: l_date_from := hr_transaction_api.get_varchar2_value
50: (p_transaction_step_id => p_transaction_step_id
51: ,p_name => 'P_DATEFROM');
52:
53: l_date_to := hr_transaction_api.get_varchar2_value

Line 53: l_date_to := hr_transaction_api.get_varchar2_value

49: l_date_from := hr_transaction_api.get_varchar2_value
50: (p_transaction_step_id => p_transaction_step_id
51: ,p_name => 'P_DATEFROM');
52:
53: l_date_to := hr_transaction_api.get_varchar2_value
54: (p_transaction_step_id => p_transaction_step_id
55: ,p_name => 'P_DATETO');
56:
57:

Line 58: l_source := hr_transaction_api.get_varchar2_value

54: (p_transaction_step_id => p_transaction_step_id
55: ,p_name => 'P_DATETO');
56:
57:
58: l_source := hr_transaction_api.get_varchar2_value
59: (p_transaction_step_id => p_transaction_step_id
60: ,p_name => 'P_SOURCE');
61:
62: l_certification_date := hr_transaction_api.get_varchar2_value

Line 62: l_certification_date := hr_transaction_api.get_varchar2_value

58: l_source := hr_transaction_api.get_varchar2_value
59: (p_transaction_step_id => p_transaction_step_id
60: ,p_name => 'P_SOURCE');
61:
62: l_certification_date := hr_transaction_api.get_varchar2_value
63: (p_transaction_step_id => p_transaction_step_id
64: ,p_name => 'P_CERTDATE');
65:
66:

Line 67: l_certification_method := hr_transaction_api.get_varchar2_value

63: (p_transaction_step_id => p_transaction_step_id
64: ,p_name => 'P_CERTDATE');
65:
66:
67: l_certification_method := hr_transaction_api.get_varchar2_value
68: (p_transaction_step_id => p_transaction_step_id
69: ,p_name => 'P_CERTMETHOD');
70:
71: l_certification_next := hr_transaction_api.get_varchar2_value

Line 71: l_certification_next := hr_transaction_api.get_varchar2_value

67: l_certification_method := hr_transaction_api.get_varchar2_value
68: (p_transaction_step_id => p_transaction_step_id
69: ,p_name => 'P_CERTMETHOD');
70:
71: l_certification_next := hr_transaction_api.get_varchar2_value
72: (p_transaction_step_id => p_transaction_step_id
73: ,p_name => 'P_CERTNEXT');
74:
75: -- l_certification_next := to_char(to_date(l_certification_next),fnd_profile.value('ICX_DATE_FORMAT_MASK'));

Line 77: l_comments := hr_transaction_api.get_varchar2_value

73: ,p_name => 'P_CERTNEXT');
74:
75: -- l_certification_next := to_char(to_date(l_certification_next),fnd_profile.value('ICX_DATE_FORMAT_MASK'));
76:
77: l_comments := hr_transaction_api.get_varchar2_value
78: (p_transaction_step_id => p_transaction_step_id
79: ,p_name => 'P_COMMENTS');
80:
81: l_from := hr_transaction_api.get_varchar2_value

Line 81: l_from := hr_transaction_api.get_varchar2_value

77: l_comments := hr_transaction_api.get_varchar2_value
78: (p_transaction_step_id => p_transaction_step_id
79: ,p_name => 'P_COMMENTS');
80:
81: l_from := hr_transaction_api.get_varchar2_value
82: (p_transaction_step_id => p_transaction_step_id
83: ,p_name => 'P_FROM');
84:
85: p_from := l_from;

Line 138: /* hr_transaction_api.get_transaction_step_info

134:
135:
136: BEGIN
137:
138: /* hr_transaction_api.get_transaction_step_info
139: (p_item_type => p_item_type
140: ,p_item_key => p_item_key
141: ,p_activity_id => p_activity_id
142: ,p_transaction_step_id => l_trans_step_ids

Line 309: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type

305: END IF;
306:
307: hr_utility.set_location('Before chk transaction step'||l_proc, 5);
308:
309: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
310: ,p_item_key => p_item_key
311: ,p_activity_id => l_activity_id) and p_from is null ) then
312:
313: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

Line 313: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

309: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
310: ,p_item_key => p_item_key
311: ,p_activity_id => l_activity_id) and p_from is null ) then
312:
313: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type
314: ,p_item_key => p_item_key
315: ,p_activity_id => l_activity_id
316: ,p_transaction_step_id => l_old_transaction_step_id
317: ,p_object_version_number => l_old_object_version_number);

Line 323: hr_transaction_api.delete_transaction_step(p_validate => false

319:
320:
321:
322: -- if l_old_transaction_step_id is not null then
323: hr_transaction_api.delete_transaction_step(p_validate => false
324: ,p_transaction_step_id => l_old_transaction_step_id
325: ,p_person_id => p_person_id
326: ,p_object_version_number => l_old_object_version_number);
327:

Line 340: l_business_group_id := hr_transaction_api.get_varchar2_value

336: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
337: ,itemkey => p_item_key
338: ,aname => 'OTA_TRANSACTION_STEP_ID');
339:
340: l_business_group_id := hr_transaction_api.get_varchar2_value
341: (p_transaction_step_id => l_transaction_step_id
342: ,p_name => 'P_BUSINESS_GROUP_ID');
343:
344: else

Line 346: hr_transaction_api.create_transaction_step

342: ,p_name => 'P_BUSINESS_GROUP_ID');
343:
344: else
345:
346: hr_transaction_api.create_transaction_step
347: (p_validate => false
348: ,p_creator_person_id => p_person_id
349: ,p_transaction_id => l_transaction_id
350: ,p_api_name => g_package || '.PROCESS_API'

Line 459: hr_transaction_api.update_transaction

455:
456: hr_utility.set_location('After save transaction step'||l_proc, 50);
457:
458: if p_from ='SS' then
459: hr_transaction_api.update_transaction
460: (p_transaction_id => l_transaction_id
461: -- ,p_status => lv_status
462: ,p_transaction_state => null
463: -- ,p_transaction_effective_date => ld_trans_effec_date

Line 576: hr_transaction_api.update_transaction(

572: ,aname => 'ERROR_MESSAGE_TEXT'
573: ,avalue => nvl(l_error_text, sqlerrm));
574: hr_utility.trace('l_error_text' || nvl(l_error_text, sqlerrm));
575: -- update the transaction table status
576: hr_transaction_api.update_transaction(
577: p_transaction_id => hr_transaction_ss.get_transaction_id
578: (p_item_type => itemtype
579: ,p_item_key => itemkey),
580: p_status => 'E');

Line 666: hr_transaction_api.update_transaction(

662: ,aname => 'ERROR_MESSAGE_TEXT'
663: ,avalue => nvl(l_error_text, sqlerrm));
664: hr_utility.trace('l_error_text' || nvl(l_error_text, sqlerrm));
665: -- update the transaction table status
666: hr_transaction_api.update_transaction(
667: p_transaction_id => hr_transaction_ss.get_transaction_id
668: (p_item_type => itemtype
669: ,p_item_key => itemkey),
670: p_status => 'E');

Line 969: /* l_Comp_ids := hr_transaction_api.get_varchar2_value

965:
966:
967: BEGIN
968:
969: /* l_Comp_ids := hr_transaction_api.get_varchar2_value
970: (p_transaction_step_id => p_transaction_step_id
971: ,p_name => 'P_COMPETENCE');*/
972:
973: SAVEPOINT validate_competence;

Line 975: l_person_id := hr_transaction_api.get_number_value

971: ,p_name => 'P_COMPETENCE');*/
972:
973: SAVEPOINT validate_competence;
974:
975: l_person_id := hr_transaction_api.get_number_value
976: (p_transaction_step_id => p_transaction_step_id
977: ,p_name => 'P_PERSON');
978:
979: l_Comp_ids := hr_transaction_api.get_varchar2_value

Line 979: l_Comp_ids := hr_transaction_api.get_varchar2_value

975: l_person_id := hr_transaction_api.get_number_value
976: (p_transaction_step_id => p_transaction_step_id
977: ,p_name => 'P_PERSON');
978:
979: l_Comp_ids := hr_transaction_api.get_varchar2_value
980: (p_transaction_step_id => p_transaction_step_id
981: ,p_name => 'P_COMPETENCE');
982:
983: l_level_ids := hr_transaction_api.get_varchar2_value

Line 983: l_level_ids := hr_transaction_api.get_varchar2_value

979: l_Comp_ids := hr_transaction_api.get_varchar2_value
980: (p_transaction_step_id => p_transaction_step_id
981: ,p_name => 'P_COMPETENCE');
982:
983: l_level_ids := hr_transaction_api.get_varchar2_value
984: (p_transaction_step_id => p_transaction_step_id
985: ,p_name => 'P_LEVEL');
986:
987: l_override_ids := hr_transaction_api.get_varchar2_value

Line 987: l_override_ids := hr_transaction_api.get_varchar2_value

983: l_level_ids := hr_transaction_api.get_varchar2_value
984: (p_transaction_step_id => p_transaction_step_id
985: ,p_name => 'P_LEVEL');
986:
987: l_override_ids := hr_transaction_api.get_varchar2_value
988: (p_transaction_step_id => p_transaction_step_id
989: ,p_name => 'P_LEVELOVERRIDE');
990:
991: l_dtFrom := hr_transaction_api.get_varchar2_value

Line 991: l_dtFrom := hr_transaction_api.get_varchar2_value

987: l_override_ids := hr_transaction_api.get_varchar2_value
988: (p_transaction_step_id => p_transaction_step_id
989: ,p_name => 'P_LEVELOVERRIDE');
990:
991: l_dtFrom := hr_transaction_api.get_varchar2_value
992: (p_transaction_step_id => p_transaction_step_id
993: ,p_name => 'P_DATEFROM');
994:
995: l_dtTo := hr_transaction_api.get_varchar2_value

Line 995: l_dtTo := hr_transaction_api.get_varchar2_value

991: l_dtFrom := hr_transaction_api.get_varchar2_value
992: (p_transaction_step_id => p_transaction_step_id
993: ,p_name => 'P_DATEFROM');
994:
995: l_dtTo := hr_transaction_api.get_varchar2_value
996: (p_transaction_step_id => p_transaction_step_id
997: ,p_name => 'P_DATETO');
998:
999: l_source := hr_transaction_api.get_varchar2_value

Line 999: l_source := hr_transaction_api.get_varchar2_value

995: l_dtTo := hr_transaction_api.get_varchar2_value
996: (p_transaction_step_id => p_transaction_step_id
997: ,p_name => 'P_DATETO');
998:
999: l_source := hr_transaction_api.get_varchar2_value
1000: (p_transaction_step_id => p_transaction_step_id
1001: ,p_name => 'P_SOURCE');
1002:
1003: l_certDate := hr_transaction_api.get_varchar2_value

Line 1003: l_certDate := hr_transaction_api.get_varchar2_value

999: l_source := hr_transaction_api.get_varchar2_value
1000: (p_transaction_step_id => p_transaction_step_id
1001: ,p_name => 'P_SOURCE');
1002:
1003: l_certDate := hr_transaction_api.get_varchar2_value
1004: (p_transaction_step_id => p_transaction_step_id
1005: ,p_name => 'P_CERTDATE');
1006:
1007: l_certMethod := hr_transaction_api.get_varchar2_value

Line 1007: l_certMethod := hr_transaction_api.get_varchar2_value

1003: l_certDate := hr_transaction_api.get_varchar2_value
1004: (p_transaction_step_id => p_transaction_step_id
1005: ,p_name => 'P_CERTDATE');
1006:
1007: l_certMethod := hr_transaction_api.get_varchar2_value
1008: (p_transaction_step_id => p_transaction_step_id
1009: ,p_name => 'P_CERTMETHOD');
1010:
1011:

Line 1012: l_certNext := hr_transaction_api.get_varchar2_value

1008: (p_transaction_step_id => p_transaction_step_id
1009: ,p_name => 'P_CERTMETHOD');
1010:
1011:
1012: l_certNext := hr_transaction_api.get_varchar2_value
1013: (p_transaction_step_id => p_transaction_step_id
1014: ,p_name => 'P_CERTNEXT');
1015:
1016: l_comments := hr_transaction_api.get_varchar2_value

Line 1016: l_comments := hr_transaction_api.get_varchar2_value

1012: l_certNext := hr_transaction_api.get_varchar2_value
1013: (p_transaction_step_id => p_transaction_step_id
1014: ,p_name => 'P_CERTNEXT');
1015:
1016: l_comments := hr_transaction_api.get_varchar2_value
1017: (p_transaction_step_id => p_transaction_step_id
1018: ,p_name => 'P_COMMENTS');
1019:
1020: l_business_group_id := hr_transaction_api.get_varchar2_value

Line 1020: l_business_group_id := hr_transaction_api.get_varchar2_value

1016: l_comments := hr_transaction_api.get_varchar2_value
1017: (p_transaction_step_id => p_transaction_step_id
1018: ,p_name => 'P_COMMENTS');
1019:
1020: l_business_group_id := hr_transaction_api.get_varchar2_value
1021: (p_transaction_step_id => p_transaction_step_id
1022: ,p_name => 'P_BUSINESS_GROUP_ID');
1023:
1024: --GET item type and key

Line 1025: hr_transaction_api.get_transaction_step_info

1021: (p_transaction_step_id => p_transaction_step_id
1022: ,p_name => 'P_BUSINESS_GROUP_ID');
1023:
1024: --GET item type and key
1025: hr_transaction_api.get_transaction_step_info
1026: (p_transaction_step_id => p_transaction_step_id
1027: ,p_item_type => l_item_type
1028: ,p_item_key => l_item_key
1029: ,p_activity_id => l_activity_id);