DBA Data[Home] [Help]

APPS.HR_APPLICANT_API dependencies on PER_ALL_PEOPLE_F

Line 1098: p_person_id in per_all_people_f.person_id%TYPE,

1094: --
1095: procedure hire_applicant
1096: (p_validate in boolean default false,
1097: p_hire_date in date,
1098: p_person_id in per_all_people_f.person_id%TYPE,
1099: p_assignment_id in number default null,
1100: p_person_type_id in number default null,
1101: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1102: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,

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

1097: p_hire_date in date,
1098: p_person_id in per_all_people_f.person_id%TYPE,
1099: p_assignment_id in number default null,
1100: p_person_type_id in number default null,
1101: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1102: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1103: p_per_effective_start_date out nocopy date,
1104: p_per_effective_end_date out nocopy date,
1105: p_unaccepted_asg_del_warning out nocopy boolean,

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

1098: p_person_id in per_all_people_f.person_id%TYPE,
1099: p_assignment_id in number default null,
1100: p_person_type_id in number default null,
1101: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1102: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1103: p_per_effective_start_date out nocopy date,
1104: p_per_effective_end_date out nocopy date,
1105: p_unaccepted_asg_del_warning out nocopy boolean,
1106: p_assign_payroll_warning out nocopy boolean,

Line 1124: p_person_id in per_all_people_f.person_id%TYPE,

1120: -- support being withdrawn thus avoiding any potential disruption.
1121: procedure hire_applicant
1122: (p_validate in boolean default false,
1123: p_hire_date in date,
1124: p_person_id in per_all_people_f.person_id%TYPE,
1125: p_assignment_id in number default null,
1126: p_person_type_id in number default null,
1127: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
1128: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

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

1123: p_hire_date in date,
1124: p_person_id in per_all_people_f.person_id%TYPE,
1125: p_assignment_id in number default null,
1126: p_person_type_id in number default null,
1127: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
1128: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1129: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1130: p_per_effective_start_date out nocopy date,
1131: p_per_effective_end_date out nocopy date,

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

1124: p_person_id in per_all_people_f.person_id%TYPE,
1125: p_assignment_id in number default null,
1126: p_person_type_id in number default null,
1127: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
1128: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1129: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1130: p_per_effective_start_date out nocopy date,
1131: p_per_effective_end_date out nocopy date,
1132: p_unaccepted_asg_del_warning out nocopy boolean,

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

1125: p_assignment_id in number default null,
1126: p_person_type_id in number default null,
1127: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
1128: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1129: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1130: p_per_effective_start_date out nocopy date,
1131: p_per_effective_end_date out nocopy date,
1132: p_unaccepted_asg_del_warning out nocopy boolean,
1133: p_assign_payroll_warning out nocopy boolean,

Line 1231: p_person_id in per_all_people_f.person_id%TYPE,

1227: --
1228: procedure hire_applicant
1229: (p_validate in boolean default false,
1230: p_hire_date in date,
1231: p_person_id in per_all_people_f.person_id%TYPE,
1232: p_assignment_id in number default null,
1233: p_person_type_id in number default null,
1234: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
1235: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

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

1230: p_hire_date in date,
1231: p_person_id in per_all_people_f.person_id%TYPE,
1232: p_assignment_id in number default null,
1233: p_person_type_id in number default null,
1234: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
1235: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1236: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1237: p_per_effective_start_date out nocopy date,
1238: p_per_effective_end_date out nocopy date,

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

1231: p_person_id in per_all_people_f.person_id%TYPE,
1232: p_assignment_id in number default null,
1233: p_person_type_id in number default null,
1234: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
1235: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1236: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1237: p_per_effective_start_date out nocopy date,
1238: p_per_effective_end_date out nocopy date,
1239: p_unaccepted_asg_del_warning out nocopy boolean,

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

1232: p_assignment_id in number default null,
1233: p_person_type_id in number default null,
1234: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
1235: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1236: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1237: p_per_effective_start_date out nocopy date,
1238: p_per_effective_end_date out nocopy date,
1239: p_unaccepted_asg_del_warning out nocopy boolean,
1240: p_assign_payroll_warning out nocopy boolean,

Line 1261: ,p_person_id IN per_all_people_f.person_id%TYPE

1257: --
1258: PROCEDURE terminate_applicant
1259: (p_validate IN BOOLEAN DEFAULT FALSE
1260: ,p_effective_date IN DATE
1261: ,p_person_id IN per_all_people_f.person_id%TYPE
1262: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1263: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1264: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1265: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

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

1258: PROCEDURE terminate_applicant
1259: (p_validate IN BOOLEAN DEFAULT FALSE
1260: ,p_effective_date IN DATE
1261: ,p_person_id IN per_all_people_f.person_id%TYPE
1262: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1263: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1264: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1265: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1266: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

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

1261: ,p_person_id IN per_all_people_f.person_id%TYPE
1262: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1263: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1264: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1265: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1266: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1267: );
1268: -- -----------------------------------------------------------------------------
1269: -- |-----------------------< terminate_applicant(New) >------------------------|

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

1262: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1263: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1264: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1265: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1266: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1267: );
1268: -- -----------------------------------------------------------------------------
1269: -- |-----------------------< terminate_applicant(New) >------------------------|
1270: -- -----------------------------------------------------------------------------

Line 1280: ,p_person_id IN per_all_people_f.person_id%TYPE

1276: --
1277: PROCEDURE terminate_applicant
1278: (p_validate IN BOOLEAN DEFAULT FALSE
1279: ,p_effective_date IN DATE
1280: ,p_person_id IN per_all_people_f.person_id%TYPE
1281: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1282: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1283: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1284: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE --#3371944

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

1277: PROCEDURE terminate_applicant
1278: (p_validate IN BOOLEAN DEFAULT FALSE
1279: ,p_effective_date IN DATE
1280: ,p_person_id IN per_all_people_f.person_id%TYPE
1281: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1282: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1283: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1284: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE --#3371944
1285: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

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

1281: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1282: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1283: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1284: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE --#3371944
1285: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1286: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1287: );
1288: -- ----------------------------------------------------------------------------
1289: -- |-----------------------< terminate_applicant(New2) >----------------------|

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

1282: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1283: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1284: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE --#3371944
1285: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1286: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1287: );
1288: -- ----------------------------------------------------------------------------
1289: -- |-----------------------< terminate_applicant(New2) >----------------------|
1290: -- ----------------------------------------------------------------------------

Line 1300: ,p_person_id IN per_all_people_f.person_id%TYPE

1296: --
1297: PROCEDURE terminate_applicant
1298: (p_validate IN BOOLEAN
1299: ,p_effective_date IN DATE
1300: ,p_person_id IN per_all_people_f.person_id%TYPE
1301: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1302: ,p_person_type_id IN per_person_types.person_type_id%TYPE
1303: ,p_termination_reason IN per_applications.termination_reason%TYPE
1304: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

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

1297: PROCEDURE terminate_applicant
1298: (p_validate IN BOOLEAN
1299: ,p_effective_date IN DATE
1300: ,p_person_id IN per_all_people_f.person_id%TYPE
1301: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1302: ,p_person_type_id IN per_person_types.person_type_id%TYPE
1303: ,p_termination_reason IN per_applications.termination_reason%TYPE
1304: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
1305: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

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

1301: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1302: ,p_person_type_id IN per_person_types.person_type_id%TYPE
1303: ,p_termination_reason IN per_applications.termination_reason%TYPE
1304: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
1305: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1306: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1307: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025
1308: );
1309: -- ----------------------------------------------------------------------------

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

1302: ,p_person_type_id IN per_person_types.person_type_id%TYPE
1303: ,p_termination_reason IN per_applications.termination_reason%TYPE
1304: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
1305: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1306: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1307: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025
1308: );
1309: -- ----------------------------------------------------------------------------
1310: -- |-----------------------< terminate_applicant(New3) >----------------------|

Line 1376: ,p_person_id IN per_all_people_f.person_id%TYPE

1372: --
1373: PROCEDURE terminate_applicant
1374: (p_validate IN BOOLEAN DEFAULT FALSE
1375: ,p_effective_date IN DATE
1376: ,p_person_id IN per_all_people_f.person_id%TYPE
1377: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1378: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1379: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1380: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT hr_api.g_number

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

1373: PROCEDURE terminate_applicant
1374: (p_validate IN BOOLEAN DEFAULT FALSE
1375: ,p_effective_date IN DATE
1376: ,p_person_id IN per_all_people_f.person_id%TYPE
1377: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1378: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT hr_api.g_number
1379: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1380: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
1381: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579

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

1379: ,p_termination_reason IN per_applications.termination_reason%TYPE DEFAULT NULL
1380: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
1381: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
1382: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE DEFAULT NULL -- bug8732296
1383: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1384: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1385: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025
1386: );
1387: --

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

1380: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
1381: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
1382: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE DEFAULT NULL -- bug8732296
1383: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1384: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1385: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025
1386: );
1387: --
1388: -- -----------------------------------------------------------------------------

Line 1400: ,p_person_id IN per_all_people_f.person_id%TYPE

1396: --
1397: PROCEDURE convert_to_applicant
1398: (p_validate IN BOOLEAN DEFAULT FALSE
1399: ,p_effective_date IN DATE
1400: ,p_person_id IN per_all_people_f.person_id%TYPE
1401: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1402: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1403: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1404: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

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

1397: PROCEDURE convert_to_applicant
1398: (p_validate IN BOOLEAN DEFAULT FALSE
1399: ,p_effective_date IN DATE
1400: ,p_person_id IN per_all_people_f.person_id%TYPE
1401: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1402: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1403: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1404: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1405: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

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

1398: (p_validate IN BOOLEAN DEFAULT FALSE
1399: ,p_effective_date IN DATE
1400: ,p_person_id IN per_all_people_f.person_id%TYPE
1401: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1402: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1403: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1404: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1405: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1406: );

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

1400: ,p_person_id IN per_all_people_f.person_id%TYPE
1401: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1402: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1403: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1404: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1405: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1406: );
1407: -- NEW
1408: -- -----------------------------------------------------------------------------

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

1401: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1402: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1403: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1404: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1405: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1406: );
1407: -- NEW
1408: -- -----------------------------------------------------------------------------
1409: -- |------------------------< convert_to_applicant >---------------------------|

Line 1473: ,p_person_id IN per_all_people_f.person_id%TYPE

1469: --
1470: PROCEDURE convert_to_applicant
1471: (p_validate IN BOOLEAN DEFAULT FALSE
1472: ,p_effective_date IN DATE
1473: ,p_person_id IN per_all_people_f.person_id%TYPE
1474: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1475: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1476: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1477: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

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

1470: PROCEDURE convert_to_applicant
1471: (p_validate IN BOOLEAN DEFAULT FALSE
1472: ,p_effective_date IN DATE
1473: ,p_person_id IN per_all_people_f.person_id%TYPE
1474: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1475: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1476: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1477: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1478: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

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

1471: (p_validate IN BOOLEAN DEFAULT FALSE
1472: ,p_effective_date IN DATE
1473: ,p_person_id IN per_all_people_f.person_id%TYPE
1474: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1475: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1476: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1477: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1478: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1479: ,p_appl_override_warning OUT NOCOPY boolean -- 3652025

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

1473: ,p_person_id IN per_all_people_f.person_id%TYPE
1474: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1475: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1476: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1477: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1478: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1479: ,p_appl_override_warning OUT NOCOPY boolean -- 3652025
1480: );
1481: --

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

1474: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
1475: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
1476: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
1477: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
1478: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
1479: ,p_appl_override_warning OUT NOCOPY boolean -- 3652025
1480: );
1481: --
1482: -- ----------------------------------------------------------------------------+