DBA Data[Home] [Help]

APPS.XLA_AAD_UPLOAD_PVT dependencies on XLA_PRODUCT_RULES_B

Line 2944: INSERT INTO xla_product_rules_b

2940: p_module => l_log_module,
2941: p_level => C_LEVEL_PROCEDURE);
2942: END IF;
2943:
2944: INSERT INTO xla_product_rules_b
2945: (application_id
2946: ,amb_context_code
2947: ,product_rule_type_code
2948: ,product_rule_code

Line 2983: ,xla_product_rules_b xpr

2979: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2980: ,fnd_load_util.owner_id(xal.owner)
2981: ,0
2982: FROM xla_aad_loader_defns_t xal
2983: ,xla_product_rules_b xpr
2984: ,fnd_id_flex_structures fift
2985: ,fnd_id_flex_structures fifa
2986: WHERE fift.application_id(+) = 101
2987: AND fift.id_flex_code(+) = 'GL#'

Line 3000: trace(p_msg => '# insert (XLA_PRODUCT_RULES_B) = '||SQL%ROWCOUNT,

2996: AND xal.table_name = 'XLA_PRODUCT_RULES'
2997: AND xal.staging_amb_context_code = p_staging_context_code;
2998:
2999: IF (C_LEVEL_EVENT >= g_log_level) THEN
3000: trace(p_msg => '# insert (XLA_PRODUCT_RULES_B) = '||SQL%ROWCOUNT,
3001: p_module => l_log_module,
3002: p_level => C_LEVEL_EVENT);
3003: END IF;
3004: