eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_VALIDATIONSETS_CALLS_PUB dependencies on IBY_PAYMENTS_ALL

Line 591: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

587: *---------------------------------------------------------------------*/
588: PROCEDURE P_CITI_BE_EFT_DOM_PMT (
589: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
590: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
591: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
592: p_is_online_val IN VARCHAR2,
593: x_result OUT NOCOPY NUMBER)
594: IS
595:

Line 928: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

924: *---------------------------------------------------------------------*/
925: PROCEDURE P_BE_EFT_INT_PMT (
926: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
927: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
928: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
929: p_is_online_val IN VARCHAR2,
930: x_result OUT NOCOPY NUMBER)
931: IS
932:

Line 1442: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

1438: *---------------------------------------------------------------------*/
1439: PROCEDURE P_CITI_CH_EFT_DOM_PMT (
1440: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1441: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1442: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
1443: p_is_online_val IN VARCHAR2,
1444: x_result OUT NOCOPY NUMBER)
1445: IS
1446:

Line 2245: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

2241: *---------------------------------------------------------------------*/
2242: PROCEDURE P_DE_EFT_DOM_PMT (
2243: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2244: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2245: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
2246: p_is_online_val IN VARCHAR2,
2247: x_result OUT NOCOPY NUMBER)
2248: IS
2249:

Line 2639: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

2635: *---------------------------------------------------------------------*/
2636: PROCEDURE P_DE_EFT_INT_PMT (
2637: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2638: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2639: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
2640: p_is_online_val IN VARCHAR2,
2641: x_result OUT NOCOPY NUMBER)
2642: IS
2643:

Line 2932: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

2928: *---------------------------------------------------------------------*/
2929: PROCEDURE P_CITI_DK_EFT_DOM_PMT (
2930: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2931: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2932: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
2933: p_is_online_val IN VARCHAR2,
2934: x_result OUT NOCOPY NUMBER)
2935: IS
2936:

Line 3131: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

3127: *---------------------------------------------------------------------*/
3128: PROCEDURE P_CITI_ES_CHECK_DOM_PMT (
3129: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3130: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3131: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
3132: p_is_online_val IN VARCHAR2,
3133: x_result OUT NOCOPY NUMBER)
3134: IS
3135:

Line 3394: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

3390: *---------------------------------------------------------------------*/
3391: PROCEDURE P_CITI_ES_EFT_DOM_PMT (
3392: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3393: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3394: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
3395: p_is_online_val IN VARCHAR2,
3396: x_result OUT NOCOPY NUMBER)
3397: IS
3398:

Line 3857: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

3853: *---------------------------------------------------------------------*/
3854: PROCEDURE P_CITI_FR_EFT_DOM_PMT (
3855: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3856: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3857: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
3858: p_is_online_val IN VARCHAR2,
3859: x_result OUT NOCOPY NUMBER)
3860: IS
3861:

Line 4098: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

4094: *---------------------------------------------------------------------*/
4095: PROCEDURE P_CITI_GR_CHECK_DOM_PMT (
4096: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4097: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4098: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
4099: p_is_online_val IN VARCHAR2,
4100: x_result OUT NOCOPY NUMBER)
4101: IS
4102:

Line 4317: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

4313: *---------------------------------------------------------------------*/
4314: PROCEDURE P_CITI_GR_EFT_DOM_PMT (
4315: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4316: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4317: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
4318: p_is_online_val IN VARCHAR2,
4319: x_result OUT NOCOPY NUMBER)
4320: IS
4321:

Line 4506: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

4502: *---------------------------------------------------------------------*/
4503: PROCEDURE P_CITI_IE_EFT_DOM_PMT (
4504: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4505: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4506: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
4507: p_is_online_val IN VARCHAR2,
4508: x_result OUT NOCOPY NUMBER)
4509: IS
4510:

Line 4802: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

4798: *---------------------------------------------------------------------*/
4799: PROCEDURE P_CITI_IT_EFT_DOM_PMT (
4800: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4801: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4802: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
4803: p_is_online_val IN VARCHAR2,
4804: x_result OUT NOCOPY NUMBER)
4805: IS
4806:

Line 5320: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

5316: *---------------------------------------------------------------------*/
5317: PROCEDURE P_CITI_NO_EFT_DOM_PMT (
5318: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5319: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5320: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
5321: p_is_online_val IN VARCHAR2,
5322: x_result OUT NOCOPY NUMBER)
5323: IS
5324:

Line 5612: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

5608: *---------------------------------------------------------------------*/
5609: PROCEDURE P_CITI_PL_EFT_MTMS_PMT (
5610: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5611: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5612: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
5613: p_is_online_val IN VARCHAR2,
5614: x_result OUT NOCOPY NUMBER)
5615: IS
5616:

Line 5949: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

5945: *---------------------------------------------------------------------*/
5946: PROCEDURE P_PEKAO_PL_WIRE_TR_PMT (
5947: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5948: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5949: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
5950: p_is_online_val IN VARCHAR2,
5951: x_result OUT NOCOPY NUMBER)
5952: IS
5953:

Line 6457: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

6453: *---------------------------------------------------------------------*/
6454: PROCEDURE P_CITI_PT_EFT_DOM_PMT (
6455: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6456: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6457: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
6458: p_is_online_val IN VARCHAR2,
6459: x_result OUT NOCOPY NUMBER)
6460: IS
6461:

Line 6825: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

6821: *---------------------------------------------------------------------*/
6822: PROCEDURE P_CITI_SE_EFT_DOM_PMT (
6823: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6824: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6825: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
6826: p_is_online_val IN VARCHAR2,
6827: x_result OUT NOCOPY NUMBER)
6828: IS
6829:

Line 7457: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

7453: *---------------------------------------------------------------------*/
7454: PROCEDURE P_CITI_GB_EFT_DOM_PMT (
7455: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7456: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7457: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
7458: p_is_online_val IN VARCHAR2,
7459: x_result OUT NOCOPY NUMBER)
7460: IS
7461:

Line 11197: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

11193: *---------------------------------------------------------------------*/
11194: PROCEDURE VALIDATE_PAYER_IBAN(
11195: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
11196: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
11197: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
11198: p_is_online_val IN VARCHAR2,
11199: x_result OUT NOCOPY NUMBER)
11200: IS
11201:

Line 11265: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

11261: *---------------------------------------------------------------------*/
11262: PROCEDURE VALIDATE_PAYER_ADDRESS(
11263: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
11264: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
11265: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
11266: p_is_online_val IN VARCHAR2,
11267: x_result OUT NOCOPY NUMBER)
11268: IS
11269:

Line 11527: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

11523: *---------------------------------------------------------------------*/
11524: PROCEDURE VALIDATE_INT_BANK_ACC_CURR_IN (
11525: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
11526: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
11527: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
11528: p_is_online_val IN VARCHAR2,
11529: x_result OUT NOCOPY NUMBER)
11530: IS
11531:

Line 11681: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

11677: *---------------------------------------------------------------------*/
11678: PROCEDURE VALIDATE_MAX_PAYMENT_AMOUNT (
11679: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
11680: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
11681: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
11682: p_is_online_val IN VARCHAR2,
11683: x_result OUT NOCOPY NUMBER)
11684: IS
11685:

Line 12327: UPDATE IBY_PAYMENTS_ALL pmt

12323: INTO l_completion_id
12324: FROM DUAL;
12325:
12326: -- Mark all documents and payments which will be used by AP to apply validations
12327: UPDATE IBY_PAYMENTS_ALL pmt
12328: SET pmt.completed_pmts_group_id = l_completion_id
12329: WHERE pmt.payment_status IN ('INSTRUCTION_CREATED')
12330: AND pmt.payment_instruction_id = p_instruction_id
12331: AND pmt.payment_id IN

Line 12342: FROM IBY_PAYMENTS_ALL

12338: /*UPDATE IBY_DOCS_PAYABLE_ALL
12339: SET completed_pmts_group_id = l_completion_id
12340: WHERE payment_id IN
12341: (SELECT payment_id
12342: FROM IBY_PAYMENTS_ALL
12343: WHERE payment_status IN ('INSTRUCTION_CREATED')
12344: AND payment_instruction_id = p_instruction_id)
12345: AND document_status <> 'REMOVED';*/
12346:

Line 12360: UPDATE IBY_PAYMENTS_ALL pmt

12356: print_debuginfo(l_module_name, 'Core validation logic executed');
12357: END IF;
12358:
12359: -- Revert stamping of completed payments group ID for all documents and payments
12360: UPDATE IBY_PAYMENTS_ALL pmt
12361: SET pmt.completed_pmts_group_id = NULL
12362: WHERE pmt.payment_status IN ('INSTRUCTION_CREATED')
12363: AND pmt.payment_instruction_id = p_instruction_id
12364: AND pmt.payment_id IN

Line 12375: FROM IBY_PAYMENTS_ALL

12371: /*UPDATE IBY_DOCS_PAYABLE_ALL
12372: SET completed_pmts_group_id = NULL
12373: WHERE payment_id IN
12374: (SELECT payment_id
12375: FROM IBY_PAYMENTS_ALL
12376: WHERE payment_status IN ('INSTRUCTION_CREATED')
12377: AND payment_instruction_id = p_instruction_id);*/
12378:
12379: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 12502: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

12498:
12499: PROCEDURE VALIDATE_PAYER_LEGAL_ENTITY_ID(
12500: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
12501: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
12502: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
12503: p_is_online_val IN VARCHAR2,
12504: x_result OUT NOCOPY NUMBER)
12505: IS
12506: