DBA Data[Home] [Help]

APPS.XLA_AAD_UPLOAD_PVT dependencies on XLA_ACCTG_METHOD_RULES

Line 3975: INSERT INTO xla_acctg_method_rules

3971: p_log_type_code => 'UPLOAD',
3972: p_encoded_message => '# insert (XLA_STAGING_ACCTG_METHODS) = '||l_num_rows,
3973: p_component_code => 'populate_acctg_methods');
3974:
3975: INSERT INTO xla_acctg_method_rules
3976: (amb_context_code
3977: ,accounting_method_type_code
3978: ,accounting_method_code
3979: ,acctg_method_rule_id

Line 3994: ,xla_acctg_method_rules_s.nextval

3990: SELECT
3991: p_staging_context_code
3992: ,accounting_method_type_code
3993: ,accounting_method_code
3994: ,xla_acctg_method_rules_s.nextval
3995: ,p_application_id
3996: ,product_rule_type_code
3997: ,product_rule_code
3998: ,start_date_active

Line 4006: WHERE table_name = 'XLA_ACCTG_METHOD_RULES'

4002: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
4003: ,fnd_load_util.owner_id(owner)
4004: ,0
4005: FROM xla_aad_loader_defns_t
4006: WHERE table_name = 'XLA_ACCTG_METHOD_RULES'
4007: AND staging_amb_context_code = p_staging_context_code;
4008:
4009: l_num_rows := SQL%ROWCOUNT;
4010:

Line 4018: p_encoded_message => '# insert (XLA_ACCTG_METHOD_RULES) = '||l_num_rows,

4014: p_amb_context_code => p_staging_context_code,
4015: p_application_id => p_application_id,
4016: p_request_code => 'IMPORT' ,
4017: p_log_type_code => 'UPLOAD',
4018: p_encoded_message => '# insert (XLA_ACCTG_METHOD_RULES) = '||l_num_rows,
4019: p_component_code => 'populate_acctg_methods');
4020:
4021: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4022: trace(p_msg => 'END of procedure populate_acctg_methods',

Line 4221: AD_ZD_SEED.PREPARE('XLA_ACCTG_METHOD_RULES');

4217: AD_ZD_SEED.PREPARE('XLA_AAD_HDR_ACCT_ATTRS');
4218: AD_ZD_SEED.PREPARE('XLA_AAD_LINE_DEFN_ASSGNS');
4219: AD_ZD_SEED.PREPARE('XLA_AAD_HEADER_AC_ASSGNS');
4220: AD_ZD_SEED.PREPARE('XLA_STAGE_ACCTG_METHODS');
4221: AD_ZD_SEED.PREPARE('XLA_ACCTG_METHOD_RULES');
4222: AD_ZD_SEED.PREPARE('XLA_STAGING_COMPONENTS_H');
4223: AD_ZD_SEED.PREPARE('XLA_ACCTG_METHODS_B'); --Bug 16208537
4224: AD_ZD_SEED.PREPARE('XLA_ACCTG_METHODS_TL'); --Bug 16208537
4225: