APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 400: requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

396: * Reference: pa_project_assignments.attribute15
397: */
398: TYPE REQUIREMENT_IN_REC_TYPE IS RECORD
399: (
400: requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
401: , requirement_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
402: , team_template_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
403: , number_of_requirements NUMBER := 1
404: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 401: , requirement_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

397: */
398: TYPE REQUIREMENT_IN_REC_TYPE IS RECORD
399: (
400: requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
401: , requirement_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
402: , team_template_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
403: , number_of_requirements NUMBER := 1
404: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
405: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 402: , team_template_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

398: TYPE REQUIREMENT_IN_REC_TYPE IS RECORD
399: (
400: requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
401: , requirement_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
402: , team_template_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
403: , number_of_requirements NUMBER := 1
404: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
405: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 404: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

400: requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
401: , requirement_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
402: , team_template_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
403: , number_of_requirements NUMBER := 1
404: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
405: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
407: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 405: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

401: , requirement_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
402: , team_template_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
403: , number_of_requirements NUMBER := 1
404: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
405: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
407: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
409: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 406: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

402: , team_template_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
403: , number_of_requirements NUMBER := 1
404: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
405: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
407: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
409: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
410: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 407: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

403: , number_of_requirements NUMBER := 1
404: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
405: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
407: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
409: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
410: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
411: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 408: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

404: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
405: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
407: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
409: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
410: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
411: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 409: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

405: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
407: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
409: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
410: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
411: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
413: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 410: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

406: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
407: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
409: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
410: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
411: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
413: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
414: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 411: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

407: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
409: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
410: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
411: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
413: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
414: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 412: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

408: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
409: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
410: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
411: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
413: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
414: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
416: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 413: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

409: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
410: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
411: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
413: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
414: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
416: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
417: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 414: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

410: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
411: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
413: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
414: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
416: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
417: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
418: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 415: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

411: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
413: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
414: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
416: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
417: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
418: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
419: , min_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 416: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

412: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
413: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
414: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
416: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
417: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
418: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
419: , min_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
420: , max_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 417: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

413: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
414: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
416: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
417: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
418: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
419: , min_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
420: , max_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
421: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 418: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

414: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
416: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
417: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
418: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
419: , min_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
420: , max_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
421: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
422: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 419: , min_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

415: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
416: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
417: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
418: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
419: , min_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
420: , max_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
421: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
422: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
423: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 420: , max_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

416: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
417: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
418: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
419: , min_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
420: , max_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
421: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
422: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
423: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
424: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 421: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

417: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
418: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
419: , min_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
420: , max_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
421: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
422: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
423: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
424: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
425: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 422: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

418: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
419: , min_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
420: , max_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
421: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
422: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
423: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
424: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
425: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
426: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 423: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

419: , min_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
420: , max_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
421: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
422: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
423: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
424: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
425: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
426: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
427: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 424: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

420: , max_resource_job_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
421: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
422: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
423: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
424: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
425: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
426: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
427: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 425: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

421: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
422: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
423: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
424: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
425: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
426: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
427: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
429: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 426: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

422: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
423: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
424: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
425: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
426: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
427: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
429: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 427: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

423: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
424: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
425: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
426: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
427: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
429: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
431: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 428: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

424: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
425: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
426: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
427: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
429: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
431: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
432: , start_adv_action_set_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 429: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

425: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
426: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
427: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
429: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
431: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
432: , start_adv_action_set_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
433: , adv_action_set_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 430: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

426: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
427: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
429: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
431: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
432: , start_adv_action_set_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
433: , adv_action_set_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
434: , adv_action_set_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 431: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

427: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
429: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
431: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
432: , start_adv_action_set_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
433: , adv_action_set_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
434: , adv_action_set_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
435: , comp_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 432: , start_adv_action_set_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

428: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
429: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
431: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
432: , start_adv_action_set_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
433: , adv_action_set_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
434: , adv_action_set_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
435: , comp_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
436: , avail_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 433: , adv_action_set_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

429: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
431: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
432: , start_adv_action_set_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
433: , adv_action_set_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
434: , adv_action_set_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
435: , comp_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
436: , avail_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
437: , job_level_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 434: , adv_action_set_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

430: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
431: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
432: , start_adv_action_set_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
433: , adv_action_set_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
434: , adv_action_set_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
435: , comp_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
436: , avail_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
437: , job_level_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: , enable_auto_cand_nom_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 435: , comp_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

431: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
432: , start_adv_action_set_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
433: , adv_action_set_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
434: , adv_action_set_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
435: , comp_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
436: , avail_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
437: , job_level_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: , enable_auto_cand_nom_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: , search_min_availability NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 436: , avail_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

432: , start_adv_action_set_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
433: , adv_action_set_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
434: , adv_action_set_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
435: , comp_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
436: , avail_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
437: , job_level_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: , enable_auto_cand_nom_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: , search_min_availability NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: , search_exp_org_str_ver_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 437: , job_level_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

433: , adv_action_set_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
434: , adv_action_set_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
435: , comp_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
436: , avail_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
437: , job_level_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: , enable_auto_cand_nom_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: , search_min_availability NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: , search_exp_org_str_ver_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: , search_exp_org_hier_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 438: , enable_auto_cand_nom_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

434: , adv_action_set_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
435: , comp_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
436: , avail_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
437: , job_level_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: , enable_auto_cand_nom_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: , search_min_availability NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: , search_exp_org_str_ver_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: , search_exp_org_hier_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
442: , search_exp_start_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 439: , search_min_availability NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

435: , comp_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
436: , avail_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
437: , job_level_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: , enable_auto_cand_nom_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: , search_min_availability NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: , search_exp_org_str_ver_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: , search_exp_org_hier_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
442: , search_exp_start_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
443: , search_exp_start_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 440: , search_exp_org_str_ver_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

436: , avail_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
437: , job_level_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: , enable_auto_cand_nom_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: , search_min_availability NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: , search_exp_org_str_ver_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: , search_exp_org_hier_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
442: , search_exp_start_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
443: , search_exp_start_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
444: , search_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 441: , search_exp_org_hier_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

437: , job_level_match_weighting NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: , enable_auto_cand_nom_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: , search_min_availability NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: , search_exp_org_str_ver_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: , search_exp_org_hier_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
442: , search_exp_start_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
443: , search_exp_start_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
444: , search_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
445: , search_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 442: , search_exp_start_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

438: , enable_auto_cand_nom_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: , search_min_availability NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: , search_exp_org_str_ver_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: , search_exp_org_hier_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
442: , search_exp_start_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
443: , search_exp_start_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
444: , search_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
445: , search_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
446: , search_min_candidate_score NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 443: , search_exp_start_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

439: , search_min_availability NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: , search_exp_org_str_ver_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: , search_exp_org_hier_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
442: , search_exp_start_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
443: , search_exp_start_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
444: , search_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
445: , search_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
446: , search_min_candidate_score NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: , expenditure_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 444: , search_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

440: , search_exp_org_str_ver_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: , search_exp_org_hier_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
442: , search_exp_start_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
443: , search_exp_start_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
444: , search_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
445: , search_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
446: , search_min_candidate_score NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: , expenditure_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: , expenditure_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 445: , search_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

441: , search_exp_org_hier_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
442: , search_exp_start_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
443: , search_exp_start_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
444: , search_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
445: , search_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
446: , search_min_candidate_score NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: , expenditure_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: , expenditure_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: , expenditure_organization_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 446: , search_min_candidate_score NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

442: , search_exp_start_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
443: , search_exp_start_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
444: , search_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
445: , search_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
446: , search_min_candidate_score NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: , expenditure_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: , expenditure_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: , expenditure_organization_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: , expenditure_organization_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 447: , expenditure_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

443: , search_exp_start_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
444: , search_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
445: , search_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
446: , search_min_candidate_score NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: , expenditure_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: , expenditure_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: , expenditure_organization_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: , expenditure_organization_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
451: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 448: , expenditure_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

444: , search_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
445: , search_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
446: , search_min_candidate_score NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: , expenditure_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: , expenditure_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: , expenditure_organization_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: , expenditure_organization_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
451: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 449: , expenditure_organization_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

445: , search_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
446: , search_min_candidate_score NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: , expenditure_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: , expenditure_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: , expenditure_organization_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: , expenditure_organization_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
451: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: , fcst_job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 450: , expenditure_organization_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

446: , search_min_candidate_score NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: , expenditure_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: , expenditure_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: , expenditure_organization_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: , expenditure_organization_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
451: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: , fcst_job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: , fcst_job_group_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 451: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

447: , expenditure_org_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: , expenditure_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: , expenditure_organization_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: , expenditure_organization_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
451: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: , fcst_job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: , fcst_job_group_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
455: , fcst_job_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 452: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

448: , expenditure_org_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: , expenditure_organization_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: , expenditure_organization_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
451: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: , fcst_job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: , fcst_job_group_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
455: , fcst_job_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
456: , fcst_job_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 453: , fcst_job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

449: , expenditure_organization_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: , expenditure_organization_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
451: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: , fcst_job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: , fcst_job_group_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
455: , fcst_job_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
456: , fcst_job_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 454: , fcst_job_group_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

450: , expenditure_organization_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
451: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: , fcst_job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: , fcst_job_group_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
455: , fcst_job_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
456: , fcst_job_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 455: , fcst_job_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

451: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: , fcst_job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: , fcst_job_group_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
455: , fcst_job_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
456: , fcst_job_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 456: , fcst_job_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

452: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: , fcst_job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: , fcst_job_group_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
455: , fcst_job_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
456: , fcst_job_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
460: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 457: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

453: , fcst_job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: , fcst_job_group_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
455: , fcst_job_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
456: , fcst_job_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
460: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
461: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 458: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

454: , fcst_job_group_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
455: , fcst_job_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
456: , fcst_job_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
460: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
461: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
462: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 459: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

455: , fcst_job_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
456: , fcst_job_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
460: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
461: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
462: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
463: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 460: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

456: , fcst_job_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
460: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
461: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
462: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
463: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
464: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 461: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

457: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
460: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
461: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
462: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
463: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
464: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
465: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 462: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

458: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
460: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
461: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
462: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
463: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
464: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
465: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
466: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 463: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

459: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
460: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
461: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
462: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
463: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
464: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
465: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
466: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
467: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 464: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

460: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
461: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
462: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
463: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
464: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
465: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
466: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
467: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
468: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 465: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

461: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
462: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
463: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
464: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
465: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
466: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
467: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
468: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
469: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 466: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

462: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
463: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
464: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
465: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
466: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
467: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
468: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
469: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
470: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 467: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

463: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
464: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
465: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
466: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
467: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
468: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
469: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
470: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
471: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 468: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

464: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
465: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
466: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
467: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
468: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
469: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
470: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
471: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
472: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 469: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

465: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
466: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
467: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
468: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
469: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
470: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
471: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
472: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
473: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 470: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

466: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
467: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
468: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
469: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
470: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
471: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
472: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
473: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
474: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 471: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

467: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
468: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
469: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
470: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
471: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
472: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
473: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
474: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
475: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 472: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

468: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
469: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
470: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
471: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
472: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
473: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
474: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
475: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
476: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 473: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

469: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
470: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
471: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
472: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
473: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
474: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
475: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
476: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
477: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 474: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

470: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
471: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
472: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
473: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
474: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
475: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
476: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
477: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
478: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 475: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

471: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
472: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
473: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
474: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
475: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
476: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
477: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
478: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
479: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 476: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

472: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
473: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
474: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
475: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
476: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
477: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
478: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
479: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
480: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 477: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

473: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
474: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
475: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
476: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
477: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
478: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
479: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
480: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
481: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 478: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

474: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
475: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
476: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
477: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
478: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
479: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
480: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
481: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
482: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 479: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

475: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
476: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
477: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
478: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
479: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
480: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
481: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
482: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 480: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

476: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
477: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
478: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
479: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
480: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
481: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
482: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
484: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 481: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

477: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
478: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
479: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
480: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
481: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
482: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
484: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
485: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 482: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

478: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
479: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
480: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
481: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
482: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
484: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
485: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
486: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 483: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

479: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
480: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
481: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
482: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
484: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
485: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
486: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
487: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 484: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

480: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
481: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
482: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
484: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
485: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
486: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
487: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
488: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 485: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

481: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
482: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
484: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
485: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
486: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
487: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
488: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
489: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 486: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

482: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
484: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
485: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
486: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
487: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
488: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
489: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
490: , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 487: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

483: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
484: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
485: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
486: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
487: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
488: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
489: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
490: , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
491: , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 488: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

484: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
485: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
486: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
487: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
488: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
489: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
490: , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
491: , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
492: );

Line 489: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

485: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
486: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
487: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
488: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
489: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
490: , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
491: , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
492: );
493:

Line 490: , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

486: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
487: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
488: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
489: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
490: , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
491: , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
492: );
493:
494: -- This table type is used for passing the multiple requirements information to APIs.

