APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on STANDARD

Line 365: CEP_STANDARD.init_security;

361: iby_debug_pub.add(debug_msg => 'Before XML query ',
362: debug_level => G_LEVEL_STATEMENT,
363: module => l_Debug_Module);
364: END IF;
365: CEP_STANDARD.init_security;
366: OPEN l_ece_csr(p_payment_instruction_id);
367: FETCH l_ece_csr INTO l_ele_channel;
368: CLOSE l_ece_csr;
369: IF l_ele_channel = 'ECE' AND G_Extract_Run_Mode = G_EXTRACT_MODE_PMT THEN

Line 485: CEP_STANDARD.init_security;

481: iby_debug_pub.add(debug_msg => 'Before XML query ',
482: debug_level => G_LEVEL_STATEMENT,
483: module => l_Debug_Module);
484: END IF;
485: CEP_STANDARD.init_security;
486:
487: SELECT XMLType.getClobVal(payment_process_request)
488: INTO x_extract_doc
489: FROM iby_xml_fd_ppr_1_0_v

Line 552: CEP_STANDARD.init_security;

548: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
549: iby_debug_pub.add(debug_msg => 'Before XML query ',debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
550: END IF;
551:
552: CEP_STANDARD.init_security;
553:
554: IF p_payment_instruction_id <> -99 THEN
555: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
556: iby_debug_pub.add(debug_msg => 'payment instruction id is supplied ',debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);

Line 831: CEP_STANDARD.init_security;

827:
828:
829:
830: Validate_and_Set_Syskey(p_sys_key);
831: CEP_STANDARD.init_security;
832:
833:
834: --parameter editing
835: l_from_date := p_from_date;

Line 1280: pv.standard_industry_class,

1276: SELECT pvs.vendor_site_code,
1277: pv.num_1099,
1278: pv.global_attribute2,
1279: pv.global_attribute3,
1280: pv.standard_industry_class,
1281: pvs.address_line1,
1282: pvs.address_line2,
1283: pvs.address_line3,
1284: pvs.city,

Line 1302: pv.standard_industry_class,

1298: SELECT decode(pvs.country,'ES',pv.vendor_name,'GR',pvs.vendor_site_code),
1299: pv.num_1099,
1300: pv.global_attribute2,
1301: pv.global_attribute3,
1302: pv.standard_industry_class,
1303: pvs.address_line1,
1304: pvs.address_line2,
1305: pvs.address_line3,
1306: pvs.city,

Line 1325: -- Standard Start of API savepoint

1321:
1322: x_msg_count := NULL;
1323: x_msg_data := NULL;
1324:
1325: -- Standard Start of API savepoint
1326: SAVEPOINT Get_LegalInformation;
1327:
1328: -- Standard call to check for call compatibility.
1329: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 1328: -- Standard call to check for call compatibility.

1324:
1325: -- Standard Start of API savepoint
1326: SAVEPOINT Get_LegalInformation;
1327:
1328: -- Standard call to check for call compatibility.
1329: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1330: p_api_version,
1331: l_api_name,
1332: G_PKG_NAME ) THEN

Line 2072: 'VOID_BY_SETUP', 'VOID_BY_OVERFLOW') AND ins.process_type = 'STANDARD') OR

2068: WHERE
2069: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
2070: AND ins.payment_instruction_id = xml_pmt_lvl.payment_instruction_id
2071: AND ((xml_pmt_lvl.payment_status in ('INSTRUCTION_CREATED',
2072: 'VOID_BY_SETUP', 'VOID_BY_OVERFLOW') AND ins.process_type = 'STANDARD') OR
2073: ins.process_type = 'IMMEDIATE');
2074:
2075: -- for payment format: reprint individual and ranges
2076: CURSOR l_payerinstr_reprt_csr (p_payment_instruction_id IN NUMBER) IS

Line 2085: 'VOID_BY_SETUP_REPRINT', 'VOID_BY_OVERFLOW_REPRINT') AND ins.process_type = 'STANDARD') OR

2081: WHERE
2082: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
2083: AND ins.payment_instruction_id = xml_pmt_lvl.payment_instruction_id
2084: AND ((xml_pmt_lvl.payment_status in ('READY_TO_REPRINT',
2085: 'VOID_BY_SETUP_REPRINT', 'VOID_BY_OVERFLOW_REPRINT') AND ins.process_type = 'STANDARD') OR
2086: ins.process_type = 'IMMEDIATE');
2087:
2088: -- for payment instruction register
2089: -- we are extract payments in all statuses