APPS.PSP_ENC_PAYROLL_ASSIGN_PKG dependencies on PSP_ENC_PAYROLL_ASSIGNMENTS

Line 12: cursor C is select ROWID from PSP_ENC_PAYROLL_ASSIGNMENTS

8: X_ENC_PAYROLL_ID in NUMBER,
9: X_ASSIGNMENT_ID in NUMBER,
10: X_MODE in VARCHAR2 default 'R'
11: ) is
12: cursor C is select ROWID from PSP_ENC_PAYROLL_ASSIGNMENTS
13: where ENC_PAYROLL_ASSIGNMENT_ID = X_ENC_PAYROLL_ASSIGNMENT_ID;
14: X_LAST_UPDATE_DATE DATE;
15: X_LAST_UPDATED_BY NUMBER;
16: X_LAST_UPDATE_LOGIN NUMBER;

Line 35: insert into PSP_ENC_PAYROLL_ASSIGNMENTS (

31: else
32: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
33: app_exception.raise_exception;
34: end if;
35: insert into PSP_ENC_PAYROLL_ASSIGNMENTS (
36: ENC_PAYROLL_ASSIGNMENT_ID,
37: BUSINESS_GROUP_ID,
38: SET_OF_BOOKS_ID,
39: ENC_PAYROLL_ID,

Line 81: from PSP_ENC_PAYROLL_ASSIGNMENTS

77: BUSINESS_GROUP_ID,
78: SET_OF_BOOKS_ID,
79: ENC_PAYROLL_ID,
80: ASSIGNMENT_ID
81: from PSP_ENC_PAYROLL_ASSIGNMENTS
82: where ENC_PAYROLL_ASSIGNMENT_ID = X_ENC_PAYROLL_ASSIGNMENT_ID
83: for update of ENC_PAYROLL_ASSIGNMENT_ID nowait;
84: tlinfo c1%rowtype;
85:

Line 139: update PSP_ENC_PAYROLL_ASSIGNMENTS set

135: else
136: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
137: app_exception.raise_exception;
138: end if;
139: update PSP_ENC_PAYROLL_ASSIGNMENTS set
140: BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
141: SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID,
142: ENC_PAYROLL_ID = X_ENC_PAYROLL_ID,
143: ASSIGNMENT_ID = X_ASSIGNMENT_ID,

Line 163: cursor c1 is select rowid from PSP_ENC_PAYROLL_ASSIGNMENTS

159: X_ENC_PAYROLL_ID in NUMBER,
160: X_ASSIGNMENT_ID in NUMBER,
161: X_MODE in VARCHAR2 default 'R'
162: ) is
163: cursor c1 is select rowid from PSP_ENC_PAYROLL_ASSIGNMENTS
164: where ENC_PAYROLL_ASSIGNMENT_ID = X_ENC_PAYROLL_ASSIGNMENT_ID
165: ;
166: dummy c1%rowtype;
167: begin

Line 196: delete from PSP_ENC_PAYROLL_ASSIGNMENTS

192: procedure DELETE_ROW (
193: X_ENC_PAYROLL_ASSIGNMENT_ID in NUMBER
194: ) is
195: begin
196: delete from PSP_ENC_PAYROLL_ASSIGNMENTS
197: where ENC_PAYROLL_ASSIGNMENT_ID = X_ENC_PAYROLL_ASSIGNMENT_ID;
198: if (sql%notfound) then
199: raise no_data_found;
200: end if;