DBA Data[Home] [Help]

APPS.XLA_AAD_UPLOAD_PVT dependencies on XLA_PROD_ACCT_HEADERS

Line 3642: INSERT INTO xla_prod_acct_headers

3638: p_log_type_code => 'UPLOAD',
3639: p_encoded_message => '# insert (XLA_PRODUCT_RULES_TL) = '||l_num_rows,
3640: p_component_code => 'populate_aads');
3641:
3642: INSERT INTO xla_prod_acct_headers
3643: (application_id
3644: ,amb_context_code
3645: ,product_rule_type_code
3646: ,product_rule_code

Line 3679: WHERE table_name = 'XLA_PROD_ACCT_HEADERS'

3675: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3676: ,fnd_load_util.owner_id(owner)
3677: ,0
3678: FROM xla_aad_loader_defns_t
3679: WHERE table_name = 'XLA_PROD_ACCT_HEADERS'
3680: AND staging_amb_context_code = p_staging_context_code;
3681:
3682: l_num_rows := SQL%ROWCOUNT;
3683: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 3684: trace(p_msg => '# insert (XLA_PROD_ACCT_HEADERS) = '||l_num_rows,

3680: AND staging_amb_context_code = p_staging_context_code;
3681:
3682: l_num_rows := SQL%ROWCOUNT;
3683: IF (C_LEVEL_EVENT >= g_log_level) THEN
3684: trace(p_msg => '# insert (XLA_PROD_ACCT_HEADERS) = '||l_num_rows,
3685: p_module => l_log_module,
3686: p_level => C_LEVEL_EVENT);
3687: END IF;
3688:

Line 3696: p_encoded_message => '# insert (XLA_PROD_ACCT_HEADERS) = '||l_num_rows,

3692: p_amb_context_code => p_staging_context_code,
3693: p_application_id => p_application_id,
3694: p_request_code => 'IMPORT' ,
3695: p_log_type_code => 'UPLOAD',
3696: p_encoded_message => '# insert (XLA_PROD_ACCT_HEADERS) = '||l_num_rows,
3697: p_component_code => 'populate_aads');
3698:
3699: INSERT INTO xla_aad_hdr_acct_attrs
3700: (application_id

Line 4216: AD_ZD_SEED.PREPARE('XLA_PROD_ACCT_HEADERS');

4212: AD_ZD_SEED.PREPARE('XLA_MPA_JLT_AC_ASSGNS');
4213: AD_ZD_SEED.PREPARE('XLA_MPA_JLT_ADR_ASSGNS');
4214: AD_ZD_SEED.PREPARE('XLA_PRODUCT_RULES_B');
4215: AD_ZD_SEED.PREPARE('XLA_PRODUCT_RULES_TL');
4216: AD_ZD_SEED.PREPARE('XLA_PROD_ACCT_HEADERS');
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');