DBA Data[Home] [Help]

APPS.HR_COMP_PROFILE_SS dependencies on HR_TRANSACTION_API

Line 171: hr_transaction_api.create_transaction_step

167: Begin
168: hr_utility.set_location(' Entering:' || l_proc,5);
169: If p_trans_step_id is null then
170: hr_utility.set_location(l_proc,10);
171: hr_transaction_api.create_transaction_step
172: (p_validate => false
173: ,p_creator_person_id => p_login_person_id
174: ,p_transaction_id => p_trans_id
175: ,p_api_name => p_api_name

Line 819: hr_transaction_api.create_transaction_step

815: END IF;
816: --
817: IF transaction_step_id is null then
818: hr_utility.set_location(l_proc,70);
819: hr_transaction_api.create_transaction_step
820: (p_validate => false
821: ,p_creator_person_id => fnd_global.employee_id
822: ,p_transaction_id => l_transaction_id
823: ,p_api_name => g_api_name

Line 879: hr_transaction_api.create_transaction_step

875: ,p_upg_from_rec_id => -1
876: ,p_prev_status => l_preupd_cmptnce_row.status
877: ,p_status => p_competence_status);
878: hr_utility.set_location(l_proc,90);
879: hr_transaction_api.create_transaction_step
880: (p_validate => false
881: ,p_creator_person_id => fnd_global.employee_id
882: ,p_transaction_id => l_transaction_id
883: ,p_api_name => g_api_name

Line 1031: hr_transaction_api.get_number_value

1027: hr_utility.set_location(' Entering:' || l_proc,5);
1028: l_cmp_element_rec.type := 'PERSONAL';
1029: --
1030: l_cmp_element_rec.business_group_id :=
1031: hr_transaction_api.get_number_value
1032: (p_transaction_step_id => p_transaction_step_id
1033: ,p_name => 'P_BUSINESS_GROUP_ID');
1034: --
1035: l_cmp_element_rec.comments :=

Line 1036: hr_transaction_api.get_varchar2_value

1032: (p_transaction_step_id => p_transaction_step_id
1033: ,p_name => 'P_BUSINESS_GROUP_ID');
1034: --
1035: l_cmp_element_rec.comments :=
1036: hr_transaction_api.get_varchar2_value
1037: (p_transaction_step_id => p_transaction_step_id
1038: ,p_name => 'P_COMMENTS');
1039: --
1040: l_cmp_element_rec.person_id:=

Line 1041: hr_transaction_api.get_number_value

1037: (p_transaction_step_id => p_transaction_step_id
1038: ,p_name => 'P_COMMENTS');
1039: --
1040: l_cmp_element_rec.person_id:=
1041: hr_transaction_api.get_number_value
1042: (p_transaction_step_id => p_transaction_step_id
1043: ,p_name => 'P_PERSON_ID');
1044: --
1045: l_cmp_element_rec.competence_element_id :=

Line 1046: hr_transaction_api.get_number_value

1042: (p_transaction_step_id => p_transaction_step_id
1043: ,p_name => 'P_PERSON_ID');
1044: --
1045: l_cmp_element_rec.competence_element_id :=
1046: hr_transaction_api.get_number_value
1047: (p_transaction_step_id => p_transaction_step_id
1048: ,p_name => 'P_COMPETENCE_ELEMENT_ID');
1049: --
1050: l_cmp_element_rec.object_version_number :=

Line 1051: hr_transaction_api.get_number_value

1047: (p_transaction_step_id => p_transaction_step_id
1048: ,p_name => 'P_COMPETENCE_ELEMENT_ID');
1049: --
1050: l_cmp_element_rec.object_version_number :=
1051: hr_transaction_api.get_number_value
1052: (p_transaction_step_id => p_transaction_step_id
1053: ,p_name => 'P_OBJECT_VERSION_NUMBER');
1054: --
1055: l_cmp_element_rec.competence_id :=

Line 1056: hr_transaction_api.get_number_value

1052: (p_transaction_step_id => p_transaction_step_id
1053: ,p_name => 'P_OBJECT_VERSION_NUMBER');
1054: --
1055: l_cmp_element_rec.competence_id :=
1056: hr_transaction_api.get_number_value
1057: (p_transaction_step_id => p_transaction_step_id
1058: ,p_name => 'P_COMPETENCE_ID');
1059: --
1060: l_competence_name :=

Line 1061: hr_transaction_api.get_varchar2_value

1057: (p_transaction_step_id => p_transaction_step_id
1058: ,p_name => 'P_COMPETENCE_ID');
1059: --
1060: l_competence_name :=
1061: hr_transaction_api.get_varchar2_value
1062: (p_transaction_step_id => p_transaction_step_id
1063: ,p_name => 'P_COMPETENCE_NAME');
1064: --
1065: l_cmp_element_rec.proficiency_level_id:=

Line 1066: hr_transaction_api.get_number_value

1062: (p_transaction_step_id => p_transaction_step_id
1063: ,p_name => 'P_COMPETENCE_NAME');
1064: --
1065: l_cmp_element_rec.proficiency_level_id:=
1066: hr_transaction_api.get_number_value
1067: (p_transaction_step_id => p_transaction_step_id
1068: ,p_name => 'P_PROFICIENCY_LEVEL_ID');
1069: --
1070: l_step_value :=

Line 1071: hr_transaction_api.get_number_value

1067: (p_transaction_step_id => p_transaction_step_id
1068: ,p_name => 'P_PROFICIENCY_LEVEL_ID');
1069: --
1070: l_step_value :=
1071: hr_transaction_api.get_number_value
1072: (p_transaction_step_id => p_transaction_step_id
1073: ,p_name => 'P_STEP_VALUE');
1074: --
1075: l_preupd_proficy_lvl_id:=

Line 1076: hr_transaction_api.get_number_value

1072: (p_transaction_step_id => p_transaction_step_id
1073: ,p_name => 'P_STEP_VALUE');
1074: --
1075: l_preupd_proficy_lvl_id:=
1076: hr_transaction_api.get_number_value
1077: (p_transaction_step_id => p_transaction_step_id
1078: ,p_name => 'P_PREUPD_PROFICY_LVL_ID');
1079: --
1080: l_cmp_element_rec.certification_method:=

Line 1081: hr_transaction_api.get_varchar2_value

1077: (p_transaction_step_id => p_transaction_step_id
1078: ,p_name => 'P_PREUPD_PROFICY_LVL_ID');
1079: --
1080: l_cmp_element_rec.certification_method:=
1081: hr_transaction_api.get_varchar2_value
1082: (p_transaction_step_id => p_transaction_step_id
1083: ,p_name => 'P_CERTIFICATION_MTHD');
1084: --
1085: l_cmp_element_rec.source_of_proficiency_level:=

Line 1086: hr_transaction_api.get_varchar2_value

1082: (p_transaction_step_id => p_transaction_step_id
1083: ,p_name => 'P_CERTIFICATION_MTHD');
1084: --
1085: l_cmp_element_rec.source_of_proficiency_level:=
1086: hr_transaction_api.get_varchar2_value
1087: (p_transaction_step_id => p_transaction_step_id
1088: ,p_name => 'P_PROFICY_LVL_SOURCE');
1089: --
1090: l_cmp_element_rec.effective_date_from :=

Line 1091: hr_transaction_api.get_date_value

1087: (p_transaction_step_id => p_transaction_step_id
1088: ,p_name => 'P_PROFICY_LVL_SOURCE');
1089: --
1090: l_cmp_element_rec.effective_date_from :=
1091: hr_transaction_api.get_date_value
1092: (p_transaction_step_id => p_transaction_step_id
1093: ,p_name => 'P_EFF_DATE_FROM');
1094: --
1095: l_cmp_element_rec.effective_date_to :=

Line 1096: hr_transaction_api.get_date_value

1092: (p_transaction_step_id => p_transaction_step_id
1093: ,p_name => 'P_EFF_DATE_FROM');
1094: --
1095: l_cmp_element_rec.effective_date_to :=
1096: hr_transaction_api.get_date_value
1097: (p_transaction_step_id => p_transaction_step_id
1098: ,p_name => 'P_EFF_DATE_TO');
1099: --
1100: l_cmp_element_rec.certification_date :=

Line 1101: hr_transaction_api.get_date_value

1097: (p_transaction_step_id => p_transaction_step_id
1098: ,p_name => 'P_EFF_DATE_TO');
1099: --
1100: l_cmp_element_rec.certification_date :=
1101: hr_transaction_api.get_date_value
1102: (p_transaction_step_id => p_transaction_step_id
1103: ,p_name => 'P_CERTIFICATION_DATE');
1104: --
1105: l_cmp_element_rec.next_certification_date :=

Line 1106: hr_transaction_api.get_date_value

1102: (p_transaction_step_id => p_transaction_step_id
1103: ,p_name => 'P_CERTIFICATION_DATE');
1104: --
1105: l_cmp_element_rec.next_certification_date :=
1106: hr_transaction_api.get_date_value
1107: (p_transaction_step_id => p_transaction_step_id
1108: ,p_name => 'P_NEXT_CERTIFCTN_DATE');
1109: --
1110: l_system_generated :=

Line 1111: hr_transaction_api.get_varchar2_value

1107: (p_transaction_step_id => p_transaction_step_id
1108: ,p_name => 'P_NEXT_CERTIFCTN_DATE');
1109: --
1110: l_system_generated :=
1111: hr_transaction_api.get_varchar2_value
1112: (p_transaction_step_id => p_transaction_step_id
1113: ,p_name => 'P_SYSTEM_GENERATED');
1114: --
1115: l_upgraded_from_rec_id := NULL;

Line 1117: hr_transaction_api.get_number_value

1113: ,p_name => 'P_SYSTEM_GENERATED');
1114: --
1115: l_upgraded_from_rec_id := NULL;
1116: l_upgraded_from_rec_id :=
1117: hr_transaction_api.get_number_value
1118: (p_transaction_step_id => p_transaction_step_id
1119: ,p_name => 'P_UPGRADED_FROM_REC_ID');
1120: -- for comp qual link enahancement
1121: l_change_mode := NULL;

Line 1123: hr_transaction_api.get_varchar2_value

1119: ,p_name => 'P_UPGRADED_FROM_REC_ID');
1120: -- for comp qual link enahancement
1121: l_change_mode := NULL;
1122: l_change_mode :=
1123: hr_transaction_api.get_varchar2_value
1124: (p_transaction_step_id => p_transaction_step_id
1125: ,p_name => 'P_CHANGE_MODE');
1126:
1127: l_cmp_element_rec.status :=

