DBA Data[Home] [Help]

APPS.XLA_AAD_UPLOAD_PVT dependencies on XLA_PRODUCT_RULES_B

Line 3518: INSERT INTO xla_product_rules_b

3514: p_module => l_log_module,
3515: p_level => C_LEVEL_PROCEDURE);
3516: END IF;
3517:
3518: INSERT INTO xla_product_rules_b
3519: (application_id
3520: ,amb_context_code
3521: ,product_rule_type_code
3522: ,product_rule_code

Line 3557: ,xla_product_rules_b xpr

3553: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3554: ,fnd_load_util.owner_id(xal.owner)
3555: ,0
3556: FROM xla_aad_loader_defns_t xal
3557: ,xla_product_rules_b xpr
3558: ,fnd_id_flex_structures fift
3559: ,fnd_id_flex_structures fifa
3560: WHERE fift.application_id(+) = 101
3561: AND fift.id_flex_code(+) = 'GL#'

Line 3575: trace(p_msg => '# insert (XLA_PRODUCT_RULES_B) = '||l_num_rows,

3571: AND xal.staging_amb_context_code = p_staging_context_code;
3572:
3573: l_num_rows := SQL%ROWCOUNT;
3574: IF (C_LEVEL_EVENT >= g_log_level) THEN
3575: trace(p_msg => '# insert (XLA_PRODUCT_RULES_B) = '||l_num_rows,
3576: p_module => l_log_module,
3577: p_level => C_LEVEL_EVENT);
3578: END IF;
3579:

Line 3587: p_encoded_message => '# insert (XLA_PRODUCT_RULES_B) = '||l_num_rows,

3583: p_amb_context_code => p_staging_context_code,
3584: p_application_id => p_application_id,
3585: p_request_code => 'IMPORT' ,
3586: p_log_type_code => 'UPLOAD',
3587: p_encoded_message => '# insert (XLA_PRODUCT_RULES_B) = '||l_num_rows,
3588: p_component_code => 'populate_aads');
3589:
3590: INSERT INTO xla_product_rules_tl
3591: (application_id

Line 4214: AD_ZD_SEED.PREPARE('XLA_PRODUCT_RULES_B');

4210: AD_ZD_SEED.PREPARE('XLA_MPA_HEADER_AC_ASSGNS');
4211: AD_ZD_SEED.PREPARE('XLA_MPA_JLT_ASSGNS');
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');