APPS.PAY_PAYMENT_METHODS_PKG dependencies on PAY_EXTERNAL_ACCOUNTS

Line 191: UPDATE PAY_EXTERNAL_ACCOUNTS

187: CLOSE C;
188: --
189: IF (P_EXTERNAL_ACCOUNT_ID IS NOT NULL) AND (P_PRENOTE_DATE IS NOT NULL) THEN
190: --
191: UPDATE PAY_EXTERNAL_ACCOUNTS
192: SET PRENOTE_DATE = P_PRENOTE_DATE
193: WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID;
194: --
195: END IF;

Line 202: UPDATE PAY_EXTERNAL_ACCOUNTS

198: -- always want to set territory code,
199: -- update api depends on territory code remaining unchanged
200: --
201: IF (P_EXTERNAL_ACCOUNT_ID IS NOT NULL) AND (P_TERRITORY_CODE IS NOT NULL) THEN
202: UPDATE PAY_EXTERNAL_ACCOUNTS
203: SET TERRITORY_CODE = P_TERRITORY_CODE
204: WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID;
205: END IF;
206:

Line 354: UPDATE PAY_EXTERNAL_ACCOUNTS

350: PPM_INFORMATION30 = P_PPM_INFORMATION30
351: WHERE ROWID = P_ROWID;
352: IF (P_EXTERNAL_ACCOUNT_ID IS NOT NULL) THEN
353: --
354: UPDATE PAY_EXTERNAL_ACCOUNTS
355: SET PRENOTE_DATE = P_PRENOTE_DATE
356: WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID;
357: --
358: END IF;

Line 365: UPDATE PAY_EXTERNAL_ACCOUNTS

361: -- always want to set territory code,
362: -- update api depends on territory code remaining unchanged
363: --
364: IF (P_EXTERNAL_ACCOUNT_ID IS NOT NULL) AND (P_TERRITORY_CODE IS NOT NULL) THEN
365: UPDATE PAY_EXTERNAL_ACCOUNTS
366: SET TERRITORY_CODE = P_TERRITORY_CODE
367: WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID;
368: END IF;
369:

Line 503: FROM PAY_EXTERNAL_ACCOUNTS

499: WHERE ROWID = P_ROWID
500: FOR UPDATE OF PERSONAL_PAYMENT_METHOD_ID NOWAIT;
501:
502: CURSOR PRENOTE IS SELECT *
503: FROM PAY_EXTERNAL_ACCOUNTS
504: WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID
505: FOR UPDATE OF PRENOTE_DATE NOWAIT;
506:
507: RECINFO C%ROWTYPE;