APPS.PAY_PAYMENT_METHODS_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 78: FROM PAY_PERSONAL_PAYMENT_METHODS_F

74: ) IS
75:
76: CURSOR C IS
77: SELECT ROWID
78: FROM PAY_PERSONAL_PAYMENT_METHODS_F
79: WHERE PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID;
80:
81: CURSOR C2 IS
82: SELECT pay_personal_payment_methods_s.nextval

Line 91: INSERT INTO PAY_PERSONAL_PAYMENT_METHODS_F (PERSONAL_PAYMENT_METHOD_ID,

87: OPEN C2;
88: FETCH C2 INTO P_PERSONAL_PAYMENT_METHOD_ID;
89: CLOSE C2;
90:
91: INSERT INTO PAY_PERSONAL_PAYMENT_METHODS_F (PERSONAL_PAYMENT_METHOD_ID,
92: EFFECTIVE_START_DATE,
93: EFFECTIVE_END_DATE,
94: BUSINESS_GROUP_ID,
95: EXTERNAL_ACCOUNT_ID,

Line 283: UPDATE PAY_PERSONAL_PAYMENT_METHODS_F

279: P_PPM_INFORMATION30 VARCHAR2
280: ) IS
281:
282: BEGIN
283: UPDATE PAY_PERSONAL_PAYMENT_METHODS_F
284: SET PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID,
285: EFFECTIVE_START_DATE = P_EFFECTIVE_START_DATE,
286: EFFECTIVE_END_DATE = P_EFFECTIVE_END_DATE,
287: BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID,

Line 420: DELETE FROM PAY_PERSONAL_PAYMENT_METHODS_F

416: --
417: l_after_this_date := fnd_date.date_to_canonical(p_after_this_date);
418: --
419: IF hr_payments.check_pp (to_char (P_PPM_ID), l_after_this_date) THEN
420: DELETE FROM PAY_PERSONAL_PAYMENT_METHODS_F
421: WHERE ROWID = P_ROWID;
422: ELSE
423: hr_utility.set_message('801', 'HR_6498_PAY_DEL_PREPAY');
424: hr_utility.raise_error;

Line 498: FROM PAY_PERSONAL_PAYMENT_METHODS_F

494: P_PPM_INFORMATION28 VARCHAR2,
495: P_PPM_INFORMATION29 VARCHAR2,
496: P_PPM_INFORMATION30 VARCHAR2 ) IS
497: CURSOR C IS SELECT *
498: FROM PAY_PERSONAL_PAYMENT_METHODS_F
499: WHERE ROWID = P_ROWID
500: FOR UPDATE OF PERSONAL_PAYMENT_METHOD_ID NOWAIT;
501:
502: CURSOR PRENOTE IS SELECT *

Line 589: always from the form PAYWSEPM.fmb to this proc expecting the person id to be null in PAY_PERSONAL_PAYMENT_METHODS_F */

585: OR ( (P_ASSIGNMENT_ID IS NULL)
586: AND (RECINFO.ASSIGNMENT_ID IS NULL) ) ) AND
587: /* Bug 14113683 : Commenting the check on person id as Person id can never be updated through Pay Method form.
588: So, no code is reqd to check if the person id is updated. Also we are passing the person id as null (hardcoded)
589: always from the form PAYWSEPM.fmb to this proc expecting the person id to be null in PAY_PERSONAL_PAYMENT_METHODS_F */
590: /* ( (P_PERSON_ID = RECINFO.PERSON_ID)
591: OR ( (P_PERSON_ID IS NULL)
592: AND (RECINFO.PERSON_ID IS NULL) ) ) AND */
593: ( (P_RUN_TYPE_ID = RECINFO.RUN_TYPE_ID)