DBA Data[Home] [Help]

APPS.IBY_EXTRACTGEN_PVT dependencies on IBY_DOCS_PAYABLE_ALL

Line 488: FROM IBY_DOCS_PAYABLE_ALL

484: l_from_clause := ' From ' || p_entity_table;
485: l_where_clause := ' Where document_payable_id = :p_entity_id ';
486: SELECT attribute_category
487: INTO l_attribute_category
488: FROM IBY_DOCS_PAYABLE_ALL
489: WHERE document_payable_id = p_entity_id;
490:
491: ELSIF p_entity_table = G_DFF_FORMAT THEN
492: l_num_of_attributes := 15;

Line 581: FROM iby_docs_payable_all idp

577: print_debuginfo (l_debug_module, 'Before Execution the query for the table:'||G_DFF_AP_DOC);
578:
579: SELECT attribute_category
580: INTO l_attribute_category
581: FROM iby_docs_payable_all idp
582: WHERE idp.document_payable_id = p_entity_id;
583:
584: IF(l_attribute_category IS NULL) THEN
585: Select XMLConcat(XMLElement("AttributeCategory", attribute_category),

Line 595: From iby_docs_payable_all idp

591: XMLElement("Attribute11", attribute11), XMLElement("Attribute12", attribute12),
592: XMLElement("Attribute13", attribute13), XMLElement("Attribute14", attribute14),
593: XMLElement("Attribute15", attribute15))
594: INTO l_dffs
595: From iby_docs_payable_all idp
596: WHERE idp.document_payable_id = p_entity_id;
597:
598: ELSE
599: Select XMLConcat(XMLElement("AttributeCategory", attribute_category),

Line 616: From iby_docs_payable_all idp

612: XMLElement("Attribute13", TRANSLATE(attribute13,l_conc_invalid_chars,l_conc_replacement_chars)),
613: XMLElement("Attribute14", TRANSLATE(attribute14,l_conc_invalid_chars,l_conc_replacement_chars)),
614: XMLElement("Attribute15", TRANSLATE(attribute15,l_conc_invalid_chars,l_conc_replacement_chars)))
615: INTO l_dffs
616: From iby_docs_payable_all idp
617: WHERE idp.document_payable_id = p_entity_id;
618: END IF;
619: print_debuginfo (l_debug_module, 'After Execution the query for the table: '||G_DFF_AP_DOC);
620: