[Home] [Help]
50: *---------------------------------------------------------------------*/
51: PROCEDURE CITI_AT_EFT_DOM_PAYEE (
52: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
53: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
54: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
55: p_is_online_val IN VARCHAR2,
56: x_result OUT NOCOPY NUMBER)
57: IS
58:
153: *---------------------------------------------------------------------*/
154: PROCEDURE CITI_AT_EFT_DOM_DOC (
155: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
156: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
157: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
158: p_is_online_val IN VARCHAR2,
159: x_result OUT NOCOPY NUMBER)
160: IS
161:
223: *---------------------------------------------------------------------*/
224: PROCEDURE AT_EFT_INT_INTERNAL_BANK(
225: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
226: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
227: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
228: p_is_online_val IN VARCHAR2,
229: x_result OUT NOCOPY NUMBER)
230: IS
231:
298: *---------------------------------------------------------------------*/
299: PROCEDURE AT_EFT_INT_PAYER (
300: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
301: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
302: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
303: p_is_online_val IN VARCHAR2,
304: x_result OUT NOCOPY NUMBER)
305: IS
306:
383: *---------------------------------------------------------------------*/
384: PROCEDURE AT_EFT_INT_PAYEE(
385: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
386: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
387: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
388: p_is_online_val IN VARCHAR2,
389: x_result OUT NOCOPY NUMBER)
390: IS
391:
468: *---------------------------------------------------------------------*/
469: PROCEDURE CITI_BE_EFT_DOM_PAYEE (
470: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
471: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
472: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
473: p_is_online_val IN VARCHAR2,
474: x_result OUT NOCOPY NUMBER)
475: IS
476:
677: *---------------------------------------------------------------------*/
678: PROCEDURE BE_EFT_DOM_DOC (
679: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
680: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
681: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
682: p_is_online_val IN VARCHAR2,
683: x_result OUT NOCOPY NUMBER)
684: IS
685:
747: *---------------------------------------------------------------------*/
748: PROCEDURE BE_EFT_INT_PAYEE (
749: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
750: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
751: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
752: p_is_online_val IN VARCHAR2,
753: x_result OUT NOCOPY NUMBER)
754: IS
755:
846: *---------------------------------------------------------------------*/
847: PROCEDURE BE_EFT_INT_DOC (
848: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
849: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
850: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
851: p_is_online_val IN VARCHAR2,
852: x_result OUT NOCOPY NUMBER)
853: IS
854:
1105: *---------------------------------------------------------------------*/
1106: PROCEDURE CITI_CH_EFT_DOM_PAYEE(
1107: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1108: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1109: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1110: p_is_online_val IN VARCHAR2,
1111: x_result OUT NOCOPY NUMBER)
1112: IS
1113:
1351: *---------------------------------------------------------------------*/
1352: PROCEDURE CITI_CH_EFT_DOM_DOC (
1353: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1354: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1355: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1356: p_is_online_val IN VARCHAR2,
1357: x_result OUT NOCOPY NUMBER)
1358: IS
1359:
1505: *---------------------------------------------------------------------*/
1506: PROCEDURE CH_EFT_GEN_PAYEE (
1507: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1508: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1509: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1510: p_is_online_val IN VARCHAR2,
1511: x_result OUT NOCOPY NUMBER)
1512: IS
1513:
1599: *---------------------------------------------------------------------*/
1600: PROCEDURE CH_EFT_GEN_DOC (
1601: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1602: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1603: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1604: p_is_online_val IN VARCHAR2,
1605: x_result OUT NOCOPY NUMBER)
1606: IS
1607:
1792: *---------------------------------------------------------------------*/
1793: PROCEDURE CITI_DE_EFT_DOM_PAYEE (
1794: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1795: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1796: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1797: p_is_online_val IN VARCHAR2,
1798: x_result OUT NOCOPY NUMBER)
1799: IS
1800:
1895: *---------------------------------------------------------------------*/
1896: PROCEDURE CITI_DE_EFT_DOM_DOC (
1897: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1898: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1899: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1900: p_is_online_val IN VARCHAR2,
1901: x_result OUT NOCOPY NUMBER)
1902: IS
1903:
1965: *---------------------------------------------------------------------*/
1966: PROCEDURE DE_EFT_DOM_INTERNAL_BANK (
1967: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1968: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1969: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1970: p_is_online_val IN VARCHAR2,
1971: x_result OUT NOCOPY NUMBER)
1972: IS
1973:
2067: *---------------------------------------------------------------------*/
2068: PROCEDURE DE_EFT_DOM_PAYER (
2069: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2070: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2071: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2072: p_is_online_val IN VARCHAR2,
2073: x_result OUT NOCOPY NUMBER)
2074: IS
2075:
2137: *---------------------------------------------------------------------*/
2138: PROCEDURE DE_EFT_DOM_PAYEE (
2139: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2140: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2141: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2142: p_is_online_val IN VARCHAR2,
2143: x_result OUT NOCOPY NUMBER)
2144: IS
2145:
2307: *---------------------------------------------------------------------*/
2308: PROCEDURE DE_EFT_INT_INTERNAL_BANK (
2309: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2310: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2311: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2312: p_is_online_val IN VARCHAR2,
2313: x_result OUT NOCOPY NUMBER)
2314: IS
2315:
2409: *---------------------------------------------------------------------*/
2410: PROCEDURE DE_EFT_INT_PAYEE (
2411: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2412: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2413: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2414: p_is_online_val IN VARCHAR2,
2415: x_result OUT NOCOPY NUMBER)
2416: IS
2417:
2497: *---------------------------------------------------------------------*/
2498: PROCEDURE DE_EFT_INT_PAYER (
2499: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2500: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2501: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2502: p_is_online_val IN VARCHAR2,
2503: x_result OUT NOCOPY NUMBER)
2504: IS
2505:
2706: *---------------------------------------------------------------------*/
2707: PROCEDURE DK_EFT_DOM_DOC (
2708: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2709: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2710: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2711: p_is_online_val IN VARCHAR2,
2712: x_result OUT NOCOPY NUMBER)
2713: IS
2714:
2772: *---------------------------------------------------------------------*/
2773: PROCEDURE CITI_DK_EFT_DOM_PAYEE (
2774: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2775: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2776: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2777: p_is_online_val IN VARCHAR2,
2778: x_result OUT NOCOPY NUMBER)
2779: IS
2780:
2856: *---------------------------------------------------------------------*/
2857: PROCEDURE CITI_DK_EFT_DOM_DOC (
2858: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2859: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
2860: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2861: p_is_online_val IN VARCHAR2,
2862: x_result OUT NOCOPY NUMBER)
2863: IS
2864:
3025: *---------------------------------------------------------------------*/
3026: PROCEDURE CITI_ES_CHECK_DOM_PAYEE (
3027: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3028: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3029: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3030: p_is_online_val IN VARCHAR2,
3031: x_result OUT NOCOPY NUMBER)
3032: IS
3033:
3194: *---------------------------------------------------------------------*/
3195: PROCEDURE CITI_ES_EFT_DOM_PAYEE (
3196: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3197: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3198: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3199: p_is_online_val IN VARCHAR2,
3200: x_result OUT NOCOPY NUMBER)
3201: IS
3202:
3318: *---------------------------------------------------------------------*/
3319: PROCEDURE CITI_ES_EFT_DOM_DOC (
3320: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3321: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3322: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3323: p_is_online_val IN VARCHAR2,
3324: x_result OUT NOCOPY NUMBER)
3325: IS
3326:
3457: *---------------------------------------------------------------------*/
3458: PROCEDURE CITI_FI_EFT_DOM_PAYEE (
3459: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3460: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3461: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3462: p_is_online_val IN VARCHAR2,
3463: x_result OUT NOCOPY NUMBER)
3464: IS
3465:
3545: *---------------------------------------------------------------------*/
3546: PROCEDURE CITI_FI_EFT_DOM_DOC (
3547: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3548: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3549: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3550: p_is_online_val IN VARCHAR2,
3551: x_result OUT NOCOPY NUMBER)
3552: IS
3553:
3615: *---------------------------------------------------------------------*/
3616: PROCEDURE P_CITI_FI_EFT_DOM_PMT (
3617: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3618: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3619: p_payment_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3620: p_is_online_val IN VARCHAR2,
3621: x_result OUT NOCOPY NUMBER)
3622: IS
3623:
3684: *---------------------------------------------------------------------*/
3685: PROCEDURE CITI_FR_EFT_DOM_PAYEE (
3686: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3687: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3688: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3689: p_is_online_val IN VARCHAR2,
3690: x_result OUT NOCOPY NUMBER)
3691: IS
3692:
3781: *---------------------------------------------------------------------*/
3782: PROCEDURE CITI_FR_EFT_DOM_DOC (
3783: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3784: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3785: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3786: p_is_online_val IN VARCHAR2,
3787: x_result OUT NOCOPY NUMBER)
3788: IS
3789:
3928: *---------------------------------------------------------------------*/
3929: PROCEDURE CITI_GR_CHECK_DOM_PAYEE (
3930: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3931: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
3932: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
3933: p_is_online_val IN VARCHAR2,
3934: x_result OUT NOCOPY NUMBER)
3935: IS
3936:
4022: *---------------------------------------------------------------------*/
4023: PROCEDURE CITI_GR_CHECK_DOM_DOC (
4024: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4025: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4026: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4027: p_is_online_val IN VARCHAR2,
4028: x_result OUT NOCOPY NUMBER)
4029: IS
4030:
4161: *---------------------------------------------------------------------*/
4162: PROCEDURE CITI_GR_EFT_DOM_PAYEE (
4163: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4164: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4165: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4166: p_is_online_val IN VARCHAR2,
4167: x_result OUT NOCOPY NUMBER)
4168: IS
4169:
4240: *---------------------------------------------------------------------*/
4241: PROCEDURE CITI_GR_EFT_DOM_DOC (
4242: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4243: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4244: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4245: p_is_online_val IN VARCHAR2,
4246: x_result OUT NOCOPY NUMBER)
4247: IS
4248:
4380: *---------------------------------------------------------------------*/
4381: PROCEDURE CITI_IE_EFT_DOM_PAYEE (
4382: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4383: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4384: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4385: p_is_online_val IN VARCHAR2,
4386: x_result OUT NOCOPY NUMBER)
4387: IS
4388:
4599: *---------------------------------------------------------------------*/
4600: PROCEDURE CITI_IE_EFT_DOM_DOC (
4601: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4602: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4603: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4604: p_is_online_val IN VARCHAR2,
4605: x_result OUT NOCOPY NUMBER)
4606: IS
4607:
4669: *---------------------------------------------------------------------*/
4670: PROCEDURE CITI_IT_EFT_DOM_PAYEE (
4671: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4672: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4673: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4674: p_is_online_val IN VARCHAR2,
4675: x_result OUT NOCOPY NUMBER)
4676: IS
4677:
4880: *---------------------------------------------------------------------*/
4881: PROCEDURE JP_EFT_ZENGIN_INTERNAL_BANK (
4882: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4883: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4884: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4885: p_is_online_val IN VARCHAR2,
4886: x_result OUT NOCOPY NUMBER)
4887: IS
4888:
4983: *---------------------------------------------------------------------*/
4984: PROCEDURE JP_EFT_ZENGIN_PAYEE (
4985: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4986: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
4987: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
4988: p_is_online_val IN VARCHAR2,
4989: x_result OUT NOCOPY NUMBER)
4990: IS
4991:
5076: *---------------------------------------------------------------------*/
5077: PROCEDURE NO_EFT_DOM_DOC (
5078: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5079: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5080: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5081: p_is_online_val IN VARCHAR2,
5082: x_result OUT NOCOPY NUMBER)
5083: IS
5084:
5144: *---------------------------------------------------------------------*/
5145: PROCEDURE CITI_NO_EFT_DOM_PAYEE (
5146: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5147: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5148: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5149: p_is_online_val IN VARCHAR2,
5150: x_result OUT NOCOPY NUMBER)
5151: IS
5152:
5229: *---------------------------------------------------------------------*/
5230: PROCEDURE CITI_NO_EFT_DOM_DOC (
5231: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5232: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5233: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5234: p_is_online_val IN VARCHAR2,
5235: x_result OUT NOCOPY NUMBER)
5236: IS
5237:
5383: *---------------------------------------------------------------------*/
5384: PROCEDURE CITI_PL_EFT_MTMS_INTERNAL_BANK (
5385: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5386: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5387: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5388: p_is_online_val IN VARCHAR2,
5389: x_result OUT NOCOPY NUMBER)
5390: IS
5391:
5464: *---------------------------------------------------------------------*/
5465: PROCEDURE CITI_PL_EFT_MTMS_PAYEE (
5466: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5467: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5468: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5469: p_is_online_val IN VARCHAR2,
5470: x_result OUT NOCOPY NUMBER)
5471: IS
5472:
5699: *---------------------------------------------------------------------*/
5700: PROCEDURE PEKAO_PL_WIRE_TR_INTERNAL_BANK (
5701: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5702: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5703: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5704: p_is_online_val IN VARCHAR2,
5705: x_result OUT NOCOPY NUMBER)
5706: IS
5707:
5780: *---------------------------------------------------------------------*/
5781: PROCEDURE PEKAO_PL_WIRE_TR_PAYEE (
5782: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5783: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5784: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5785: p_is_online_val IN VARCHAR2,
5786: x_result OUT NOCOPY NUMBER)
5787: IS
5788:
5886: *---------------------------------------------------------------------*/
5887: PROCEDURE PEKAO_PL_WIRE_TR_DOC (
5888: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
5889: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
5890: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
5891: p_is_online_val IN VARCHAR2,
5892: x_result OUT NOCOPY NUMBER)
5893: IS
5894:
6036: *---------------------------------------------------------------------*/
6037: PROCEDURE PEKAO_PL_WIRE_ST_INTERNAL_BANK (
6038: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6039: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6040: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6041: p_is_online_val IN VARCHAR2,
6042: x_result OUT NOCOPY NUMBER)
6043: IS
6044:
6117: *---------------------------------------------------------------------*/
6118: PROCEDURE PEKAO_PL_WIRE_ST_PAYEE (
6119: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6120: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6121: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6122: p_is_online_val IN VARCHAR2,
6123: x_result OUT NOCOPY NUMBER)
6124: IS
6125:
6223: *---------------------------------------------------------------------*/
6224: PROCEDURE PEKAO_PL_WIRE_ST_DOC (
6225: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6226: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6227: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6228: p_is_online_val IN VARCHAR2,
6229: x_result OUT NOCOPY NUMBER)
6230: IS
6231:
6280: *---------------------------------------------------------------------*/
6281: PROCEDURE CITI_PT_EFT_DOM_PAYEE (
6282: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6283: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6284: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6285: p_is_online_val IN VARCHAR2,
6286: x_result OUT NOCOPY NUMBER)
6287: IS
6288:
6381: *---------------------------------------------------------------------*/
6382: PROCEDURE CITI_PT_EFT_DOM_DOC (
6383: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6384: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6385: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6386: p_is_online_val IN VARCHAR2,
6387: x_result OUT NOCOPY NUMBER)
6388: IS
6389:
6536: *---------------------------------------------------------------------*/
6537: PROCEDURE PT_CHECK_GEN (
6538: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6539: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6540: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6541: p_is_online_val IN VARCHAR2,
6542: x_result OUT NOCOPY NUMBER)
6543: IS
6544:
6606: *---------------------------------------------------------------------*/
6607: PROCEDURE CITI_SE_EFT_DOM_PAYEE (
6608: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6609: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6610: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6611: p_is_online_val IN VARCHAR2,
6612: x_result OUT NOCOPY NUMBER)
6613: IS
6614:
6749: *---------------------------------------------------------------------*/
6750: PROCEDURE CITI_SE_EFT_DOM_DOC (
6751: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6752: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6753: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6754: p_is_online_val IN VARCHAR2,
6755: x_result OUT NOCOPY NUMBER)
6756: IS
6757:
6903: *---------------------------------------------------------------------*/
6904: PROCEDURE SE_EFT_BANKGIRO_INLAND_DOC (
6905: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6906: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
6907: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
6908: p_is_online_val IN VARCHAR2,
6909: x_result OUT NOCOPY NUMBER)
6910: IS
6911:
6999: *---------------------------------------------------------------------*/
7000: PROCEDURE SE_EFT_BANKGIRO_UTLAND_SI_DOC (
7001: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7002: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7003: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7004: p_is_online_val IN VARCHAR2,
7005: x_result OUT NOCOPY NUMBER)
7006: IS
7007:
7069: *---------------------------------------------------------------------*/
7070: PROCEDURE SE_EFT_BANKGIRO_UTLAND_UT_DOC (
7071: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7072: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7073: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7074: p_is_online_val IN VARCHAR2,
7075: x_result OUT NOCOPY NUMBER)
7076: IS
7077:
7139: *---------------------------------------------------------------------*/
7140: PROCEDURE SE_EFT_POSTGIRO_INLAND_DOC (
7141: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7142: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7143: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7144: p_is_online_val IN VARCHAR2,
7145: x_result OUT NOCOPY NUMBER)
7146: IS
7147:
7209: *---------------------------------------------------------------------*/
7210: PROCEDURE SE_EFT_POSTGIRO_UTLAND_DOC (
7211: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7212: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7213: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7214: p_is_online_val IN VARCHAR2,
7215: x_result OUT NOCOPY NUMBER)
7216: IS
7217:
7279: *---------------------------------------------------------------------*/
7280: PROCEDURE CITI_GB_EFT_DOM_PAYEE (
7281: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7282: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7283: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7284: p_is_online_val IN VARCHAR2,
7285: x_result OUT NOCOPY NUMBER)
7286: IS
7287:
7381: *---------------------------------------------------------------------*/
7382: PROCEDURE CITI_GB_EFT_DOM_DOC (
7383: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7384: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7385: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7386: p_is_online_val IN VARCHAR2,
7387: x_result OUT NOCOPY NUMBER)
7388: IS
7389:
7535: *---------------------------------------------------------------------*/
7536: PROCEDURE US_NACHA_INTERNAL_BANK (
7537: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7538: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7539: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7540: p_is_online_val IN VARCHAR2,
7541: x_result OUT NOCOPY NUMBER)
7542: IS
7543:
7605: *---------------------------------------------------------------------*/
7606: PROCEDURE US_NACHA_PAYEE (
7607: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7608: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
7609: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
7610: p_is_online_val IN VARCHAR2,
7611: x_result OUT NOCOPY NUMBER)
7612: IS
7613:
7759: IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7760: p_validation_set_code IN
7761: IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
7762: p_document_id IN
7763: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
7764: p_is_online_val IN VARCHAR2,
7765: x_result OUT NOCOPY NUMBER)
7766: IS
7767:
7858: IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
7859: p_validation_set_code IN
7860: IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
7861: p_document_id IN
7862: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
7863: p_is_online_val IN VARCHAR2,
7864: x_result OUT NOCOPY NUMBER)
7865: IS
7866:
7909: l_bank_edi_id_number,
7910: l_bank_name,
7911: l_bank_branch_name
7912: FROM
7913: IBY_DOCS_PAYABLE_ALL doc,
7914: CE_BANK_BRANCHES_V abb,
7915: CE_BANK_ACCOUNTS cba,
7916: HZ_CONTACT_POINTS edi
7917: WHERE
8009: IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
8010: p_validation_set_code IN
8011: IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
8012: p_document_id IN
8013: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
8014: p_is_online_val IN VARCHAR2,
8015: x_result OUT NOCOPY NUMBER)
8016: IS
8017:
8054: cbb.bank_branch_type
8055: INTO
8056: l_bank_branch_type
8057: FROM
8058: IBY_DOCS_PAYABLE_ALL doc,
8059: IBY_EXT_BANK_ACCOUNTS_V eba,
8060: CE_BANK_BRANCHES_V cbb
8061: WHERE
8062: doc.document_payable_id = p_document_id
8120: ep.bank_instruction2_code
8121: INTO
8122: l_trxn_handling
8123: FROM
8124: IBY_DOCS_PAYABLE_ALL doc,
8125: IBY_EXTERNAL_PAYEES_ALL ep
8126: WHERE
8127: doc.document_payable_id = p_document_id
8128: AND doc.ext_payee_id = ep.ext_payee_id
8186: ep.bank_instruction1_code
8187: INTO
8188: l_edi_pmt_format
8189: FROM
8190: IBY_DOCS_PAYABLE_ALL doc,
8191: IBY_EXTERNAL_PAYEES_ALL ep
8192: WHERE
8193: doc.document_payable_id = p_document_id
8194: AND doc.ext_payee_id = ep.ext_payee_id
10408: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.
10409: validation_assignment_id%TYPE,
10410: p_validation_set_code IN IBY_VALIDATION_SETS_VL.
10411: validation_set_code%TYPE,
10412: p_document_id IN IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
10413: p_is_online_val IN VARCHAR2,
10414: x_result OUT NOCOPY NUMBER)
10415: IS
10416:
10876:
10877: PROCEDURE VALIDATE_BANK_CHARGE_BEARER(
10878: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
10879: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
10880: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
10881: p_is_online_val IN VARCHAR2,
10882: x_result OUT NOCOPY NUMBER)
10883: IS
10884:
10945: *---------------------------------------------------------------------*/
10946: PROCEDURE VALIDATE_PAYEE_BIC(
10947: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
10948: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
10949: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
10950: p_is_online_val IN VARCHAR2,
10951: x_result OUT NOCOPY NUMBER)
10952:
10953: IS
11017: *---------------------------------------------------------------------*/
11018: PROCEDURE VALIDATE_PAYEE_IBAN(
11019: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
11020: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
11021: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
11022: p_is_online_val IN VARCHAR2,
11023: x_result OUT NOCOPY NUMBER)
11024:
11025: IS