Line 1128: hr_transaction_api.get_varchar2_value

1124: (p_transaction_step_id => p_transaction_step_id
1125: ,p_name => 'P_CHANGE_MODE');
1126:
1127: l_cmp_element_rec.status :=
1128: hr_transaction_api.get_varchar2_value
1129: (p_transaction_step_id => p_transaction_step_id
1130: ,p_name => 'P_STATUS');
1131: Select ITEM_TYPE,ITEM_KEY,ACTIVITY_ID
1132: INTO l_item_type, l_item_key, l_activity_id

Line 1747: hr_transaction_api.set_date_value(p_transaction_step_id => p_transaction_step_id

1743: BEGIN
1744: hr_utility.set_location(l_proc,10);
1745: IF p_transaction_data(i).param_data_type = 'DATE' THEN
1746: hr_utility.set_location(l_proc,15);
1747: hr_transaction_api.set_date_value(p_transaction_step_id => p_transaction_step_id
1748: ,p_person_id => p_login_person_id
1749: ,p_name => p_transaction_data(i).param_name
1750: ,p_value => to_date(ltrim(rtrim(p_transaction_data(i).param_value)),g_date_format));
1751: ELSIF p_transaction_data(i).param_data_type = 'NUMBER' THEN

Line 1753: hr_transaction_api.set_number_value(p_transaction_step_id => p_transaction_step_id

1749: ,p_name => p_transaction_data(i).param_name
1750: ,p_value => to_date(ltrim(rtrim(p_transaction_data(i).param_value)),g_date_format));
1751: ELSIF p_transaction_data(i).param_data_type = 'NUMBER' THEN
1752: hr_utility.set_location(l_proc,20);
1753: hr_transaction_api.set_number_value(p_transaction_step_id => p_transaction_step_id
1754: ,p_person_id => p_login_person_id
1755: ,p_name => p_transaction_data(i).param_name
1756: ,p_value => to_number(ltrim(rtrim(p_transaction_data(i).param_value))));
1757: ELSIF p_transaction_data(i).param_data_type = 'VARCHAR2' THEN

Line 1759: hr_transaction_api.set_varchar2_value(p_transaction_step_id => p_transaction_step_id

1755: ,p_name => p_transaction_data(i).param_name
1756: ,p_value => to_number(ltrim(rtrim(p_transaction_data(i).param_value))));
1757: ELSIF p_transaction_data(i).param_data_type = 'VARCHAR2' THEN
1758: hr_utility.set_location(l_proc,25);
1759: hr_transaction_api.set_varchar2_value(p_transaction_step_id => p_transaction_step_id
1760: ,p_person_id => p_login_person_id
1761: ,p_name => p_transaction_data(i).param_name
1762: ,p_value => p_transaction_data(i).param_value);
1763: END IF;

Line 2385: hr_transaction_api.create_transaction_step

2381: -- Create a transaction step
2382: hr_utility.set_location(' Entering:' || l_proc,50);
2383: IF p_transaction_step_id is null then
2384: hr_utility.set_location(' Entering:' || l_proc,55);
2385: hr_transaction_api.create_transaction_step
2386: (p_validate => false
2387: ,p_creator_person_id => fnd_global.employee_id
2388: ,p_transaction_id => l_transaction_id
2389: ,p_api_name => g_api_name