254: * The oraInstrAdd API Creates a new payment instrument.
255: *
256: * @param p_api_version version of the API; current version is 1.0
257: * @rep:paraminfo {@rep:required}
258: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
259: * @param p_commit standard API parameter; default as FND_API.G_TRUE
260: * @param p_validation_level standard API parameter; default as
261: * FND_API.G_VALID_LEVEL_FULL
262: * @rep:paraminfo {@rep:required}
255: *
256: * @param p_api_version version of the API; current version is 1.0
257: * @rep:paraminfo {@rep:required}
258: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
259: * @param p_commit standard API parameter; default as FND_API.G_TRUE
260: * @param p_validation_level standard API parameter; default as
261: * FND_API.G_VALID_LEVEL_FULL
262: * @rep:paraminfo {@rep:required}
263: * @param p_pmtInstrRec payment instrument record
256: * @param p_api_version version of the API; current version is 1.0
257: * @rep:paraminfo {@rep:required}
258: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
259: * @param p_commit standard API parameter; default as FND_API.G_TRUE
260: * @param p_validation_level standard API parameter; default as
261: * FND_API.G_VALID_LEVEL_FULL
262: * @rep:paraminfo {@rep:required}
263: * @param p_pmtInstrRec payment instrument record
264: * @rep:paraminfo {@rep:required}
261: * FND_API.G_VALID_LEVEL_FULL
262: * @rep:paraminfo {@rep:required}
263: * @param p_pmtInstrRec payment instrument record
264: * @rep:paraminfo {@rep:required}
265: * @param x_return_status standard API parameter - output; indicates the overall
266: * status of the API call
267: * @param x_msg_count standard API parameter - output; holds the number of
268: * messages in the API message list
269: * @param x_msg_data standard API parameter - output; If the number is one,
263: * @param p_pmtInstrRec payment instrument record
264: * @rep:paraminfo {@rep:required}
265: * @param x_return_status standard API parameter - output; indicates the overall
266: * status of the API call
267: * @param x_msg_count standard API parameter - output; holds the number of
268: * messages in the API message list
269: * @param x_msg_data standard API parameter - output; If the number is one,
270: * then message data holds the message in an encoded format
271: * @param x_instr_id unique identifier for the newly created payment instrument
265: * @param x_return_status standard API parameter - output; indicates the overall
266: * status of the API call
267: * @param x_msg_count standard API parameter - output; holds the number of
268: * messages in the API message list
269: * @param x_msg_data standard API parameter - output; If the number is one,
270: * then message data holds the message in an encoded format
271: * @param x_instr_id unique identifier for the newly created payment instrument
272: * @param x_result result code of the operation
273: *
321: * The oraInstrMod API Modifies a payment instrument.
322: *
323: * @param p_api_version version of the API; current version is 1.0
324: * @rep:paraminfo {@rep:required}
325: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
326: * @param p_commit standard API parameter; default as FND_API.G_TRUE
327: * @param p_validation_level standard API parameter; default as
328: * FND_API.G_VALID_LEVEL_FULL
329: * @param p_payer_id payer identifier string
322: *
323: * @param p_api_version version of the API; current version is 1.0
324: * @rep:paraminfo {@rep:required}
325: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
326: * @param p_commit standard API parameter; default as FND_API.G_TRUE
327: * @param p_validation_level standard API parameter; default as
328: * FND_API.G_VALID_LEVEL_FULL
329: * @param p_payer_id payer identifier string
330: * @rep:paraminfo {@rep:required}
323: * @param p_api_version version of the API; current version is 1.0
324: * @rep:paraminfo {@rep:required}
325: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
326: * @param p_commit standard API parameter; default as FND_API.G_TRUE
327: * @param p_validation_level standard API parameter; default as
328: * FND_API.G_VALID_LEVEL_FULL
329: * @param p_payer_id payer identifier string
330: * @rep:paraminfo {@rep:required}
331: * @param p_pmtInstrRec payment instrument record. The Instr_Id is required.
329: * @param p_payer_id payer identifier string
330: * @rep:paraminfo {@rep:required}
331: * @param p_pmtInstrRec payment instrument record. The Instr_Id is required.
332: * @rep:paraminfo {@rep:required}
333: * @param x_return_status standard API parameter - output; indicates the overall
334: * status of the API call
335: * @param x_msg_count standard API parameter - output; holds the number of
336: * messages in the API message list
337: * @param x_msg_data standard API parameter - output; if the number is one,
331: * @param p_pmtInstrRec payment instrument record. The Instr_Id is required.
332: * @rep:paraminfo {@rep:required}
333: * @param x_return_status standard API parameter - output; indicates the overall
334: * status of the API call
335: * @param x_msg_count standard API parameter - output; holds the number of
336: * messages in the API message list
337: * @param x_msg_data standard API parameter - output; if the number is one,
338: * then message data holds the message in an encoded format
339: * @param x_result result of the operation
333: * @param x_return_status standard API parameter - output; indicates the overall
334: * status of the API call
335: * @param x_msg_count standard API parameter - output; holds the number of
336: * messages in the API message list
337: * @param x_msg_data standard API parameter - output; if the number is one,
338: * then message data holds the message in an encoded format
339: * @param x_result result of the operation
340: *
341: * @rep:scope public
386: * The oraInstrDel API Deletes a payment instrument.
387: *
388: * @param p_api_version version of the API; current version is 1.0
389: * @rep:paraminfo {@rep:required}
390: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
391: * @param p_commit standard API parameter; default as FND_API.G_TRUE
392: * @param p_validation_level standard API parameter; default as
393: * FND_API.G_VALID_LEVEL_FULL
394: * @param p_payer_id payer identifier string
387: *
388: * @param p_api_version version of the API; current version is 1.0
389: * @rep:paraminfo {@rep:required}
390: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
391: * @param p_commit standard API parameter; default as FND_API.G_TRUE
392: * @param p_validation_level standard API parameter; default as
393: * FND_API.G_VALID_LEVEL_FULL
394: * @param p_payer_id payer identifier string
395: * @rep:paraminfo {@rep:required}
388: * @param p_api_version version of the API; current version is 1.0
389: * @rep:paraminfo {@rep:required}
390: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
391: * @param p_commit standard API parameter; default as FND_API.G_TRUE
392: * @param p_validation_level standard API parameter; default as
393: * FND_API.G_VALID_LEVEL_FULL
394: * @param p_payer_id payer identifier string
395: * @rep:paraminfo {@rep:required}
396: * @param p_instr_id payment instrument unique identifier
394: * @param p_payer_id payer identifier string
395: * @rep:paraminfo {@rep:required}
396: * @param p_instr_id payment instrument unique identifier
397: * @rep:paraminfo {@rep:required}
398: * @param x_return_status standard API parameter - output; indicates the overall
399: * status of the API call
400: * @param x_msg_count standard API parameter - output; holds the number of
401: * messages in the API message list
402: * @param x_msg_data standard API parameter - output; if the number is one,
396: * @param p_instr_id payment instrument unique identifier
397: * @rep:paraminfo {@rep:required}
398: * @param x_return_status standard API parameter - output; indicates the overall
399: * status of the API call
400: * @param x_msg_count standard API parameter - output; holds the number of
401: * messages in the API message list
402: * @param x_msg_data standard API parameter - output; if the number is one,
403: * then message data holds the message in an encoded format
404: *
398: * @param x_return_status standard API parameter - output; indicates the overall
399: * status of the API call
400: * @param x_msg_count standard API parameter - output; holds the number of
401: * messages in the API message list
402: * @param x_msg_data standard API parameter - output; if the number is one,
403: * then message data holds the message in an encoded format
404: *
405: * @rep:scope public
406: * @rep:displayname Delete Payment Instrument
451: * payment instruments that a payer may have based on the payer_id.
452:
453: * @param p_api_version version of the API; current version is 1.0
454: * @rep:paraminfo {@rep:required}
455: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
456: * @param p_commit standard API parameter; default as FND_API.G_TRUE
457: * @param p_validation_level standard API parameter; default as
458: * FND_API.G_VALID_LEVEL_FULL
459: * @param p_payer_id payer identifier string
452:
453: * @param p_api_version version of the API; current version is 1.0
454: * @rep:paraminfo {@rep:required}
455: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
456: * @param p_commit standard API parameter; default as FND_API.G_TRUE
457: * @param p_validation_level standard API parameter; default as
458: * FND_API.G_VALID_LEVEL_FULL
459: * @param p_payer_id payer identifier string
460: * @rep:paraminfo {@rep:required}
453: * @param p_api_version version of the API; current version is 1.0
454: * @rep:paraminfo {@rep:required}
455: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
456: * @param p_commit standard API parameter; default as FND_API.G_TRUE
457: * @param p_validation_level standard API parameter; default as
458: * FND_API.G_VALID_LEVEL_FULL
459: * @param p_payer_id payer identifier string
460: * @rep:paraminfo {@rep:required}
461: * @param x_return_status standard API parameter - output; indicates the overall
457: * @param p_validation_level standard API parameter; default as
458: * FND_API.G_VALID_LEVEL_FULL
459: * @param p_payer_id payer identifier string
460: * @rep:paraminfo {@rep:required}
461: * @param x_return_status standard API parameter - output; indicates the overall
462: * status of the API call
463: * @param x_msg_count standard API parameter - output; holds the number of
464: * messages in the API message list
465: * @param x_msg_data standard API parameter - output; if the number is one,
459: * @param p_payer_id payer identifier string
460: * @rep:paraminfo {@rep:required}
461: * @param x_return_status standard API parameter - output; indicates the overall
462: * status of the API call
463: * @param x_msg_count standard API parameter - output; holds the number of
464: * messages in the API message list
465: * @param x_msg_data standard API parameter - output; if the number is one,
466: * then message data holds the message in an encoded format
467: * @param x_creditcard_tbl credit cards of the payer
461: * @param x_return_status standard API parameter - output; indicates the overall
462: * status of the API call
463: * @param x_msg_count standard API parameter - output; holds the number of
464: * messages in the API message list
465: * @param x_msg_data standard API parameter - output; if the number is one,
466: * then message data holds the message in an encoded format
467: * @param x_creditcard_tbl credit cards of the payer
468: * @param x_purchasecard_tbl purchase cards of the payer
469: * @param x_bankacct_tbl bank accounts of the payer
499: * key as an argument in case an instrument is encrypted.
500: *
501: * @param p_api_version version of the API; current version is 1.0
502: * @rep:paraminfo {@rep:required}
503: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
504: * @param p_commit standard API parameter; default as FND_API.G_TRUE
505: * @param p_validation_level standard API parameter; default as
506: * FND_API.G_VALID_LEVEL_FULL
507: * @param p_payer_id payer identifier string
500: *
501: * @param p_api_version version of the API; current version is 1.0
502: * @rep:paraminfo {@rep:required}
503: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
504: * @param p_commit standard API parameter; default as FND_API.G_TRUE
505: * @param p_validation_level standard API parameter; default as
506: * FND_API.G_VALID_LEVEL_FULL
507: * @param p_payer_id payer identifier string
508: * @rep:paraminfo {@rep:required}
501: * @param p_api_version version of the API; current version is 1.0
502: * @rep:paraminfo {@rep:required}
503: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
504: * @param p_commit standard API parameter; default as FND_API.G_TRUE
505: * @param p_validation_level standard API parameter; default as
506: * FND_API.G_VALID_LEVEL_FULL
507: * @param p_payer_id payer identifier string
508: * @rep:paraminfo {@rep:required}
509: * @param p_sys_sec_key instrument registration security key
506: * FND_API.G_VALID_LEVEL_FULL
507: * @param p_payer_id payer identifier string
508: * @rep:paraminfo {@rep:required}
509: * @param p_sys_sec_key instrument registration security key
510: * @param x_return_status standard API parameter - output; indicates the overall
511: * status of the API call
512: * @param x_msg_count standard API parameter - output; holds the number of
513: * messages in the API message list
514: * @param x_msg_data standard API parameter - output; if the number is one,
508: * @rep:paraminfo {@rep:required}
509: * @param p_sys_sec_key instrument registration security key
510: * @param x_return_status standard API parameter - output; indicates the overall
511: * status of the API call
512: * @param x_msg_count standard API parameter - output; holds the number of
513: * messages in the API message list
514: * @param x_msg_data standard API parameter - output; if the number is one,
515: * then message data holds the message in an encoded format
516: * @param x_creditcard_tbl credit cards of the payer
510: * @param x_return_status standard API parameter - output; indicates the overall
511: * status of the API call
512: * @param x_msg_count standard API parameter - output; holds the number of
513: * messages in the API message list
514: * @param x_msg_data standard API parameter - output; if the number is one,
515: * then message data holds the message in an encoded format
516: * @param x_creditcard_tbl credit cards of the payer
517: * @param x_purchasecard_tbl purchase cards of the payer
518: * @param x_bankacct_tbl bank accounts of the payer
569: * payer_id and instr_id.
570: *
571: * @param p_api_version version of the API; current version is 1.0
572: * @rep:paraminfo {@rep:required}
573: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
574: * @param p_commit standard API parameter; default as FND_API.G_TRUE
575: * @param p_validation_level standard API parameter; default as
576: * FND_API.G_VALID_LEVEL_FULL
577: * @param p_payer_id payer identifier string
570: *
571: * @param p_api_version version of the API; current version is 1.0
572: * @rep:paraminfo {@rep:required}
573: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
574: * @param p_commit standard API parameter; default as FND_API.G_TRUE
575: * @param p_validation_level standard API parameter; default as
576: * FND_API.G_VALID_LEVEL_FULL
577: * @param p_payer_id payer identifier string
578: * @rep:paraminfo {@rep:required}
571: * @param p_api_version version of the API; current version is 1.0
572: * @rep:paraminfo {@rep:required}
573: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
574: * @param p_commit standard API parameter; default as FND_API.G_TRUE
575: * @param p_validation_level standard API parameter; default as
576: * FND_API.G_VALID_LEVEL_FULL
577: * @param p_payer_id payer identifier string
578: * @rep:paraminfo {@rep:required}
579: * @param p_instr_id payment instrument unique identifier
577: * @param p_payer_id payer identifier string
578: * @rep:paraminfo {@rep:required}
579: * @param p_instr_id payment instrument unique identifier
580: * @rep:paraminfo {@rep:required}
581: * @param x_return_status standard API parameter - output; indicates the overall
582: * status of the API call
583: * @param x_msg_count standard API parameter - output; holds the number of
584: * messages in the API message list
585: * @param x_msg_data standard API parameter - output; if the number is one,
579: * @param p_instr_id payment instrument unique identifier
580: * @rep:paraminfo {@rep:required}
581: * @param x_return_status standard API parameter - output; indicates the overall
582: * status of the API call
583: * @param x_msg_count standard API parameter - output; holds the number of
584: * messages in the API message list
585: * @param x_msg_data standard API parameter - output; if the number is one,
586: * then message data holds the message in an encoded format
587: * @param x_pmtInstrRec payment instrument of the payer
581: * @param x_return_status standard API parameter - output; indicates the overall
582: * status of the API call
583: * @param x_msg_count standard API parameter - output; holds the number of
584: * messages in the API message list
585: * @param x_msg_data standard API parameter - output; if the number is one,
586: * then message data holds the message in an encoded format
587: * @param x_pmtInstrRec payment instrument of the payer
588: *
589: * @rep:scope public
616: * as an argument in case the instrument is encrypted.
617: *
618: * @param p_api_version version of the API; current version is 1.0
619: * @rep:paraminfo {@rep:required}
620: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
621: * @param p_commit standard API parameter; default as FND_API.G_TRUE
622: * @param p_validation_level standard API parameter; default as
623: * FND_API.G_VALID_LEVEL_FULL
624: * @param p_payer_id payer identifier string
617: *
618: * @param p_api_version version of the API; current version is 1.0
619: * @rep:paraminfo {@rep:required}
620: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
621: * @param p_commit standard API parameter; default as FND_API.G_TRUE
622: * @param p_validation_level standard API parameter; default as
623: * FND_API.G_VALID_LEVEL_FULL
624: * @param p_payer_id payer identifier string
625: * @rep:paraminfo {@rep:required}
618: * @param p_api_version version of the API; current version is 1.0
619: * @rep:paraminfo {@rep:required}
620: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
621: * @param p_commit standard API parameter; default as FND_API.G_TRUE
622: * @param p_validation_level standard API parameter; default as
623: * FND_API.G_VALID_LEVEL_FULL
624: * @param p_payer_id payer identifier string
625: * @rep:paraminfo {@rep:required}
626: * @param p_instr_id payment instrument unique identifier
625: * @rep:paraminfo {@rep:required}
626: * @param p_instr_id payment instrument unique identifier
627: * @rep:paraminfo {@rep:required}
628: * @param p_sys_sec_key instrument registration security key
629: * @param x_return_status standard API parameter - output; indicates the overall
630: * status of the API call
631: * @param x_msg_count standard API parameter - output; holds the number of
632: * messages in the API message list
633: * @param x_msg_data standard API parameter - output; if the number is one,
627: * @rep:paraminfo {@rep:required}
628: * @param p_sys_sec_key instrument registration security key
629: * @param x_return_status standard API parameter - output; indicates the overall
630: * status of the API call
631: * @param x_msg_count standard API parameter - output; holds the number of
632: * messages in the API message list
633: * @param x_msg_data standard API parameter - output; if the number is one,
634: * then message data holds the message in an encoded format
635: * @param x_pmtInstrRec payment instrument of the payer
629: * @param x_return_status standard API parameter - output; indicates the overall
630: * status of the API call
631: * @param x_msg_count standard API parameter - output; holds the number of
632: * messages in the API message list
633: * @param x_msg_data standard API parameter - output; if the number is one,
634: * then message data holds the message in an encoded format
635: * @param x_pmtInstrRec payment instrument of the payer
636: *
637: * @rep:scope public
655:
656: -------------------------------------------------------------------------------
657: /* UTILITY FUNCTION#1: ENCODE
658: This function returns a Base64 encoded string.
659: This function is being used temporarily as there is no standard function available
660: in 8i. It is available in 9i though. This should be discarded when used for 9i.
661: */
662: -------------------------------------------------------------------------------
663:
665:
666: -------------------------------------------------------------------------------
667: /* UTILITY FUNCTION#2: DECODE
668: This function returns a decoded string for a Base64 encoded string.
669: This function is being used temporarily as there is no standard function available
670: in 8i. It is available in 9i though. This should be discarded when used for 9i.
671: */
672: -------------------------------------------------------------------------------
673: FUNCTION decode(s IN VARCHAR2) RETURN VARCHAR2;