APPS.HRWCDJC_PKG dependencies on PAY_JOB_WC_CODE_USAGES

Line 14: INSERT INTO PAY_JOB_WC_CODE_USAGES

10: X_JOB_ID NUMBER,
11: X_WC_CODE NUMBER) IS
12: BEGIN
13: --
14: INSERT INTO PAY_JOB_WC_CODE_USAGES
15: (STATE_CODE, BUSINESS_GROUP_ID, JOB_ID, WC_CODE)
16: VALUES
17: (X_STATE_CODE, X_BUSINESS_GROUP_ID, X_JOB_ID, X_WC_CODE);
18: --

Line 21: FROM PAY_JOB_WC_CODE_USAGES

17: (X_STATE_CODE, X_BUSINESS_GROUP_ID, X_JOB_ID, X_WC_CODE);
18: --
19: SELECT ROWID
20: INTO X_ROWID
21: FROM PAY_JOB_WC_CODE_USAGES
22: WHERE STATE_CODE = X_STATE_CODE
23: AND JOB_ID = X_JOB_ID;
24: --
25: IF (SQL%NOTFOUND) THEN

Line 40: UPDATE PAY_JOB_WC_CODE_USAGES

36: X_JOB_ID NUMBER,
37: X_WC_CODE NUMBER) IS
38: BEGIN
39: --
40: UPDATE PAY_JOB_WC_CODE_USAGES
41: SET STATE_CODE = X_STATE_CODE
42: , BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
43: , JOB_ID = X_JOB_ID
44: , WC_CODE = X_WC_CODE

Line 62: DELETE FROM PAY_JOB_WC_CODE_USAGES

58: X_JOB_ID NUMBER,
59: X_WC_CODE NUMBER) IS
60: BEGIN
61: --
62: DELETE FROM PAY_JOB_WC_CODE_USAGES
63: WHERE ROWID = X_ROWID;
64: --
65: IF (SQL%NOTFOUND) THEN
66: RAISE NO_DATA_FOUND;

Line 81: FROM PAY_JOB_WC_CODE_USAGES

77: X_WC_CODE NUMBER) IS
78: --
79: CURSOR C IS
80: SELECT *
81: FROM PAY_JOB_WC_CODE_USAGES
82: WHERE ROWID = X_ROWID
83: FOR UPDATE OF STATE_CODE NOWAIT;
84: --
85: RECINFO C%ROWTYPE;

Line 133: FROM PAY_JOB_WC_CODE_USAGES

129: l_job_exists VARCHAR2(2);
130: --
131: CURSOR DUP_JOB IS
132: SELECT 'Y'
133: FROM PAY_JOB_WC_CODE_USAGES
134: WHERE STATE_CODE = P_STATE_CODE
135: AND JOB_ID = P_JOB_ID
136: AND ((ROWID <> P_ROWID
137: AND P_ROWID IS NOT NULL)