eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.HRDPP_CREATE_US_APPLICANT

Source


1 package hrdpp_CREATE_US_APPLICANT as
2 /*
3  * Generated by hr_pump_meta_mapper at: 2007/01/04 02:01:50
4  * Generated for API: HR_APPLICANT_API.CREATE_US_APPLICANT
5  */
6 --
7 g_generator_version constant varchar2(128) default '$Revision: 120.4  $';
8 --
9 
10 function dc(p in date) return varchar2;
11 pragma restrict_references(dc,WNDS);
12 
13 function d(p in varchar2) return date;
14 pragma restrict_references(d,WNDS);
15 function n(p in varchar2) return number;
16 pragma restrict_references(n,WNDS);
17 function dd(p in date,i in varchar2) return varchar2;
18 pragma restrict_references(dd,WNDS);
19 function nd(p in number,i in varchar2) return varchar2;
20 pragma restrict_references(nd,WNDS);
21 --
22 procedure insert_batch_lines
23 (p_batch_id      in number
24 ,p_data_pump_batch_line_id in number default null
25 ,p_data_pump_business_grp_name in varchar2 default null
26 ,p_user_sequence in number default null
27 ,p_link_value    in number default null
28 ,P_DATE_RECEIVED in date
29 ,P_LAST_NAME in varchar2
30 ,P_SEX in varchar2 default null
31 ,P_APPLICANT_NUMBER in varchar2
32 ,P_COMMENTS in varchar2 default null
33 ,P_DATE_EMPLOYEE_DATA_VERIFIED in date default null
34 ,P_DATE_OF_BIRTH in date default null
35 ,P_EMAIL_ADDRESS in varchar2 default null
36 ,P_EXPENSE_CHECK_SEND_TO_ADDRES in varchar2 default null
37 ,P_FIRST_NAME in varchar2 default null
38 ,P_KNOWN_AS in varchar2 default null
39 ,P_MARITAL_STATUS in varchar2 default null
40 ,P_MIDDLE_NAMES in varchar2 default null
41 ,P_NATIONALITY in varchar2 default null
42 ,P_SS_NUMBER in varchar2 default null
43 ,P_PREVIOUS_LAST_NAME in varchar2 default null
44 ,P_REGISTERED_DISABLED_FLAG in varchar2 default null
45 ,P_TITLE in varchar2 default null
46 ,P_WORK_TELEPHONE in varchar2 default null
47 ,P_ATTRIBUTE_CATEGORY in varchar2 default null
48 ,P_ATTRIBUTE1 in varchar2 default null
49 ,P_ATTRIBUTE2 in varchar2 default null
50 ,P_ATTRIBUTE3 in varchar2 default null
51 ,P_ATTRIBUTE4 in varchar2 default null
52 ,P_ATTRIBUTE5 in varchar2 default null
53 ,P_ATTRIBUTE6 in varchar2 default null
54 ,P_ATTRIBUTE7 in varchar2 default null
55 ,P_ATTRIBUTE8 in varchar2 default null
56 ,P_ATTRIBUTE9 in varchar2 default null
57 ,P_ATTRIBUTE10 in varchar2 default null
58 ,P_ATTRIBUTE11 in varchar2 default null
59 ,P_ATTRIBUTE12 in varchar2 default null
60 ,P_ATTRIBUTE13 in varchar2 default null
61 ,P_ATTRIBUTE14 in varchar2 default null
62 ,P_ATTRIBUTE15 in varchar2 default null
63 ,P_ATTRIBUTE16 in varchar2 default null
64 ,P_ATTRIBUTE17 in varchar2 default null
65 ,P_ATTRIBUTE18 in varchar2 default null
66 ,P_ATTRIBUTE19 in varchar2 default null
67 ,P_ATTRIBUTE20 in varchar2 default null
68 ,P_ATTRIBUTE21 in varchar2 default null
69 ,P_ATTRIBUTE22 in varchar2 default null
70 ,P_ATTRIBUTE23 in varchar2 default null
71 ,P_ATTRIBUTE24 in varchar2 default null
72 ,P_ATTRIBUTE25 in varchar2 default null
73 ,P_ATTRIBUTE26 in varchar2 default null
74 ,P_ATTRIBUTE27 in varchar2 default null
75 ,P_ATTRIBUTE28 in varchar2 default null
76 ,P_ATTRIBUTE29 in varchar2 default null
77 ,P_ATTRIBUTE30 in varchar2 default null
78 ,P_ETHNIC_ORIGIN in varchar2 default null
79 ,P_I_9 in varchar2 default null
80 ,P_I_9_EXPIRATION_DATE in varchar2 default null
81 ,P_VETERAN_STATUS in varchar2 default null
82 ,P_NEW_HIRE in varchar2 default null
83 ,P_EXCEPTION_REASON in varchar2 default null
84 ,P_CHILD_SUPPORT_OBLIGATION in varchar2 default null
85 ,P_OPTED_FOR_MEDICARE_FLAG in varchar2 default null
86 ,P_BACKGROUND_CHECK_STATUS in varchar2 default null
87 ,P_BACKGROUND_DATE_CHECK in date default null
88 ,P_FTE_CAPACITY in number default null
89 ,P_HOLD_APPLICANT_DATE_UNTIL in date default null
90 ,P_HONORS in varchar2 default null
91 ,P_MAILSTOP in varchar2 default null
92 ,P_OFFICE_NUMBER in varchar2 default null
93 ,P_ON_MILITARY_SERVICE in varchar2 default null
94 ,P_PRE_NAME_ADJUNCT in varchar2 default null
95 ,P_PROJECTED_START_DATE in date default null
96 ,P_RESUME_EXISTS in varchar2 default null
97 ,P_RESUME_LAST_UPDATED in date default null
98 ,P_STUDENT_STATUS in varchar2 default null
99 ,P_WORK_SCHEDULE in varchar2 default null
100 ,P_SUFFIX in varchar2 default null
101 ,P_DATE_OF_DEATH in date default null
102 ,P_RECEIPT_OF_DEATH_CERT_DATE in date default null
103 ,P_COORD_BEN_MED_PLN_NO in varchar2 default null
104 ,P_COORD_BEN_NO_CVG_FLAG in varchar2 default null
105 ,P_USES_TOBACCO_FLAG in varchar2 default null
106 ,P_DPDNT_ADOPTION_DATE in date default null
107 ,P_DPDNT_VLNTRY_SVCE_FLAG in varchar2 default null
108 ,P_ORIGINAL_DATE_OF_HIRE in date default null
109 ,P_TOWN_OF_BIRTH in varchar2 default null
110 ,P_REGION_OF_BIRTH in varchar2 default null
111 ,P_COUNTRY_OF_BIRTH in varchar2 default null
112 ,P_GLOBAL_PERSON_ID in varchar2 default null
113 ,P_PARTY_ID in number default null
114 ,P_PERSON_USER_KEY in varchar2
115 ,P_ASSIGNMENT_USER_KEY in varchar2
116 ,P_APPLICATION_USER_KEY in varchar2
117 ,P_USER_PERSON_TYPE in varchar2 default null
118 ,P_LANGUAGE_CODE in varchar2 default null
119 ,P_CORRESPONDENCE_LANGUAGE in varchar2 default null
120 ,P_BENEFIT_GROUP in varchar2 default null);
121 --
122 procedure call
123 (p_business_group_id in number,
124 p_batch_line_id     in number);
125 end hrdpp_CREATE_US_APPLICANT;