APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_UTILITY_PVT

Line 221: iby_utility_pvt.set_view_param(G_VP_FV_ECS_SEQ, p_save_extract_flag);

217: ELSIF p_format_type = 'FEDERAL_SUMMARY' THEN
218: G_Extract_Run_Mode := G_EXTRACT_MODE_FV_SMMY;
219:
220: IF p_save_extract_flag IS NOT NULL THEN
221: iby_utility_pvt.set_view_param(G_VP_FV_ECS_SEQ, p_save_extract_flag);
222: END IF;
223:
224: -- revert the param to its original function
225: l_save_extract_flag := 'N';

Line 357: iby_utility_pvt.set_view_param(G_VP_INSTR_ID,p_payment_instruction_id);

353: debug_level => G_LEVEL_STATEMENT,
354: module => l_Debug_Module);
355: END IF;
356: initialize;
357: iby_utility_pvt.set_view_param(G_VP_INSTR_ID,p_payment_instruction_id);
358:
359: Validate_and_Set_Syskey(p_sys_key);
360: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
361: iby_debug_pub.add(debug_msg => 'Before XML query ',

Line 448: iby_utility_pvt.set_view_param(G_VP_SYS_KEY,p_sys_key);

444: iby_security_pkg.validate_sys_key(p_sys_key,lx_err_code);
445: IF (NOT lx_err_code IS NULL) THEN
446: raise_application_error(-20000,lx_err_code, FALSE);
447: END IF;
448: iby_utility_pvt.set_view_param(G_VP_SYS_KEY,p_sys_key);
449: END IF;
450:
451: END Validate_and_Set_Syskey;
452:

Line 466: iby_utility_pvt.set_view_param(G_VP_INSTR_ID,p_payment_service_request_id);

462: l_trxn_doc_id NUMBER;
463: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Create_PPR_Extract_1_0';
464: BEGIN
465:
466: iby_utility_pvt.set_view_param(G_VP_INSTR_ID,p_payment_service_request_id);
467:
468: iby_utility_pvt.set_view_param(G_VP_FMT_TYPE,'PAYMENT_PROCESS_REQUEST_REPORT');
469:
470: Validate_and_Set_Syskey(p_sys_key);

Line 468: iby_utility_pvt.set_view_param(G_VP_FMT_TYPE,'PAYMENT_PROCESS_REQUEST_REPORT');

464: BEGIN
465:
466: iby_utility_pvt.set_view_param(G_VP_INSTR_ID,p_payment_service_request_id);
467:
468: iby_utility_pvt.set_view_param(G_VP_FMT_TYPE,'PAYMENT_PROCESS_REQUEST_REPORT');
469:
470: Validate_and_Set_Syskey(p_sys_key);
471:
472: G_Extract_Run_Mode := G_EXTRACT_MODE_PPR_RPT;

Line 2028: XMLElement("ECSSummaryDosSeqNumber", iby_utility_pvt.get_view_param('FV_ECS_SEQ'))

2024: p_fv_treasury_symbol_agg XMLTYPE) IS
2025: SELECT XMLElement("FederalInstructionInfo",
2026: XMLElement("TreasurySymbols", p_fv_treasury_symbol_agg),
2027: XMLElement("ControlNumber", control_number),
2028: XMLElement("ECSSummaryDosSeqNumber", iby_utility_pvt.get_view_param('FV_ECS_SEQ'))
2029: )
2030: FROM fv_summary_consolidate
2031: WHERE payment_instruction_id = p_payment_instruction_id;
2032:

Line 3929: l_card_num := iby_creditcard_pkg.uncipher_ccnumber(l_instrid, iby_utility_pvt.get_view_param('SYS_KEY'));

3925: debug_level => G_LEVEL_STATEMENT,
3926: module => l_Debug_Module);
3927: END IF;
3928:
3929: l_card_num := iby_creditcard_pkg.uncipher_ccnumber(l_instrid, iby_utility_pvt.get_view_param('SYS_KEY'));
3930:
3931: END IF;
3932:
3933: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN