APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_UTILITY_PVT

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

367: ELSIF p_format_type = 'FEDERAL_SUMMARY' THEN
368: G_Extract_Run_Mode := G_EXTRACT_MODE_FV_SMMY;
369:
370: IF p_save_extract_flag IS NOT NULL THEN
371: iby_utility_pvt.set_view_param(G_VP_FV_ECS_SEQ, p_save_extract_flag);
372: END IF;
373:
374: -- revert the param to its original function
375: l_save_extract_flag := 'N';

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

538: debug_level => G_LEVEL_STATEMENT,
539: module => l_Debug_Module);
540: END IF;
541: initialize;
542: iby_utility_pvt.set_view_param(G_VP_INSTR_ID,p_payment_instruction_id);
543:
544: Validate_and_Set_Syskey(p_sys_key);
545: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
546: iby_debug_pub.add(debug_msg => 'Before XML query ',

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

635: iby_security_pkg.validate_sys_key(p_sys_key,lx_err_code);
636: IF (NOT lx_err_code IS NULL) THEN
637: raise_application_error(-20000,lx_err_code, FALSE);
638: END IF;
639: iby_utility_pvt.set_view_param(G_VP_SYS_KEY,p_sys_key);
640: END IF;
641:
642: END Validate_and_Set_Syskey;
643:

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

657: debug_level => G_LEVEL_PROCEDURE,
658: module => l_Debug_Module);
659: iby_debug_pub.log(l_Debug_Module,'Enter:TIMESTAMP:: PPR Extract' || l_Debug_Module||':: '||systimestamp,FND_LOG.LEVEL_STATEMENT);
660:
661: iby_utility_pvt.set_view_param(G_VP_INSTR_ID,p_payment_service_request_id);
662:
663: iby_utility_pvt.set_view_param(G_VP_FMT_TYPE,'PAYMENT_PROCESS_REQUEST_REPORT');
664:
665: Validate_and_Set_Syskey(p_sys_key);

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

659: iby_debug_pub.log(l_Debug_Module,'Enter:TIMESTAMP:: PPR Extract' || l_Debug_Module||':: '||systimestamp,FND_LOG.LEVEL_STATEMENT);
660:
661: iby_utility_pvt.set_view_param(G_VP_INSTR_ID,p_payment_service_request_id);
662:
663: iby_utility_pvt.set_view_param(G_VP_FMT_TYPE,'PAYMENT_PROCESS_REQUEST_REPORT');
664:
665: Validate_and_Set_Syskey(p_sys_key);
666:
667: G_Extract_Run_Mode := G_EXTRACT_MODE_PPR_RPT;

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

2821: p_fv_treasury_symbol_agg XMLTYPE) IS
2822: SELECT XMLElement("FederalInstructionInfo",
2823: XMLElement("TreasurySymbols", p_fv_treasury_symbol_agg),
2824: XMLElement("ControlNumber", control_number),
2825: XMLElement("ECSSummaryDosSeqNumber", iby_utility_pvt.get_view_param('FV_ECS_SEQ'))
2826: )
2827: FROM fv_summary_consolidate
2828: WHERE payment_instruction_id = p_payment_instruction_id;
2829:

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

5489: debug_level => G_LEVEL_STATEMENT,
5490: module => l_Debug_Module);
5491: END IF;
5492:
5493: l_card_num := iby_creditcard_pkg.uncipher_ccnumber(l_instrid, iby_utility_pvt.get_view_param('SYS_KEY'));
5494:
5495: END IF;
5496:
5497: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

5590: debug_level => G_LEVEL_STATEMENT,
5591: module => l_Debug_Module);
5592: END IF;
5593:
5594: l_card_num := iby_creditcard_pkg.uncipher_ccnumber(l_instrid, iby_utility_pvt.get_view_param('SYS_KEY'));
5595:
5596: OPEN cc_num_ext_agg (l_card_num);
5597: FETCH cc_num_ext_agg INTO l_card_num_agg;
5598: CLOSE cc_num_ext_agg;