APPS.PAY_RATES_PKG dependencies on PAY_RATES

Line 1: PACKAGE BODY PAY_RATES_PKG AS

1: PACKAGE BODY PAY_RATES_PKG AS
2: /* $Header: pyrat01t.pkb 115.3 2002/12/17 13:55:52 dsaxby ship $ */
3:
4: PROCEDURE INSERT_ROW(P_ROWID IN OUT NOCOPY VARCHAR2,
5: P_RATE_ID IN OUT NOCOPY NUMBER,

Line 41: SELECT PAY_RATES_S.NEXTVAL

37: P_RATE_BASIS VARCHAR2) IS
38:
39: CURSOR c1 IS
40:
41: SELECT PAY_RATES_S.NEXTVAL
42: FROM SYS.DUAL;
43:
44: CURSOR c2 IS
45:

Line 47: FROM PAY_RATES

43:
44: CURSOR c2 IS
45:
46: SELECT rowid
47: FROM PAY_RATES
48: WHERE RATE_ID = P_RATE_ID;
49:
50: BEGIN
51:

Line 59: INSERT INTO PAY_RATES (RATE_ID, BUSINESS_GROUP_ID, PARENT_SPINE_ID,

55: CLOSE c1;
56:
57:
58:
59: INSERT INTO PAY_RATES (RATE_ID, BUSINESS_GROUP_ID, PARENT_SPINE_ID,
60: NAME, RATE_TYPE, RATE_UOM, COMMENTS, REQUEST_ID,
61: PROGRAM_APPLICATION_ID, PROGRAM_ID,
62: PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY,
63: ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4,

Line 130: UPDATE PAY_RATES

126: P_ATTRIBUTE19 VARCHAR2,
127: P_ATTRIBUTE20 VARCHAR2,
128: P_RATE_BASIS VARCHAR2) IS
129: BEGIN
130: UPDATE PAY_RATES
131: SET RATE_ID = P_RATE_ID ,
132: BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID ,
133: PARENT_SPINE_ID = P_PARENT_SPINE_ID ,
134: NAME = P_NAME ,

Line 189: DELETE FROM PAY_RATES WHERE PAY_RATES.ROWID = P_ROWID;

185:
186: END IF;
187:
188: /* now delete the master */
189: DELETE FROM PAY_RATES WHERE PAY_RATES.ROWID = P_ROWID;
190:
191: /* calling database package to delete database item */
192:
193: hrdyndbi.delete_grade_spine_dict(P_RATE_ID);

Line 237: CURSOR C IS SELECT * FROM PAY_RATES WHERE ROWID = P_ROWID

233: P_MODE VARCHAR2,
234: P_RATE_BASIS VARCHAR2) IS
235:
236:
237: CURSOR C IS SELECT * FROM PAY_RATES WHERE ROWID = P_ROWID
238: FOR UPDATE OF RATE_ID NOWAIT;
239:
240: CURSOR C2 IS SELECT * FROM PAY_GRADE_RULES_F WHERE RATE_ID = P_RATE_ID
241: FOR UPDATE OF GRADE_RULE_ID NOWAIT;

Line 364: END PAY_RATES_PKG;

360:
361: END IF;
362: END LOCK_ROW;
363:
364: END PAY_RATES_PKG;