[Home] [Help]
PACKAGE: APPS.PER_ASS_STATUSES_PKG
Source
1 PACKAGE PER_ASS_STATUSES_PKG AUTHID CURRENT_USER AS
2 /* $Header: peast01t.pkh 120.1.12010000.1 2008/07/28 04:12:15 appldev ship $ */
3
4 PROCEDURE UNIQUENESS_CHECK(P_USER_STATUS VARCHAR2,
5 P_BUSINESS_GROUP_ID NUMBER,
6 P_LEGISLATION_CODE VARCHAR2,
7 P_ROWID VARCHAR2,
8 P_ASSIGNMENT_STATUS_TYPE_ID NUMBER,
9 P_STARTUP_MODE VARCHAR2,
10 P_PRIMARY_FLAG VARCHAR2,
11 P_AMENDMENT VARCHAR2,
12 P_C_ACTIVE_FLAG VARCHAR2,
13 P_C_DEFAULT_FLAG VARCHAR2,
14 P_DEFAULT_FLAG VARCHAR2,
15 P_ACTIVE_FLAG VARCHAR2,
16 P_PER_SYSTEM_STATUS VARCHAR2,
17 P_MODE VARCHAR2) ;
18
19 PROCEDURE PRE_UPDATE(P_ACTIVE_FLAG VARCHAR2,
20 P_DEFAULT_FLAG VARCHAR2,
21 P_USER_STATUS VARCHAR2,
22 P_PAY_SYSTEM_STATUS VARCHAR2,
23 P_LAST_UPDATE_DATE DATE,
24 P_LAST_UPDATED_BY NUMBER,
25 P_LAST_UPDATE_LOGIN NUMBER,
26 P_CREATED_BY NUMBER,
27 P_CREATION_DATE DATE,
28 P_ASS_STATUS_TYPE_ID NUMBER,
29 P_AMENDMENT VARCHAR2) ;
30
31 PROCEDURE INSERT_AMENDS(P_ASS_STATUS_TYPE_AMEND_ID IN OUT NOCOPY NUMBER,
32 P_ASSIGNMENT_STATUS_TYPE_ID NUMBER,
33 P_BUSINESS_GROUP_ID NUMBER,
34 P_ACTIVE_FLAG VARCHAR2,
35 P_DEFAULT_FLAG VARCHAR2,
36 P_USER_STATUS VARCHAR2,
37 P_PAY_SYSTEM_STATUS VARCHAR2,
38 P_PER_SYSTEM_STATUS VARCHAR2,
39 P_LAST_UPDATE_DATE DATE,
40 P_LAST_UPDATED_BY NUMBER,
41 P_LAST_UPDATE_LOGIN NUMBER,
42 P_CREATED_BY NUMBER,
43 P_CREATION_DATE DATE);
44
45 procedure chk_dflt_per_sys_statuses
46 (
47 p_business_group_id number,
48 p_legislation_code varchar2
49 );
50
51 procedure INSERT_ROW (
52 X_ROWID in out nocopy VARCHAR2,
53 X_ASSIGNMENT_STATUS_TYPE_ID in NUMBER,
54 X_BUSINESS_GROUP_ID in NUMBER,
55 X_LEGISLATION_CODE in VARCHAR2,
56 X_ACTIVE_FLAG in VARCHAR2,
57 X_DEFAULT_FLAG in VARCHAR2,
58 X_PRIMARY_FLAG in VARCHAR2,
59 X_PAY_SYSTEM_STATUS in VARCHAR2,
60 X_PER_SYSTEM_STATUS in VARCHAR2,
61 X_USER_STATUS in VARCHAR2,
62 X_EXTERNAL_STATUS in VARCHAR2,
63 X_CREATION_DATE in DATE,
64 X_CREATED_BY in NUMBER,
65 X_LAST_UPDATE_DATE in DATE,
66 X_LAST_UPDATED_BY in NUMBER,
67 X_LAST_UPDATE_LOGIN in NUMBER);
68 procedure LOCK_ROW (
69 X_ASSIGNMENT_STATUS_TYPE_ID in NUMBER,
70 X_BUSINESS_GROUP_ID in NUMBER,
71 X_LEGISLATION_CODE in VARCHAR2,
72 X_ACTIVE_FLAG in VARCHAR2,
73 X_DEFAULT_FLAG in VARCHAR2,
74 X_PRIMARY_FLAG in VARCHAR2,
75 X_PAY_SYSTEM_STATUS in VARCHAR2,
76 X_PER_SYSTEM_STATUS in VARCHAR2,
77 X_USER_STATUS in VARCHAR2
78 );
79 procedure UPDATE_ROW (
80 X_ASSIGNMENT_STATUS_TYPE_ID in NUMBER,
81 X_BUSINESS_GROUP_ID in NUMBER,
82 X_LEGISLATION_CODE in VARCHAR2,
83 X_ACTIVE_FLAG in VARCHAR2,
84 X_DEFAULT_FLAG in VARCHAR2,
85 X_PRIMARY_FLAG in VARCHAR2,
86 X_PAY_SYSTEM_STATUS in VARCHAR2,
87 X_PER_SYSTEM_STATUS in VARCHAR2,
88 X_USER_STATUS in VARCHAR2,
89 X_EXTERNAL_STATUS in VARCHAR2,
90 X_LAST_UPDATE_DATE in DATE,
91 X_LAST_UPDATED_BY in NUMBER,
92 X_LAST_UPDATE_LOGIN in NUMBER
93 );
94 procedure DELETE_ROW (
95 X_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
96 );
97 procedure LOAD_ROW (
98 X_STATUS in VARCHAR2,
99 X_BUSINESS_GROUP_NAME in VARCHAR2,
100 X_LEGISLATION_CODE in VARCHAR2,
101 X_ACTIVE_FLAG in VARCHAR2,
102 X_DEFAULT_FLAG in VARCHAR2,
103 X_PRIMARY_FLAG in VARCHAR2,
104 X_PAY_SYSTEM_STATUS in VARCHAR2,
105 X_PER_SYSTEM_STATUS in VARCHAR2,
106 X_USER_STATUS in VARCHAR2,
107 X_OWNER in VARCHAR2,
108 X_LAST_UPDATE_DATE IN VARCHAR2 default sysdate,
109 X_CUSTOM_MODE IN VARCHAR2 default null
110 );
111 procedure TRANSLATE_ROW (
112 X_STATUS in VARCHAR2,
113 X_BUSINESS_GROUP_NAME in VARCHAR2,
114 X_LEGISLATION_CODE in VARCHAR2,
115 X_USER_STATUS in VARCHAR2,
116 X_OWNER in VARCHAR2,
117 X_LAST_UPDATE_DATE IN VARCHAR2 default sysdate,
118 X_CUSTOM_MODE IN VARCHAR2 default null
119 );
120 PROCEDURE ADD_LANGUAGE;
121
122 --------------------------------------------------------------------------------
123 PROCEDURE set_translation_globals(p_business_group_id IN NUMBER,
124 p_legislation_code IN VARCHAR2);
125 --------------------------------------------------------------------------------
126 --------------------------------------------------------------------------------
127 procedure validate_TRANSLATION (assignment_status_type_id IN number,
128 language IN varchar2,
129 user_status IN varchar2,
130 p_business_group_id IN NUMBER DEFAULT NULL);
131 --------------------------------------------------------------------------------
132 END PER_ASS_STATUSES_PKG;