Line 491: , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

487: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
488: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
489: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
490: , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
491: , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
492: );
493:
494: -- This table type is used for passing the multiple requirements information to APIs.
495: /*

Line 773: assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

769: */
770: -- This record type is used for passing the assignment information to APIs.
771: TYPE ASSIGNMENT_IN_REC_TYPE IS RECORD
772: (
773: assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
774: , assignment_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
775: , assignment_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
776: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
777: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 774: , assignment_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

770: -- This record type is used for passing the assignment information to APIs.
771: TYPE ASSIGNMENT_IN_REC_TYPE IS RECORD
772: (
773: assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
774: , assignment_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
775: , assignment_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
776: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
777: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
778: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 775: , assignment_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

771: TYPE ASSIGNMENT_IN_REC_TYPE IS RECORD
772: (
773: assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
774: , assignment_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
775: , assignment_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
776: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
777: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
778: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
779: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 776: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

772: (
773: assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
774: , assignment_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
775: , assignment_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
776: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
777: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
778: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
779: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
780: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 777: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

773: assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
774: , assignment_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
775: , assignment_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
776: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
777: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
778: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
779: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
780: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
781: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 778: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

774: , assignment_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
775: , assignment_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
776: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
777: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
778: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
779: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
780: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
781: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
782: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 779: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

775: , assignment_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
776: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
777: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
778: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
779: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
780: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
781: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
782: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
783: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 780: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

776: , project_role_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
777: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
778: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
779: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
780: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
781: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
782: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
783: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
784: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 781: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

777: , project_role_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
778: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
779: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
780: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
781: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
782: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
783: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
784: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
785: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 782: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

778: , project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
779: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
780: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
781: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
782: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
783: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
784: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
785: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
786: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 783: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

779: , project_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
780: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
781: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
782: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
783: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
784: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
785: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
786: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
787: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 784: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

780: , project_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
781: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
782: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
783: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
784: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
785: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
786: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
787: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
788: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 785: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

781: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
782: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
783: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
784: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
785: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
786: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
787: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
788: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
789: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 786: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

782: , staffing_owner_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
783: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
784: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
785: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
786: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
787: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
788: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
789: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
790: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 787: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

783: , staffing_priority_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
784: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
785: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
786: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
787: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
788: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
789: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
790: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
791: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 788: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

784: , staffing_priority_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
785: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
786: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
787: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
788: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
789: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
790: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
791: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
792: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 789: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

785: , project_subteam_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
786: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
787: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
788: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
789: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
790: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
791: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
792: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
793: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 790: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

786: , project_subteam_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
787: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
788: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
789: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
790: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
791: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
792: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
793: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
794: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 791: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

787: , location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
788: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
789: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
790: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
791: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
792: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
793: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
794: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
795: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 792: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

788: , location_country_code VARCHAR2(2) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
789: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
790: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
791: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
792: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
793: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
794: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
795: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
796: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 793: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

789: , location_country_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
790: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
791: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
792: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
793: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
794: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
795: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
796: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
797: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 794: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

790: , location_region VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
791: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
792: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
793: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
794: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
795: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
796: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
797: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
798: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 795: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

791: , location_city VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
792: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
793: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
794: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
795: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
796: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
797: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
798: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
799: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 796: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

792: , description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
793: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
794: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
795: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
796: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
797: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
798: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
799: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
800: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 797: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

793: , additional_information VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
794: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
795: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
796: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
797: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
798: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
799: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
800: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
801: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 798: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

794: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
795: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
796: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
797: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
798: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
799: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
800: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
801: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
802: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 799: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

795: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
796: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
797: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
798: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
799: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
800: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
801: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
802: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
803: , resource_calendar_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 800: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

796: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
797: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
798: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
799: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
800: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
801: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
802: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
803: , resource_calendar_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
804: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 801: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

797: , status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
798: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
799: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
800: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
801: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
802: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
803: , resource_calendar_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
804: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
805: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 802: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

798: --, resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
799: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
800: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
801: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
802: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
803: , resource_calendar_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
804: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
805: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
806: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 803: , resource_calendar_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

799: --, budget_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
800: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
801: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
802: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
803: , resource_calendar_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
804: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
805: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
806: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
807: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 804: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

800: , calendar_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
801: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
802: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
803: , resource_calendar_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
804: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
805: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
806: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
807: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
808: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 805: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

801: , calendar_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
802: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
803: , resource_calendar_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
804: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
805: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
806: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
807: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
808: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
809: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 806: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

802: , calendar_name VARCHAR2(50) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
803: , resource_calendar_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
804: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
805: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
806: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
807: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
808: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
809: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
810: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 807: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

803: , resource_calendar_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
804: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
805: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
806: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
807: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
808: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
809: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
810: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
811: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 808: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

804: , expenditure_type_class VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
805: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
806: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
807: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
808: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
809: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
810: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
811: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
812: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 809: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

805: , expenditure_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
806: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
807: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
808: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
809: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
810: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
811: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
812: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
813: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 810: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

806: , work_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
807: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
808: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
809: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
810: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
811: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
812: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
813: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
814: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 811: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

807: , work_type_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
808: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
809: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
810: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
811: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
812: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
813: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
814: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
815: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 812: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

808: , bill_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
809: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
810: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
811: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
812: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
813: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
814: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
815: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
816: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 813: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

809: , bill_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
810: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
811: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
812: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
813: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
814: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
815: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
816: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
817: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 814: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

810: , bill_rate_curr_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
811: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
812: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
813: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
814: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
815: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
816: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
817: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
818: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 815: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

811: , markup_percent_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
812: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
813: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
814: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
815: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
816: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
817: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
818: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
819: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 816: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

812: , discount_percentage NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
813: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
814: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
815: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
816: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
817: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
818: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
819: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
820: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 817: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

813: , rate_disc_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
814: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
815: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
816: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
817: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
818: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
819: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
820: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
821: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 818: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

814: , tp_rate_option VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
815: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
816: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
817: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
818: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
819: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
820: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
821: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
822: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 819: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

815: , tp_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
816: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
817: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
818: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
819: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
820: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
821: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
822: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
823: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 820: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

816: , tp_currency_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
817: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
818: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
819: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
820: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
821: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
822: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
823: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
824: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 821: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

817: , tp_calc_base_code_override VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
818: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
819: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
820: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
821: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
822: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
823: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
824: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
825: , auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 822: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

818: , tp_percent_applied_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
819: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
820: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
821: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
822: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
823: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
824: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
825: , auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
826: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 823: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

819: , extension_possible VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
820: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
821: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
822: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
823: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
824: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
825: , auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
826: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
827: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 824: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

820: , expense_owner VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
821: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
822: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
823: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
824: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
825: , auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
826: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
827: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
828: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 825: , auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

821: , expense_limit NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
822: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
823: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
824: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
825: , auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
826: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
827: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
828: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
829: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 826: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

822: , orig_system_code VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
823: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
824: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
825: , auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
826: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
827: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
828: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
829: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
830: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 827: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

823: , orig_system_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
824: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
825: , auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
826: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
827: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
828: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
829: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
830: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
831: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 828: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

824: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
825: , auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
826: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
827: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
828: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
829: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
830: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
831: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
832: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 829: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

825: , auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
826: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
827: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
828: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
829: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
830: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
831: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
832: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
833: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 830: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

826: , attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
827: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
828: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
829: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
830: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
831: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
832: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
833: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
834: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 831: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

827: , attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
828: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
829: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
830: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
831: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
832: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
833: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
834: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
835: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 832: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

828: , attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
829: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
830: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
831: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
832: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
833: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
834: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
835: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
836: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 833: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

829: , attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
830: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
831: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
832: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
833: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
834: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
835: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
836: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
837: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 834: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

830: , attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
831: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
832: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
833: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
834: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
835: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
836: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
837: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
838: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 835: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

831: , attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
832: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
833: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
834: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
835: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
836: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
837: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
838: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
839: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 836: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

832: , attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
833: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
834: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
835: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
836: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
837: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
838: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
839: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
840: , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 837: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

833: , attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
834: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
835: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
836: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
837: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
838: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
839: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
840: , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
841: , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 838: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

834: , attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
835: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
836: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
837: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
838: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
839: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
840: , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
841: , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
842: );

Line 839: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

835: , attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
836: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
837: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
838: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
839: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
840: , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
841: , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
842: );
843:

Line 840: , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

836: , attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
837: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
838: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
839: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
840: , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
841: , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
842: );
843:
844: -- This table type is used for passing the multiple assignments information to APIs.

Line 841: , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

837: , attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
838: , attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
839: , attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
840: , attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
841: , attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
842: );
843:
844: -- This table type is used for passing the multiple assignments information to APIs.
845: /*

Line 909: source_requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

905: * Reference:pa_project_assignments.record_version_number
906: */
907: TYPE STAFF_REQUIREMENT_REC_TYPE IS RECORD
908: (
909: source_requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
910: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
911: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
912: , assignment_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: , assignment_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 910: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

906: */
907: TYPE STAFF_REQUIREMENT_REC_TYPE IS RECORD
908: (
909: source_requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
910: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
911: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
912: , assignment_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: , assignment_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: , unfilled_assign_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 911: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

907: TYPE STAFF_REQUIREMENT_REC_TYPE IS RECORD
908: (
909: source_requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
910: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
911: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
912: , assignment_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: , assignment_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: , unfilled_assign_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: , unfilled_assign_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 912: , assignment_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

908: (
909: source_requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
910: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
911: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
912: , assignment_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: , assignment_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: , unfilled_assign_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: , unfilled_assign_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: , remaining_candidate_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 913: , assignment_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

909: source_requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
910: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
911: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
912: , assignment_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: , assignment_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: , unfilled_assign_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: , unfilled_assign_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: , remaining_candidate_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 914: , unfilled_assign_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

910: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
911: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
912: , assignment_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: , assignment_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: , unfilled_assign_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: , unfilled_assign_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: , remaining_candidate_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 915: , unfilled_assign_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

911: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
912: , assignment_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: , assignment_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: , unfilled_assign_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: , unfilled_assign_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: , remaining_candidate_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
919: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 916: , remaining_candidate_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

912: , assignment_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: , assignment_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: , unfilled_assign_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: , unfilled_assign_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: , remaining_candidate_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
919: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
920: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 917: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

913: , assignment_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: , unfilled_assign_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: , unfilled_assign_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: , remaining_candidate_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
919: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
920: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
921: );

Line 918: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

914: , unfilled_assign_status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: , unfilled_assign_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: , remaining_candidate_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
919: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
920: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
921: );
922:

Line 919: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

915: , unfilled_assign_status_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: , remaining_candidate_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
919: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
920: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
921: );
922:
923:

Line 920: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

916: , remaining_candidate_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
919: , start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
920: , end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
921: );
922:
923:
924: -- This table type is used for passing the required parameters for staff requirement APIs

Line 973: requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

969: * Reference: per_competence_elements.object_version_number
970: *
971: */
972: TYPE COMPETENCE_IN_REC_TYPE IS RECORD(
973: requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
974: , competence_element_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
975: , competence_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
976: , competence_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
977: , competence_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 974: , competence_element_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

970: *
971: */
972: TYPE COMPETENCE_IN_REC_TYPE IS RECORD(
973: requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
974: , competence_element_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
975: , competence_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
976: , competence_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
977: , competence_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
978: , rating_level_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 975: , competence_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

971: */
972: TYPE COMPETENCE_IN_REC_TYPE IS RECORD(
973: requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
974: , competence_element_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
975: , competence_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
976: , competence_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
977: , competence_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
978: , rating_level_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
979: , rating_level_value NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 976: , competence_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

972: TYPE COMPETENCE_IN_REC_TYPE IS RECORD(
973: requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
974: , competence_element_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
975: , competence_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
976: , competence_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
977: , competence_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
978: , rating_level_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
979: , rating_level_value NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
980: , mandatory_flag VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 977: , competence_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

973: requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
974: , competence_element_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
975: , competence_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
976: , competence_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
977: , competence_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
978: , rating_level_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
979: , rating_level_value NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
980: , mandatory_flag VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
981: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 978: , rating_level_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

974: , competence_element_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
975: , competence_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
976: , competence_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
977: , competence_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
978: , rating_level_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
979: , rating_level_value NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
980: , mandatory_flag VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
981: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
982: );

Line 979: , rating_level_value NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

975: , competence_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
976: , competence_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
977: , competence_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
978: , rating_level_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
979: , rating_level_value NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
980: , mandatory_flag VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
981: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
982: );
983:

Line 980: , mandatory_flag VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

976: , competence_name VARCHAR2(700) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
977: , competence_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
978: , rating_level_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
979: , rating_level_value NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
980: , mandatory_flag VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
981: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
982: );
983:
984:

Line 981: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

977: , competence_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
978: , rating_level_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
979: , rating_level_value NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
980: , mandatory_flag VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
981: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
982: );
983:
984:
985: -- This table is used to pass the required parameters for competence APIs.

