[Home] [Help]
PACKAGE: APPS.PER_STARTUP_PERSON_TYPES_PKG
Source
1 package PER_STARTUP_PERSON_TYPES_PKG AUTHID CURRENT_USER as
2 /* $Header: pespt01t.pkh 115.5 2002/12/09 10:53:04 eumenyio ship $ */
3 g_firstrun varchar2(10) := 'Y';
4 procedure POPULATE_KEY (
5 p_seeded_person_type_key in varchar2,
6 p_user_person_type in varchar2,
7 p_system_person_type in varchar2);
8
9 procedure INSERT_ROW (
10 X_ROWID in out nocopy VARCHAR2,
11 X_SEEDED_PERSON_TYPE_KEY in VARCHAR2,
12 X_DEFAULT_FLAG in VARCHAR2,
13 X_SYSTEM_PERSON_TYPE in VARCHAR2,
14 X_CURRENT_APPLICANT_FLAG in VARCHAR2,
15 X_CURRENT_EMP_OR_APL_FLAG in VARCHAR2,
16 X_CURRENT_EMPLOYEE_FLAG in VARCHAR2,
17 X_USER_PERSON_TYPE in VARCHAR2,
18 X_CREATION_DATE in DATE,
19 X_CREATED_BY in NUMBER,
20 X_LAST_UPDATE_DATE in DATE,
21 X_LAST_UPDATED_BY in NUMBER,
22 X_LAST_UPDATE_LOGIN in NUMBER);
23
24 procedure UPDATE_ROW (
25 X_FORCE_MODE in varchar2,
26 X_SEEDED_PERSON_TYPE_KEY in VARCHAR2,
27 X_DEFAULT_FLAG in VARCHAR2,
28 X_SYSTEM_PERSON_TYPE in VARCHAR2,
29 X_CURRENT_APPLICANT_FLAG in VARCHAR2,
30 X_CURRENT_EMP_OR_APL_FLAG in VARCHAR2,
31 X_CURRENT_EMPLOYEE_FLAG in VARCHAR2,
32 X_USER_PERSON_TYPE in VARCHAR2,
33 X_LAST_UPDATE_DATE in DATE,
34 X_LAST_UPDATED_BY in NUMBER,
35 X_LAST_UPDATE_LOGIN in NUMBER);
36
37 procedure DELETE_ROW (
38 X_SEEDED_PERSON_TYPE_KEY in VARCHAR2
39 );
40 procedure LOAD_ROW (
41 x_Upload_mode in varchar2,
42 X_SEEDED_PERSON_TYPE_KEY in varchar2,
43 X_DEFAULT_FLAG in VARCHAR2,
44 X_SYSTEM_PERSON_TYPE in VARCHAR2,
45 X_CURRENT_APPLICANT_FLAG in VARCHAR2,
46 X_CURRENT_EMP_OR_APL_FLAG in VARCHAR2,
47 X_CURRENT_EMPLOYEE_FLAG in VARCHAR2,
48 X_LAST_UPDATE_DATE in varchar2,
49 X_USER_PERSON_TYPE in VARCHAR2
50 );
51
52 procedure TRANSLATE_ROW (
53 X_SEEDED_PERSON_TYPE_KEY in varchar2,
54 X_USER_PERSON_TYPE in VARCHAR2,
55 X_LAST_UPDATE_DATE in varchar2);
56
57 function validate_upload (
58 p_Upload_mode in varchar2,
59 p_Table_name in varchar2,
60 p_new_row_updated_by in varchar2,
61 p_new_row_update_date in date,
62 p_Table_key_name in varchar2,
63 p_table_key_value in varchar2)
64 return boolean;
65
66
67 PROCEDURE data_upgrade;
68
69 procedure ADD_LANGUAGE;
70 end PER_STARTUP_PERSON_TYPES_PKG;