DBA Data[Home] [Help]

APPS.IBY_VALIDATIONSETS_PUB dependencies on DUAL

Line 1192: select 'TRUE' into l_valid_assoc from dual where exists(

1188: -- Set this to false only if bank account exists, We do not validate if
1189: -- no bank account exists.
1190:
1191: BEGIN
1192: select 'TRUE' into l_valid_assoc from dual where exists(
1193: SELECT 'valid_assoc' FROM iby_pmt_instr_uses_all
1194: WHERE instrument_type = 'BANKACCOUNT'
1195: AND INSTRUMENT_ID = l_docs_tab(i).ext_bank_acct_id
1196: AND payment_flow = 'DISBURSEMENTS'

Line 2144: | Online validations are performed on documents individually.

2140: | invoke the same validation sets as deferred validations, but
2141: | errors are returned as warnings and status of the documents
2142: | are not affected.
2143: |
2144: | Online validations are performed on documents individually.
2145: | At the time when online validations are invoked the
2146: | payment request is not yet formed in the calling app.
2147: |
2148: | So this method is invoked for one document at a time by the

Line 3174: | validate individual fields of this record.

3170: | Initializes the instruction record from Oracle Payment's tables.
3171: |
3172: | Fields related to a payment instruction are picked up and
3173: | populated into an instruction record. The validation sets will
3174: | validate individual fields of this record.
3175: |
3176: | PARAMETERS:
3177: | IN
3178: |

Line 3915: DUAL

3911: IBY_TRANSACTION_ERRORS_S.NEXTVAL
3912: INTO
3913: l_transaction_error_id
3914: FROM
3915: DUAL
3916: ;
3917:
3918: x_docErrorRec.transaction_error_id := l_transaction_error_id;
3919:

Line 4343: DUAL

4339: IBY_TRANSACTION_ERRORS_S.NEXTVAL
4340: INTO
4341: l_transaction_error_id
4342: FROM
4343: DUAL
4344: ;
4345:
4346: x_docErrorRec.transaction_error_id := l_transaction_error_id;
4347:

Line 4854: FROM DUAL;

4850: * occurance of an event. Therefore, it should be
4851: * a sequence number.
4852: */
4853: SELECT IBY_EVENT_KEY_S.nextval INTO l_event_key
4854: FROM DUAL;
4855:
4856: IF (p_rejectionLevel = REJ_LVL_REQUEST) THEN
4857:
4858: /*