[Home] [Help]
PACKAGE: APPS.PER_PERSON_TYPES_PKG
Source
1 PACKAGE PER_PERSON_TYPES_PKG AUTHID CURRENT_USER as
2 /* $Header: pedpt01t.pkh 115.6 2002/12/05 10:20:58 pkakar ship $ */
3 ------------------------------------------------------------------------------
4 /*
5 ==============================================================================
6
7 26-MAR-96 AForte Added check_duplicate_system_name which
8 is used in Form PERWSDPT - Define Person
9 Type and checks to make sure a user
10 does not enter two rows with the same
11 system name and a default of yes.
12 Bug 338753.
13
14 22-DEC-98 VTreiger Added ADD_LANGUAGE procedure.
15
16 21-APR-99 VTreiger Added MLS validation procedures.
17
18 07-JUL-99 JPBard Added LOAD_ROW and TRANSLATE_ROW procs.
19 14-NOV-00 SBirnage Added Check_Default procedure for Bug
20 1494778.
21 115.5 20-AUG-02 skota Added dbdrv commands
22 115.6 05-DEC-02 pkakar Added nocopy changes
23 ==============================================================================
24 */
25 ------------------------------------------------------------------------------
26 PROCEDURE check_duplicate_name(p_business_group_id in number,
27 p_user_person_type in varchar2,
28 p_rowid in varchar2);
29 -------------------------------------------------------------------------------
30 /*Check user doesn't set default to yes when entering a duplicate system name*/
31
32 PROCEDURE check_duplicate_system_name (p_business_group_id in number,
33 p_system_name in varchar2,
34 p_default_flag in varchar2,
35 p_rowid in varchar2);
36 -------------------------------------------------------------------------------
37 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
38 X_Person_Type_Id IN OUT NOCOPY NUMBER,
39 X_Business_Group_Id NUMBER,
40 X_Active_Flag VARCHAR2,
41 X_Default_Flag VARCHAR2,
42 X_System_Person_Type VARCHAR2,
43 X_System_Name VARCHAR2,
44 X_User_Person_Type VARCHAR2);
45
46 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
47 X_Person_Type_Id NUMBER,
48 X_Business_Group_Id NUMBER,
49 X_Active_Flag VARCHAR2,
50 X_Default_Flag VARCHAR2,
51 X_System_Person_Type VARCHAR2,
52 X_User_Person_Type VARCHAR2);
53
54 PROCEDURE Update_Row(X_Rowid VARCHAR2,
55 X_Person_Type_Id NUMBER,
56 X_Business_Group_Id NUMBER,
57 X_Active_Flag VARCHAR2,
58 X_Default_Flag VARCHAR2,
59 X_System_Person_Type VARCHAR2,
60 X_System_Name VARCHAR2,
61 X_User_Person_Type VARCHAR2);
62
63 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
64 X_Default_flag varchar2,
65 X_Person_type_Id number);
66
67 PROCEDURE Check_Delete (X_Business_Group_Id NUMBER);
68
69 PROCEDURE Check_Default (X_Business_Group_Id IN NUMBER);
70
71 PROCEDURE Check_System_Delete(X_Person_Type_Id in NUMBER);
72
73 PROCEDURE LOAD_ROW
74 (X_PERSON_TYPE in VARCHAR2
75 ,X_BUSINESS_GROUP_NAME in VARCHAR2
76 ,X_ACTIVE_FLAG in VARCHAR2
77 ,X_DEFAULT_FLAG in VARCHAR2
78 ,X_SYSTEM_PERSON_TYPE in VARCHAR2
79 ,X_USER_PERSON_TYPE in VARCHAR2
80 ,X_OWNER in VARCHAR2
81 );
82
83 PROCEDURE TRANSLATE_ROW
84 (X_PERSON_TYPE in VARCHAR2
85 ,X_BUSINESS_GROUP_NAME in VARCHAR2
86 ,X_USER_PERSON_TYPE in VARCHAR2
87 ,X_OWNER in VARCHAR2
88 );
89
90 PROCEDURE ADD_LANGUAGE;
91
92 --------------------------------------------------------------------------------
93 PROCEDURE set_translation_globals(p_business_group_id IN NUMBER,
94 p_legislation_code IN VARCHAR2);
95 --------------------------------------------------------------------------------
96 --------------------------------------------------------------------------------
97 procedure validate_TRANSLATION (person_type_id IN number,
98 language IN varchar2,
99 user_person_type IN varchar2,
100 p_business_group_id IN NUMBER DEFAULT NULL);
101 --------------------------------------------------------------------------------
102 END PER_PERSON_TYPES_PKG;