[Home] [Help]
52: *---------------------------------------------------------------------*/
53: PROCEDURE CITI_AT_EFT_DOM_PAYEE (
54: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
55: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
56: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
57: p_is_online_val IN VARCHAR2,
58: x_result OUT NOCOPY NUMBER)
59: IS
60:
155: *---------------------------------------------------------------------*/
156: PROCEDURE CITI_AT_EFT_DOM_DOC (
157: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
158: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
159: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
160: p_is_online_val IN VARCHAR2,
161: x_result OUT NOCOPY NUMBER)
162: IS
163:
225: *---------------------------------------------------------------------*/
226: PROCEDURE AT_EFT_INT_INTERNAL_BANK(
227: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
228: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
229: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
230: p_is_online_val IN VARCHAR2,
231: x_result OUT NOCOPY NUMBER)
232: IS
233:
300: *---------------------------------------------------------------------*/
301: PROCEDURE AT_EFT_INT_PAYER (
302: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
303: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
304: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
305: p_is_online_val IN VARCHAR2,
306: x_result OUT NOCOPY NUMBER)
307: IS
308:
385: *---------------------------------------------------------------------*/
386: PROCEDURE AT_EFT_INT_PAYEE(
387: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
388: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
389: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
390: p_is_online_val IN VARCHAR2,
391: x_result OUT NOCOPY NUMBER)
392: IS
393:
470: *---------------------------------------------------------------------*/
471: PROCEDURE CITI_BE_EFT_DOM_PAYEE (
472: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
473: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
474: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
475: p_is_online_val IN VARCHAR2,
476: x_result OUT NOCOPY NUMBER)
477: IS
478:
679: *---------------------------------------------------------------------*/
680: PROCEDURE BE_EFT_DOM_DOC (
681: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
682: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
683: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
684: p_is_online_val IN VARCHAR2,
685: x_result OUT NOCOPY NUMBER)
686: IS
687:
749: *---------------------------------------------------------------------*/
750: PROCEDURE BE_EFT_INT_PAYEE (
751: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
752: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
753: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
754: p_is_online_val IN VARCHAR2,
755: x_result OUT NOCOPY NUMBER)
756: IS
757:
848: *---------------------------------------------------------------------*/
849: PROCEDURE BE_EFT_INT_DOC (
850: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
851: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
852: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
853: p_is_online_val IN VARCHAR2,
854: x_result OUT NOCOPY NUMBER)
855: IS
856:
1107: *---------------------------------------------------------------------*/
1108: PROCEDURE CITI_CH_EFT_DOM_PAYEE(
1109: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1110: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1111: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1112: p_is_online_val IN VARCHAR2,
1113: x_result OUT NOCOPY NUMBER)
1114: IS
1115:
1353: *---------------------------------------------------------------------*/
1354: PROCEDURE CITI_CH_EFT_DOM_DOC (
1355: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1356: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1357: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1358: p_is_online_val IN VARCHAR2,
1359: x_result OUT NOCOPY NUMBER)
1360: IS
1361:
1507: *---------------------------------------------------------------------*/
1508: PROCEDURE CH_EFT_GEN_PAYEE (
1509: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1510: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1511: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1512: p_is_online_val IN VARCHAR2,
1513: x_result OUT NOCOPY NUMBER)
1514: IS
1515:
1601: *---------------------------------------------------------------------*/
1602: PROCEDURE CH_EFT_GEN_DOC (
1603: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1604: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1605: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1606: p_is_online_val IN VARCHAR2,
1607: x_result OUT NOCOPY NUMBER)
1608: IS
1609:
1794: *---------------------------------------------------------------------*/
1795: PROCEDURE CITI_DE_EFT_DOM_PAYEE (
1796: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1797: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1798: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1799: p_is_online_val IN VARCHAR2,
1800: x_result OUT NOCOPY NUMBER)
1801: IS
1802:
1897: *---------------------------------------------------------------------*/
1898: PROCEDURE CITI_DE_EFT_DOM_DOC (
1899: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1900: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1901: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1902: p_is_online_val IN VARCHAR2,
1903: x_result OUT NOCOPY NUMBER)
1904: IS
1905:
1967: *---------------------------------------------------------------------*/
1968: PROCEDURE DE_EFT_DOM_INTERNAL_BANK (
1969: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1970: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1971: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1972: p_is_online_val IN VARCHAR2,
1973: x_result OUT NOCOPY NUMBER)
1974: IS
1975:
2069: *---------------------------------------------------------------------*/
2070: PROCEDURE DE_EFT_DOM_PAYER (
2071: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2072: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2073: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2074: p_is_online_val IN VARCHAR2,
2075: x_result OUT NOCOPY NUMBER)
2076: IS
2077:
2139: *---------------------------------------------------------------------*/
2140: PROCEDURE DE_EFT_DOM_PAYEE (
2141: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2142: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2143: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2144: p_is_online_val IN VARCHAR2,
2145: x_result OUT NOCOPY NUMBER)
2146: IS
2147:
2309: *---------------------------------------------------------------------*/
2310: PROCEDURE DE_EFT_INT_INTERNAL_BANK (
2311: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2312: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2313: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2314: p_is_online_val IN VARCHAR2,
2315: x_result OUT NOCOPY NUMBER)
2316: IS
2317:
2411: *---------------------------------------------------------------------*/
2412: PROCEDURE DE_EFT_INT_PAYEE (
2413: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2414: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2415: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2416: p_is_online_val IN VARCHAR2,
2417: x_result OUT NOCOPY NUMBER)
2418: IS
2419:
2499: *---------------------------------------------------------------------*/
2500: PROCEDURE DE_EFT_INT_PAYER (
2501: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2502: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2503: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2504: p_is_online_val IN VARCHAR2,
2505: x_result OUT NOCOPY NUMBER)
2506: IS
2507:
2708: *---------------------------------------------------------------------*/
2709: PROCEDURE DK_EFT_DOM_DOC (
2710: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2711: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2712: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2713: p_is_online_val IN VARCHAR2,
2714: x_result OUT NOCOPY NUMBER)
2715: IS
2716:
2774: *---------------------------------------------------------------------*/
2775: PROCEDURE CITI_DK_EFT_DOM_PAYEE (
2776: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2777: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2778: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2779: p_is_online_val IN VARCHAR2,
2780: x_result OUT NOCOPY NUMBER)
2781: IS
2782:
2858: *---------------------------------------------------------------------*/
2859: PROCEDURE CITI_DK_EFT_DOM_DOC (
2860: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2861: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2862: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2863: p_is_online_val IN VARCHAR2,
2864: x_result OUT NOCOPY NUMBER)
2865: IS
2866:
3027: *---------------------------------------------------------------------*/
3028: PROCEDURE CITI_ES_CHECK_DOM_PAYEE (
3029: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3030: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3031: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3032: p_is_online_val IN VARCHAR2,
3033: x_result OUT NOCOPY NUMBER)
3034: IS
3035:
3196: *---------------------------------------------------------------------*/
3197: PROCEDURE CITI_ES_EFT_DOM_PAYEE (
3198: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3199: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3200: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3201: p_is_online_val IN VARCHAR2,
3202: x_result OUT NOCOPY NUMBER)
3203: IS
3204:
3320: *---------------------------------------------------------------------*/
3321: PROCEDURE CITI_ES_EFT_DOM_DOC (
3322: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3323: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3324: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3325: p_is_online_val IN VARCHAR2,
3326: x_result OUT NOCOPY NUMBER)
3327: IS
3328:
3459: *---------------------------------------------------------------------*/
3460: PROCEDURE CITI_FI_EFT_DOM_PAYEE (
3461: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3462: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3463: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3464: p_is_online_val IN VARCHAR2,
3465: x_result OUT NOCOPY NUMBER)
3466: IS
3467:
3547: *---------------------------------------------------------------------*/
3548: PROCEDURE CITI_FI_EFT_DOM_DOC (
3549: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3550: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3551: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3552: p_is_online_val IN VARCHAR2,
3553: x_result OUT NOCOPY NUMBER)
3554: IS
3555:
3617: *---------------------------------------------------------------------*/
3618: PROCEDURE P_CITI_FI_EFT_DOM_PMT (
3619: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3620: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3621: p_payment_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3622: p_is_online_val IN VARCHAR2,
3623: x_result OUT NOCOPY NUMBER)
3624: IS
3625:
3686: *---------------------------------------------------------------------*/
3687: PROCEDURE CITI_FR_EFT_DOM_PAYEE (
3688: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3689: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3690: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3691: p_is_online_val IN VARCHAR2,
3692: x_result OUT NOCOPY NUMBER)
3693: IS
3694:
3783: *---------------------------------------------------------------------*/
3784: PROCEDURE CITI_FR_EFT_DOM_DOC (
3785: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3786: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3787: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3788: p_is_online_val IN VARCHAR2,
3789: x_result OUT NOCOPY NUMBER)
3790: IS
3791:
3930: *---------------------------------------------------------------------*/
3931: PROCEDURE CITI_GR_CHECK_DOM_PAYEE (
3932: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3933: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3934: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3935: p_is_online_val IN VARCHAR2,
3936: x_result OUT NOCOPY NUMBER)
3937: IS
3938:
4024: *---------------------------------------------------------------------*/
4025: PROCEDURE CITI_GR_CHECK_DOM_DOC (
4026: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4027: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4028: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4029: p_is_online_val IN VARCHAR2,
4030: x_result OUT NOCOPY NUMBER)
4031: IS
4032:
4163: *---------------------------------------------------------------------*/
4164: PROCEDURE CITI_GR_EFT_DOM_PAYEE (
4165: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4166: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4167: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4168: p_is_online_val IN VARCHAR2,
4169: x_result OUT NOCOPY NUMBER)
4170: IS
4171:
4242: *---------------------------------------------------------------------*/
4243: PROCEDURE CITI_GR_EFT_DOM_DOC (
4244: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4245: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4246: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4247: p_is_online_val IN VARCHAR2,
4248: x_result OUT NOCOPY NUMBER)
4249: IS
4250:
4382: *---------------------------------------------------------------------*/
4383: PROCEDURE CITI_IE_EFT_DOM_PAYEE (
4384: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4385: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4386: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4387: p_is_online_val IN VARCHAR2,
4388: x_result OUT NOCOPY NUMBER)
4389: IS
4390:
4601: *---------------------------------------------------------------------*/
4602: PROCEDURE CITI_IE_EFT_DOM_DOC (
4603: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4604: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4605: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4606: p_is_online_val IN VARCHAR2,
4607: x_result OUT NOCOPY NUMBER)
4608: IS
4609:
4671: *---------------------------------------------------------------------*/
4672: PROCEDURE CITI_IT_EFT_DOM_PAYEE (
4673: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4674: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4675: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4676: p_is_online_val IN VARCHAR2,
4677: x_result OUT NOCOPY NUMBER)
4678: IS
4679:
4882: *---------------------------------------------------------------------*/
4883: PROCEDURE JP_EFT_ZENGIN_INTERNAL_BANK (
4884: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4885: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4886: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4887: p_is_online_val IN VARCHAR2,
4888: x_result OUT NOCOPY NUMBER)
4889: IS
4890:
4985: *---------------------------------------------------------------------*/
4986: PROCEDURE JP_EFT_ZENGIN_PAYEE (
4987: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4988: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4989: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4990: p_is_online_val IN VARCHAR2,
4991: x_result OUT NOCOPY NUMBER)
4992: IS
4993:
5078: *---------------------------------------------------------------------*/
5079: PROCEDURE NO_EFT_DOM_DOC (
5080: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5081: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5082: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5083: p_is_online_val IN VARCHAR2,
5084: x_result OUT NOCOPY NUMBER)
5085: IS
5086:
5146: *---------------------------------------------------------------------*/
5147: PROCEDURE CITI_NO_EFT_DOM_PAYEE (
5148: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5149: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5150: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5151: p_is_online_val IN VARCHAR2,
5152: x_result OUT NOCOPY NUMBER)
5153: IS
5154:
5231: *---------------------------------------------------------------------*/
5232: PROCEDURE CITI_NO_EFT_DOM_DOC (
5233: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5234: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5235: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5236: p_is_online_val IN VARCHAR2,
5237: x_result OUT NOCOPY NUMBER)
5238: IS
5239:
5385: *---------------------------------------------------------------------*/
5386: PROCEDURE CITI_PL_EFT_MTMS_INTERNAL_BANK (
5387: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5388: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5389: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5390: p_is_online_val IN VARCHAR2,
5391: x_result OUT NOCOPY NUMBER)
5392: IS
5393:
5466: *---------------------------------------------------------------------*/
5467: PROCEDURE CITI_PL_EFT_MTMS_PAYEE (
5468: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5469: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5470: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5471: p_is_online_val IN VARCHAR2,
5472: x_result OUT NOCOPY NUMBER)
5473: IS
5474:
5701: *---------------------------------------------------------------------*/
5702: PROCEDURE PEKAO_PL_WIRE_TR_INTERNAL_BANK (
5703: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5704: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5705: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5706: p_is_online_val IN VARCHAR2,
5707: x_result OUT NOCOPY NUMBER)
5708: IS
5709:
5782: *---------------------------------------------------------------------*/
5783: PROCEDURE PEKAO_PL_WIRE_TR_PAYEE (
5784: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5785: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5786: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5787: p_is_online_val IN VARCHAR2,
5788: x_result OUT NOCOPY NUMBER)
5789: IS
5790:
5888: *---------------------------------------------------------------------*/
5889: PROCEDURE PEKAO_PL_WIRE_TR_DOC (
5890: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5891: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5892: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5893: p_is_online_val IN VARCHAR2,
5894: x_result OUT NOCOPY NUMBER)
5895: IS
5896:
6038: *---------------------------------------------------------------------*/
6039: PROCEDURE PEKAO_PL_WIRE_ST_INTERNAL_BANK (
6040: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6041: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6042: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6043: p_is_online_val IN VARCHAR2,
6044: x_result OUT NOCOPY NUMBER)
6045: IS
6046:
6119: *---------------------------------------------------------------------*/
6120: PROCEDURE PEKAO_PL_WIRE_ST_PAYEE (
6121: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6122: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6123: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6124: p_is_online_val IN VARCHAR2,
6125: x_result OUT NOCOPY NUMBER)
6126: IS
6127:
6225: *---------------------------------------------------------------------*/
6226: PROCEDURE PEKAO_PL_WIRE_ST_DOC (
6227: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6228: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6229: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6230: p_is_online_val IN VARCHAR2,
6231: x_result OUT NOCOPY NUMBER)
6232: IS
6233:
6282: *---------------------------------------------------------------------*/
6283: PROCEDURE CITI_PT_EFT_DOM_PAYEE (
6284: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6285: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6286: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6287: p_is_online_val IN VARCHAR2,
6288: x_result OUT NOCOPY NUMBER)
6289: IS
6290:
6383: *---------------------------------------------------------------------*/
6384: PROCEDURE CITI_PT_EFT_DOM_DOC (
6385: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6386: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6387: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6388: p_is_online_val IN VARCHAR2,
6389: x_result OUT NOCOPY NUMBER)
6390: IS
6391:
6538: *---------------------------------------------------------------------*/
6539: PROCEDURE PT_CHECK_GEN (
6540: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6541: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6542: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6543: p_is_online_val IN VARCHAR2,
6544: x_result OUT NOCOPY NUMBER)
6545: IS
6546:
6608: *---------------------------------------------------------------------*/
6609: PROCEDURE CITI_SE_EFT_DOM_PAYEE (
6610: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6611: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6612: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6613: p_is_online_val IN VARCHAR2,
6614: x_result OUT NOCOPY NUMBER)
6615: IS
6616:
6751: *---------------------------------------------------------------------*/
6752: PROCEDURE CITI_SE_EFT_DOM_DOC (
6753: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6754: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6755: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6756: p_is_online_val IN VARCHAR2,
6757: x_result OUT NOCOPY NUMBER)
6758: IS
6759:
6905: *---------------------------------------------------------------------*/
6906: PROCEDURE SE_EFT_BANKGIRO_INLAND_DOC (
6907: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6908: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6909: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6910: p_is_online_val IN VARCHAR2,
6911: x_result OUT NOCOPY NUMBER)
6912: IS
6913:
7001: *---------------------------------------------------------------------*/
7002: PROCEDURE SE_EFT_BANKGIRO_UTLAND_SI_DOC (
7003: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7004: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7005: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7006: p_is_online_val IN VARCHAR2,
7007: x_result OUT NOCOPY NUMBER)
7008: IS
7009:
7071: *---------------------------------------------------------------------*/
7072: PROCEDURE SE_EFT_BANKGIRO_UTLAND_UT_DOC (
7073: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7074: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7075: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7076: p_is_online_val IN VARCHAR2,
7077: x_result OUT NOCOPY NUMBER)
7078: IS
7079:
7141: *---------------------------------------------------------------------*/
7142: PROCEDURE SE_EFT_POSTGIRO_INLAND_DOC (
7143: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7144: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7145: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7146: p_is_online_val IN VARCHAR2,
7147: x_result OUT NOCOPY NUMBER)
7148: IS
7149:
7211: *---------------------------------------------------------------------*/
7212: PROCEDURE SE_EFT_POSTGIRO_UTLAND_DOC (
7213: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7214: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7215: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7216: p_is_online_val IN VARCHAR2,
7217: x_result OUT NOCOPY NUMBER)
7218: IS
7219:
7281: *---------------------------------------------------------------------*/
7282: PROCEDURE CITI_GB_EFT_DOM_PAYEE (
7283: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7284: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7285: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7286: p_is_online_val IN VARCHAR2,
7287: x_result OUT NOCOPY NUMBER)
7288: IS
7289:
7383: *---------------------------------------------------------------------*/
7384: PROCEDURE CITI_GB_EFT_DOM_DOC (
7385: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7386: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7387: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7388: p_is_online_val IN VARCHAR2,
7389: x_result OUT NOCOPY NUMBER)
7390: IS
7391:
7537: *---------------------------------------------------------------------*/
7538: PROCEDURE US_NACHA_INTERNAL_BANK (
7539: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7540: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7541: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7542: p_is_online_val IN VARCHAR2,
7543: x_result OUT NOCOPY NUMBER)
7544: IS
7545:
7607: *---------------------------------------------------------------------*/
7608: PROCEDURE US_NACHA_PAYEE (
7609: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7610: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7611: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7612: p_is_online_val IN VARCHAR2,
7613: x_result OUT NOCOPY NUMBER)
7614: IS
7615:
7677: *---------------------------------------------------------------------*/
7678: PROCEDURE US_NACHA_PAYEE_ACCOUNT (
7679: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7680: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7681: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7682: p_is_online_val IN VARCHAR2,
7683: x_result OUT NOCOPY NUMBER)
7684: IS
7685:
7831: IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7832: p_validation_set_code IN
7833: IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
7834: p_document_id IN
7835: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
7836: p_is_online_val IN VARCHAR2,
7837: x_result OUT NOCOPY NUMBER)
7838: IS
7839:
7932: IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7933: p_validation_set_code IN
7934: IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
7935: p_document_id IN
7936: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
7937: p_is_online_val IN VARCHAR2,
7938: x_result OUT NOCOPY NUMBER)
7939: IS
7940:
7983: l_bank_edi_id_number,
7984: l_bank_name,
7985: l_bank_branch_name
7986: FROM
7987: IBY_DOCS_PAYABLE_ALL doc,
7988: CE_BANK_BRANCHES_V abb,
7989: CE_BANK_ACCOUNTS cba,
7990: HZ_CONTACT_POINTS edi
7991: WHERE
8087: IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
8088: p_validation_set_code IN
8089: IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
8090: p_document_id IN
8091: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
8092: p_is_online_val IN VARCHAR2,
8093: x_result OUT NOCOPY NUMBER)
8094: IS
8095:
8132: cbb.bank_branch_type
8133: INTO
8134: l_bank_branch_type
8135: FROM
8136: IBY_DOCS_PAYABLE_ALL doc,
8137: IBY_EXT_BANK_ACCOUNTS_V eba,
8138: CE_BANK_BRANCHES_V cbb
8139: WHERE
8140: doc.document_payable_id = p_document_id
8202: ep.bank_instruction2_code
8203: INTO
8204: l_trxn_handling
8205: FROM
8206: IBY_DOCS_PAYABLE_ALL doc,
8207: IBY_EXTERNAL_PAYEES_ALL ep
8208: WHERE
8209: doc.document_payable_id = p_document_id
8210: AND doc.ext_payee_id = ep.ext_payee_id
8272: ep.bank_instruction1_code
8273: INTO
8274: l_edi_pmt_format
8275: FROM
8276: IBY_DOCS_PAYABLE_ALL doc,
8277: IBY_EXTERNAL_PAYEES_ALL ep
8278: WHERE
8279: doc.document_payable_id = p_document_id
8280: AND doc.ext_payee_id = ep.ext_payee_id
10498: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.
10499: validation_assignment_id%TYPE,
10500: p_validation_set_code IN IBY_VALIDATION_SETS_VL.
10501: validation_set_code%TYPE,
10502: p_document_id IN IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
10503: p_is_online_val IN VARCHAR2,
10504: x_result OUT NOCOPY NUMBER)
10505: IS
10506:
10982:
10983: PROCEDURE VALIDATE_BANK_CHARGE_BEARER(
10984: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
10985: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
10986: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
10987: p_is_online_val IN VARCHAR2,
10988: x_result OUT NOCOPY NUMBER)
10989: IS
10990:
11051: *---------------------------------------------------------------------*/
11052: PROCEDURE VALIDATE_PAYEE_BIC(
11053: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
11054: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
11055: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
11056: p_is_online_val IN VARCHAR2,
11057: x_result OUT NOCOPY NUMBER)
11058:
11059: IS
11123: *---------------------------------------------------------------------*/
11124: PROCEDURE VALIDATE_PAYEE_IBAN(
11125: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
11126: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
11127: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
11128: p_is_online_val IN VARCHAR2,
11129: x_result OUT NOCOPY NUMBER)
11130:
11131: IS
11603: IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
11604: p_validation_set_code IN
11605: IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
11606: p_document_id IN
11607: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
11608: p_is_online_val IN VARCHAR2,
11609: x_result OUT NOCOPY NUMBER
11610: )IS
11611: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
11756: IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
11757: p_validation_set_code IN
11758: IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
11759: p_document_id IN
11760: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
11761: p_is_online_val IN VARCHAR2,
11762: x_result OUT NOCOPY NUMBER
11763: )IS
11764:
11836: IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
11837: p_validation_set_code IN
11838: IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
11839: p_document_id IN
11840: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
11841: p_is_online_val IN VARCHAR2,
11842: x_result OUT NOCOPY NUMBER
11843: )IS
11844:
11914: IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
11915: p_validation_set_code IN
11916: IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
11917: p_document_id IN
11918: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
11919: p_is_online_val IN VARCHAR2,
11920: x_result OUT NOCOPY NUMBER
11921: ) IS
11922:
11988: *---------------------------------------------------------------------*/
11989: PROCEDURE VALIDATE_FIN_URI (
11990: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
11991: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
11992: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
11993: p_is_online_val IN VARCHAR2,
11994: x_result OUT NOCOPY NUMBER) IS
11995:
11996: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
12226: x_result := l_valid;
12227:
12228: END VALIDATE_FIN_URI;
12229:
12230: FUNCTION FIN_URI_CHECK_DIGIT_VAL( uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
12231: uri_check_digit IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE)
12232: RETURN BOOLEAN is
12233: l_flag BOOLEAN := false;
12234: l_ck IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE;
12227:
12228: END VALIDATE_FIN_URI;
12229:
12230: FUNCTION FIN_URI_CHECK_DIGIT_VAL( uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
12231: uri_check_digit IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE)
12232: RETURN BOOLEAN is
12233: l_flag BOOLEAN := false;
12234: l_ck IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE;
12235: BEGIN
12230: FUNCTION FIN_URI_CHECK_DIGIT_VAL( uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
12231: uri_check_digit IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE)
12232: RETURN BOOLEAN is
12233: l_flag BOOLEAN := false;
12234: l_ck IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE;
12235: BEGIN
12236: IF uri_check_digit = '00' THEN
12237: l_ck := '10';
12238: ELSE
12329: WHERE pmt.payment_status IN ('INSTRUCTION_CREATED')
12330: AND pmt.payment_instruction_id = p_instruction_id
12331: AND pmt.payment_id IN
12332: (SELECT doc.payment_id
12333: FROM IBY_DOCS_PAYABLE_ALL doc
12334: WHERE doc.payment_id = pmt.payment_id
12335: AND doc.calling_app_id = 200
12336: );
12337:
12334: WHERE doc.payment_id = pmt.payment_id
12335: AND doc.calling_app_id = 200
12336: );
12337:
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
12362: WHERE pmt.payment_status IN ('INSTRUCTION_CREATED')
12363: AND pmt.payment_instruction_id = p_instruction_id
12364: AND pmt.payment_id IN
12365: (SELECT doc.payment_id
12366: FROM IBY_DOCS_PAYABLE_ALL doc
12367: WHERE doc.payment_id = pmt.payment_id
12368: AND doc.calling_app_id = 200
12369: );
12370:
12367: WHERE doc.payment_id = pmt.payment_id
12368: AND doc.calling_app_id = 200
12369: );
12370:
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
12437: /* SEPA Credit Transfer Enhancement*/
12438: PROCEDURE VALIDATE_INV_LEGAL_ENTITY_ID(
12439: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
12440: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
12441: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
12442: p_is_online_val IN VARCHAR2,
12443: x_result OUT NOCOPY NUMBER)
12444: IS
12445: