APPS.PA_EX_PAY_UTILS dependencies on PA_PAY_EXTERNAL_PAYROLL

Line 33: FROM pa_pay_external_payroll

29: IS
30:
31: CURSOR c IS
32: SELECT ROWID
33: FROM pa_pay_external_payroll
34: WHERE payroll_id = x_payroll_id;
35:
36:
37: BEGIN

Line 39: INSERT INTO pa_pay_external_payroll

35:
36:
37: BEGIN
38:
39: INSERT INTO pa_pay_external_payroll
40: (
41: BUSINESS_GROUP_ID,
42: PAYROLL_ID,
43: PAYROLL_NAME,

Line 59: pa_pay_external_payroll_s.NEXTVAL,

55: )
56: VALUES
57: (
58: X_BUSINESS_GROUP_ID,
59: pa_pay_external_payroll_s.NEXTVAL,
60: X_PAYROLL_NAME,
61: X_EFFECTIVE_START_DATE,
62: X_EFFECTIVE_END_DATE,
63: X_PAYROLL_PROVIDER_NAME,

Line 108: FROM pa_pay_external_payroll

104: )
105: IS
106: CURSOR c1 IS
107: SELECT *
108: FROM pa_pay_external_payroll
109: WHERE payroll_id = x_payroll_id
110: FOR UPDATE OF payroll_id NOWAIT;
111:
112: Recinfo c1%ROWTYPE;

Line 188: UPDATE pa_pay_external_payroll

184: IS
185:
186: BEGIN
187:
188: UPDATE pa_pay_external_payroll
189: SET BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
190: PAYROLL_NAME = X_PAYROLL_NAME,
191: EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE,
192: EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE,

Line 219: DELETE FROM pa_pay_external_payroll

215: X_PAYROLL_ID in NUMBER
216: )
217: IS
218: BEGIN
219: DELETE FROM pa_pay_external_payroll
220: WHERE payroll_id = x_payroll_id;
221:
222: IF (SQL%NOTFOUND) THEN
223: RAISE NO_DATA_FOUND;