115: );
116:
117: PROCEDURE Setup_for_Extract
118: (
119: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
120: );
121:
122: FUNCTION Get_Payer_Notif_Where_cluase
123: (
234: p_toPSON IN VARCHAR2,
235: p_delivery_method IN VARCHAR2,
236: p_format_code IN VARCHAR2,
237: p_txn_id IN NUMBER,
238: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
239: x_extract_doc OUT NOCOPY CLOB
240: )
241: IS
242: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Create_Payer_Notif_Extract_1_0';
375:
376: -- shared. Main entry point for FC accompany letter
377: PROCEDURE Setup_for_Extract
378: (
379: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
380: )
381: IS
382: lx_err_code VARCHAR2(30);
383: l_xml_base VARCHAR2(255);
400: debug_level => FND_LOG.LEVEL_STATEMENT,
401: module => l_Debug_Module);
402:
403: IF (NOT p_sys_key IS NULL) THEN
404: iby_security_pkg.validate_sys_key(p_sys_key,lx_err_code);
405: IF (NOT lx_err_code IS NULL) THEN
406: raise_application_error(-20000,lx_err_code, FALSE);
407: END IF;
408: iby_utility_pvt.set_view_param(G_VP_SYS_KEY,p_sys_key);
415: (
416: p_instr_type IN VARCHAR2,
417: p_req_type IN VARCHAR2,
418: p_txn_id IN NUMBER,
419: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
420: x_extract_doc OUT NOCOPY CLOB
421: )
422: IS
423: l_Debug_Module VARCHAR2(255) :=
472: (
473: p_instr_type IN VARCHAR2,
474: p_req_type IN VARCHAR2,
475: p_txn_id IN NUMBER,
476: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
477: p_sec_val IN VARCHAR2,
478: x_extract_doc OUT NOCOPY CLOB
479: )
480: IS