DBA Data[Home] [Help]

APPS.HR_APPLICANT_API dependencies on PER_ALL_PEOPLE_F

Line 988: p_person_id in per_all_people_f.person_id%TYPE,

984: --
985: procedure hire_applicant
986: (p_validate in boolean default false,
987: p_hire_date in date,
988: p_person_id in per_all_people_f.person_id%TYPE,
989: p_assignment_id in number default null,
990: p_person_type_id in number default null,
991: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
992: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,

Line 991: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

987: p_hire_date in date,
988: p_person_id in per_all_people_f.person_id%TYPE,
989: p_assignment_id in number default null,
990: p_person_type_id in number default null,
991: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
992: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
993: p_per_effective_start_date out nocopy date,
994: p_per_effective_end_date out nocopy date,
995: p_unaccepted_asg_del_warning out nocopy boolean,

Line 992: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,

988: p_person_id in per_all_people_f.person_id%TYPE,
989: p_assignment_id in number default null,
990: p_person_type_id in number default null,
991: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
992: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
993: p_per_effective_start_date out nocopy date,
994: p_per_effective_end_date out nocopy date,
995: p_unaccepted_asg_del_warning out nocopy boolean,
996: p_assign_payroll_warning out nocopy boolean,

Line 1090: p_person_id in per_all_people_f.person_id%TYPE,

1086: --
1087: procedure hire_applicant
1088: (p_validate in boolean default false,
1089: p_hire_date in date,
1090: p_person_id in per_all_people_f.person_id%TYPE,
1091: p_assignment_id in number default null,
1092: p_person_type_id in number default null,
1093: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
1094: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

Line 1093: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,

1089: p_hire_date in date,
1090: p_person_id in per_all_people_f.person_id%TYPE,
1091: p_assignment_id in number default null,
1092: p_person_type_id in number default null,
1093: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
1094: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1095: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1096: p_per_effective_start_date out nocopy date,
1097: p_per_effective_end_date out nocopy date,

Line 1094: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

1090: p_person_id in per_all_people_f.person_id%TYPE,
1091: p_assignment_id in number default null,
1092: p_person_type_id in number default null,
1093: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
1094: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1095: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1096: p_per_effective_start_date out nocopy date,
1097: p_per_effective_end_date out nocopy date,
1098: p_unaccepted_asg_del_warning out nocopy boolean,

Line 1095: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,

1091: p_assignment_id in number default null,
1092: p_person_type_id in number default null,
1093: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
1094: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1095: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1096: p_per_effective_start_date out nocopy date,
1097: p_per_effective_end_date out nocopy date,
1098: p_unaccepted_asg_del_warning out nocopy boolean,
1099: p_assign_payroll_warning out nocopy boolean,

Line 1119: ,p_person_id IN per_all_people_f.person_id%TYPE

1115: --
1116: PROCEDURE terminate_applicant
1117: (p_validate IN BOOLEAN DEFAULT FALSE
1118: ,p_effective_date IN DATE
1119: ,p_person_id IN per_all_people_f.person_id%TYPE
1120: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1121: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1122: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1123: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

Line 1120: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

1116: PROCEDURE terminate_applicant
1117: (p_validate IN BOOLEAN DEFAULT FALSE
1118: ,p_effective_date IN DATE
1119: ,p_person_id IN per_all_people_f.person_id%TYPE
1120: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1121: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1122: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1123: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1124: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 1123: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

1119: ,p_person_id IN per_all_people_f.person_id%TYPE
1120: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1121: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1122: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1123: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1124: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1125: );
1126: -- -----------------------------------------------------------------------------
1127: -- |-----------------------< terminate_applicant(New) >------------------------|

Line 1124: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

1120: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1121: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1122: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1123: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1124: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1125: );
1126: -- -----------------------------------------------------------------------------
1127: -- |-----------------------< terminate_applicant(New) >------------------------|
1128: -- -----------------------------------------------------------------------------

Line 1138: ,p_person_id IN per_all_people_f.person_id%TYPE

1134: --
1135: PROCEDURE terminate_applicant
1136: (p_validate IN BOOLEAN DEFAULT FALSE
1137: ,p_effective_date IN DATE
1138: ,p_person_id IN per_all_people_f.person_id%TYPE
1139: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1140: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1141: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1142: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE --#3371944

Line 1139: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

1135: PROCEDURE terminate_applicant
1136: (p_validate IN BOOLEAN DEFAULT FALSE
1137: ,p_effective_date IN DATE
1138: ,p_person_id IN per_all_people_f.person_id%TYPE
1139: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1140: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1141: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1142: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE --#3371944
1143: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

Line 1143: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

1139: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1140: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1141: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1142: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE --#3371944
1143: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1144: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1145: );
1146: -- ----------------------------------------------------------------------------
1147: -- |-----------------------< terminate_applicant(New2) >----------------------|

Line 1144: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

1140: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1141: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1142: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE --#3371944
1143: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1144: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1145: );
1146: -- ----------------------------------------------------------------------------
1147: -- |-----------------------< terminate_applicant(New2) >----------------------|
1148: -- ----------------------------------------------------------------------------

Line 1158: ,p_person_id IN per_all_people_f.person_id%TYPE

1154: --
1155: PROCEDURE terminate_applicant
1156: (p_validate IN BOOLEAN
1157: ,p_effective_date IN DATE
1158: ,p_person_id IN per_all_people_f.person_id%TYPE
1159: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1160: ,p_person_type_id IN per_person_types.person_type_id%TYPE
1161: ,p_termination_reason IN per_applications.termination_reason%TYPE
1162: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

Line 1159: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

1155: PROCEDURE terminate_applicant
1156: (p_validate IN BOOLEAN
1157: ,p_effective_date IN DATE
1158: ,p_person_id IN per_all_people_f.person_id%TYPE
1159: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1160: ,p_person_type_id IN per_person_types.person_type_id%TYPE
1161: ,p_termination_reason IN per_applications.termination_reason%TYPE
1162: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
1163: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

Line 1163: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

1159: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1160: ,p_person_type_id IN per_person_types.person_type_id%TYPE
1161: ,p_termination_reason IN per_applications.termination_reason%TYPE
1162: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
1163: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1164: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1165: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025
1166: );
1167: -- ----------------------------------------------------------------------------

Line 1164: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

1160: ,p_person_type_id IN per_person_types.person_type_id%TYPE
1161: ,p_termination_reason IN per_applications.termination_reason%TYPE
1162: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
1163: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1164: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1165: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025
1166: );
1167: -- ----------------------------------------------------------------------------
1168: -- |-----------------------< terminate_applicant(New3) >----------------------|

Line 1233: ,p_person_id IN per_all_people_f.person_id%TYPE

1229: --
1230: PROCEDURE terminate_applicant
1231: (p_validate IN BOOLEAN DEFAULT FALSE
1232: ,p_effective_date IN DATE
1233: ,p_person_id IN per_all_people_f.person_id%TYPE
1234: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1235: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1236: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1237: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT hr_api.g_number

Line 1234: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

1230: PROCEDURE terminate_applicant
1231: (p_validate IN BOOLEAN DEFAULT FALSE
1232: ,p_effective_date IN DATE
1233: ,p_person_id IN per_all_people_f.person_id%TYPE
1234: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1235: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1236: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1237: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
1238: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579

Line 1239: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

1235: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1236: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1237: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
1238: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
1239: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1240: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1241: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025
1242: );
1243: --

Line 1240: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

1236: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1237: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
1238: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
1239: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1240: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1241: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025
1242: );
1243: --
1244: -- -----------------------------------------------------------------------------

Line 1256: ,p_person_id IN per_all_people_f.person_id%TYPE

1252: --
1253: PROCEDURE convert_to_applicant
1254: (p_validate IN BOOLEAN DEFAULT FALSE
1255: ,p_effective_date IN DATE
1256: ,p_person_id IN per_all_people_f.person_id%TYPE
1257: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1258: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1259: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1260: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

Line 1257: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

1253: PROCEDURE convert_to_applicant
1254: (p_validate IN BOOLEAN DEFAULT FALSE
1255: ,p_effective_date IN DATE
1256: ,p_person_id IN per_all_people_f.person_id%TYPE
1257: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1258: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1259: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1260: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1261: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 1258: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE

1254: (p_validate IN BOOLEAN DEFAULT FALSE
1255: ,p_effective_date IN DATE
1256: ,p_person_id IN per_all_people_f.person_id%TYPE
1257: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1258: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1259: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1260: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1261: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1262: );

Line 1260: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

1256: ,p_person_id IN per_all_people_f.person_id%TYPE
1257: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1258: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1259: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1260: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1261: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1262: );
1263: -- NEW
1264: -- -----------------------------------------------------------------------------

Line 1261: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

1257: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1258: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1259: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1260: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1261: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1262: );
1263: -- NEW
1264: -- -----------------------------------------------------------------------------
1265: -- |------------------------< convert_to_applicant >---------------------------|

Line 1329: ,p_person_id IN per_all_people_f.person_id%TYPE

1325: --
1326: PROCEDURE convert_to_applicant
1327: (p_validate IN BOOLEAN DEFAULT FALSE
1328: ,p_effective_date IN DATE
1329: ,p_person_id IN per_all_people_f.person_id%TYPE
1330: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1331: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1332: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1333: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

Line 1330: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

1326: PROCEDURE convert_to_applicant
1327: (p_validate IN BOOLEAN DEFAULT FALSE
1328: ,p_effective_date IN DATE
1329: ,p_person_id IN per_all_people_f.person_id%TYPE
1330: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1331: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1332: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1333: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1334: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 1331: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE

1327: (p_validate IN BOOLEAN DEFAULT FALSE
1328: ,p_effective_date IN DATE
1329: ,p_person_id IN per_all_people_f.person_id%TYPE
1330: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1331: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1332: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1333: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1334: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1335: ,p_appl_override_warning OUT NOCOPY boolean -- 3652025

Line 1333: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

1329: ,p_person_id IN per_all_people_f.person_id%TYPE
1330: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1331: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1332: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1333: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1334: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1335: ,p_appl_override_warning OUT NOCOPY boolean -- 3652025
1336: );
1337: --

Line 1334: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

1330: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1331: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1332: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1333: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1334: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1335: ,p_appl_override_warning OUT NOCOPY boolean -- 3652025
1336: );
1337: --
1338: -- ----------------------------------------------------------------------------+