APPS.IBY_EXTRACTGEN_PVT dependencies on IBY_EXTRACTGEN_PVT

Line 1: PACKAGE BODY IBY_EXTRACTGEN_PVT AS

1: PACKAGE BODY IBY_EXTRACTGEN_PVT AS
2: /* $Header: ibyxgenb.pls 120.59.12020000.2 2012/07/12 15:09:23 sgogula ship $ */
3:
4: -- Global variables
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_EXTRACTGEN_PVT';

3:
4: -- Global variables
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_EXTRACTGEN_PVT';
8:
9: TYPE l_attribute_cat_rec_type IS RECORD(
10: l_hzp_attr_cat VARCHAR2(150)
11: );

Line 526: x_extract_doc := IBY_EXTRACTGEN_PVT.Get_XML_Char_Encoding_Header || x_extract_doc;

522:
523: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
524: print_debuginfo(l_module_name, 'Appending XML Character Encoding Header');
525: END IF;
526: x_extract_doc := IBY_EXTRACTGEN_PVT.Get_XML_Char_Encoding_Header || x_extract_doc;
527:
528: IF l_numeric_char_mask <> l_default_num_mask THEN
529: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '||
530: '"'||l_numeric_char_mask|| '"';

Line 639: IF IBY_EXTRACTGEN_PVT.Is_Flex_Field_Enabled('AP_INVOICES',200) THEN

635: FROM AP_CHECKS_ALL
636: WHERE payment_id = p_entity_id;
637:
638: ELSIF p_entity_table = G_DFF_FD_DOC_PAYABLE THEN
639: IF IBY_EXTRACTGEN_PVT.Is_Flex_Field_Enabled('AP_INVOICES',200) THEN
640: l_num_of_attributes := 15;
641: l_from_clause := ' From ' || p_entity_table;
642: l_where_clause := ' Where document_payable_id = :p_entity_id ';
643: SELECT attribute_category

Line 745: IF IBY_EXTRACTGEN_PVT.Is_Flex_Field_Enabled('AP_INVOICES',200) THEN

741: WHERE VENDOR_SITE_ID = p_entity_id;
742:
743: ELSIF p_entity_table = G_DFF_AP_DOC THEN
744:
745: IF IBY_EXTRACTGEN_PVT.Is_Flex_Field_Enabled('AP_INVOICES',200) THEN
746: /* Bug 6763515*/
747: print_debuginfo (l_debug_module, 'Before Execution the query for the table:'||G_DFF_AP_DOC);
748:
749: SELECT attribute_category

Line 979: END IBY_EXTRACTGEN_PVT;

975: l_conc_invalid_chars :=l_conc_invalid_chars||fnd_global.local_chr(i-1);
976: l_conc_replacement_chars :=l_conc_replacement_chars||' ';
977: END LOOP;
978:
979: END IBY_EXTRACTGEN_PVT;