DBA Data[Home] [Help]

APPS.XLA_AMB_AAD_PKG dependencies on XLA_LINE_DEFINITIONS_B

Line 1506: , xla_line_definitions_b xld

1502: AND xpa.accounting_required_flag = 'Y'
1503: AND xpa.validation_status_code = 'R'
1504: AND NOT EXISTS (SELECT 'x'
1505: FROM xla_aad_line_defn_assgns xal
1506: , xla_line_definitions_b xld
1507: WHERE xal.application_id = xpa.application_id
1508: AND xal.amb_context_code = xpa.amb_context_code
1509: AND xal.product_rule_type_code = xpa.product_rule_type_code
1510: AND xal.product_rule_code = xpa.product_rule_code

Line 1783: UPDATE xla_line_definitions_b

1779: ,p_line_definition_owner_code => p_line_definition_owner_code
1780: ,p_line_definition_code => p_line_definition_code);
1781:
1782: IF (l_return) THEN
1783: UPDATE xla_line_definitions_b
1784: SET validation_status_code = 'Y' -- Valid
1785: WHERE application_id = p_application_id
1786: AND amb_context_code = p_amb_context_code
1787: AND event_class_code = p_event_class_code

Line 1792: UPDATE xla_line_definitions_b

1788: AND event_type_code = p_event_type_code
1789: AND line_definition_owner_code = p_line_definition_owner_code
1790: AND line_definition_code = p_line_definition_code;
1791: ELSE
1792: UPDATE xla_line_definitions_b
1793: SET validation_status_code = 'E' -- Invalid
1794: WHERE application_id = p_application_id
1795: AND amb_context_code = p_amb_context_code
1796: AND event_class_code = p_event_class_code

Line 1843: ,xla_line_definitions_b xld

1839: CURSOR c_line_definitions IS
1840: SELECT distinct xld.event_class_code, xld.event_type_code,
1841: xld.line_definition_owner_code, xld.line_definition_code
1842: FROM xla_aad_line_defn_assgns xal
1843: ,xla_line_definitions_b xld
1844: WHERE xld.application_id = xal.application_id
1845: AND xld.amb_context_code = xal.amb_context_code
1846: AND xld.event_class_code = xal.event_class_code
1847: AND xld.event_type_code = xal.event_type_code