APPS.XLA_AAD_MERGE_PVT dependencies on XLA_PROD_ACCT_HEADERS

Line 442: DELETE FROM xla_prod_acct_headers w

438: p_module => l_log_module,
439: p_level => C_LEVEL_STATEMENT);
440: END IF;
441:
442: DELETE FROM xla_prod_acct_headers w
443: WHERE application_id = g_application_id
444: AND amb_context_code = g_amb_context_code
445: AND product_rule_type_code = C_OWNER_SYSTEM
446: AND NOT EXISTS

Line 448: FROM xla_prod_acct_headers s

444: AND amb_context_code = g_amb_context_code
445: AND product_rule_type_code = C_OWNER_SYSTEM
446: AND NOT EXISTS
447: (SELECT 1
448: FROM xla_prod_acct_headers s
449: WHERE s.application_id = g_application_id
450: AND s.amb_context_code = g_staging_context_code
451: AND s.product_rule_type_code = C_OWNER_SYSTEM
452: AND s.product_rule_code = w.product_rule_code

Line 457: trace(p_msg => '# xla_prod_acct_headers deleted = '||SQL%ROWCOUNT,

453: AND s.event_class_code = w.event_class_code
454: AND s.event_type_code = w.event_type_code);
455:
456: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
457: trace(p_msg => '# xla_prod_acct_headers deleted = '||SQL%ROWCOUNT,
458: p_module => l_log_module,
459: p_level => C_LEVEL_STATEMENT);
460: END IF;
461:

Line 1074: UPDATE xla_prod_acct_headers

1070: p_level => C_LEVEL_STATEMENT);
1071: END IF;
1072:
1073: FORALL i IN 1..l_codes.COUNT
1074: UPDATE xla_prod_acct_headers
1075: SET description_type_code = NULL
1076: , description_code = NULL
1077: WHERE application_id = g_application_id
1078: AND amb_context_code = g_amb_context_code

Line 1083: trace(p_msg => '# xla_prod_acct_headers clear description = '||SQL%ROWCOUNT,

1079: AND description_type_code = C_OWNER_SYSTEM
1080: AND description_code = l_codes(i);
1081:
1082: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1083: trace(p_msg => '# xla_prod_acct_headers clear description = '||SQL%ROWCOUNT,
1084: p_module => l_log_module,
1085: p_level => C_LEVEL_STATEMENT);
1086: END IF;
1087:

Line 1763: DELETE FROM xla_prod_acct_headers w

1759: p_module => l_log_module,
1760: p_level => C_LEVEL_STATEMENT);
1761: END IF;
1762:
1763: DELETE FROM xla_prod_acct_headers w
1764: WHERE application_id = g_application_id
1765: AND amb_context_code = g_amb_context_code
1766: AND EXISTS (SELECT 1
1767: FROM xla_prod_acct_headers s

Line 1767: FROM xla_prod_acct_headers s

1763: DELETE FROM xla_prod_acct_headers w
1764: WHERE application_id = g_application_id
1765: AND amb_context_code = g_amb_context_code
1766: AND EXISTS (SELECT 1
1767: FROM xla_prod_acct_headers s
1768: WHERE s.application_id = g_application_id
1769: AND s.amb_context_code = g_staging_context_code
1770: AND s.product_rule_type_code = w.product_rule_type_code
1771: AND s.product_rule_code = w.product_rule_code

Line 1776: trace(p_msg => '# xla_prod_acct_headers deleted : '||SQL%ROWCOUNT,

1772: AND s.event_class_code = w.event_class_code
1773: AND s.event_type_code = w.event_type_code);
1774:
1775: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1776: trace(p_msg => '# xla_prod_acct_headers deleted : '||SQL%ROWCOUNT,
1777: p_module => l_log_module,
1778: p_level => C_LEVEL_STATEMENT);
1779: END IF;
1780:

Line 1885: UPDATE xla_prod_acct_headers

1881: p_module => l_log_module,
1882: p_level => C_LEVEL_STATEMENT);
1883: END IF;
1884:
1885: UPDATE xla_prod_acct_headers
1886: SET amb_context_code = g_amb_context_code
1887: WHERE application_id = g_application_id
1888: AND amb_context_code = g_staging_context_code;
1889:

Line 1891: trace(p_msg => '# xla_prod_acct_headers updated : '||SQL%ROWCOUNT,

1887: WHERE application_id = g_application_id
1888: AND amb_context_code = g_staging_context_code;
1889:
1890: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1891: trace(p_msg => '# xla_prod_acct_headers updated : '||SQL%ROWCOUNT,
1892: p_module => l_log_module,
1893: p_level => C_LEVEL_STATEMENT);
1894: END IF;
1895: