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;