Line 1042: candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1038: * Reference: pa_candidates.record_version_number
1039: */
1040: TYPE CANDIDATE_IN_REC_TYPE IS RECORD
1041: (
1042: candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1043: , requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1044: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1045: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1046: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 1043: , requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1039: */
1040: TYPE CANDIDATE_IN_REC_TYPE IS RECORD
1041: (
1042: candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1043: , requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1044: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1045: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1046: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1047: , nomination_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 1044: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1040: TYPE CANDIDATE_IN_REC_TYPE IS RECORD
1041: (
1042: candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1043: , requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1044: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1045: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1046: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1047: , nomination_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1048: , ranking NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1045: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1041: (
1042: candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1043: , requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1044: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1045: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1046: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1047: , nomination_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1048: , ranking NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1049: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 1046: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1042: candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1043: , requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1044: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1045: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1046: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1047: , nomination_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1048: , ranking NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1049: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1050: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1047: , nomination_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1043: , requirement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1044: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1045: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1046: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1047: , nomination_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1048: , ranking NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1049: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1050: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1051: );

Line 1048: , ranking NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1044: , resource_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1045: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1046: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1047: , nomination_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1048: , ranking NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1049: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1050: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1051: );
1052:

Line 1049: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1045: , person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1046: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1047: , nomination_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1048: , ranking NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1049: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1050: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1051: );
1052:
1053:

Line 1050: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1046: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1047: , nomination_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1048: , ranking NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1049: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1050: , record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1051: );
1052:
1053:
1054: -- This table is used to pass the required parameters for candidate APIs.

Line 1086: candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1082: * Reference: pa_candidate_reviews.review_comments
1083: */
1084: TYPE CANDIDATE_LOG_REC_TYPE IS RECORD
1085: (
1086: candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1087: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1088: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1089: , review_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1090: );

Line 1087: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1083: */
1084: TYPE CANDIDATE_LOG_REC_TYPE IS RECORD
1085: (
1086: candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1087: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1088: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1089: , review_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1090: );
1091:

Line 1088: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1084: TYPE CANDIDATE_LOG_REC_TYPE IS RECORD
1085: (
1086: candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1087: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1088: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1089: , review_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1090: );
1091:
1092: -- This table is used to pass the required parameters for candidate log APIs.

Line 1089: , review_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1085: (
1086: candidate_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1087: , status_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1088: , change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1089: , review_comments VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1090: );
1091:
1092: -- This table is used to pass the required parameters for candidate log APIs.
1093: /*

Line 1120: assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1116: *
1117: */
1118: TYPE SUBMIT_ASSIGNMENT_IN_REC_TYPE IS RECORD
1119: (
1120: assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1121: ,auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1122: ,apr_person_id_1 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1123: ,apr_person_id_2 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1124: ,note_to_approver VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 1121: ,auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1117: */
1118: TYPE SUBMIT_ASSIGNMENT_IN_REC_TYPE IS RECORD
1119: (
1120: assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1121: ,auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1122: ,apr_person_id_1 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1123: ,apr_person_id_2 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1124: ,note_to_approver VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1125: ,record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1122: ,apr_person_id_1 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1118: TYPE SUBMIT_ASSIGNMENT_IN_REC_TYPE IS RECORD
1119: (
1120: assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1121: ,auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1122: ,apr_person_id_1 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1123: ,apr_person_id_2 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1124: ,note_to_approver VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1125: ,record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1126: );

Line 1123: ,apr_person_id_2 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1119: (
1120: assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1121: ,auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1122: ,apr_person_id_1 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1123: ,apr_person_id_2 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1124: ,note_to_approver VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1125: ,record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1126: );
1127:

Line 1124: ,note_to_approver VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1120: assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1121: ,auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1122: ,apr_person_id_1 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1123: ,apr_person_id_2 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1124: ,note_to_approver VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1125: ,record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1126: );
1127:
1128: /*

Line 1125: ,record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1121: ,auto_approve VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1122: ,apr_person_id_1 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1123: ,apr_person_id_2 NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1124: ,note_to_approver VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1125: ,record_version_number NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1126: );
1127:
1128: /*
1129: * It is table of record type SUBMIT_ASSIGNMENT_IN_REC_TYPE.