[Home] [Help]
382: update_extract_lines_table;
383:
384:
385: ---------------------------------------------------------------------
386: -- Now merge rows into gmf_transaction_valuation table.
387: ---------------------------------------------------------------------
388: g_log_msg := 'Calling proc XLA_EVENTS_PKG.merge_into_gtv';
389:
390: print_debug(g_log_msg);
1417: END IF;
1418:
1419: /* Bug 12647482 Following delete statement commented and replaced with sebsequent one. */
1420: /*
1421: delete from gmf_transaction_valuation
1422: where (transaction_id, ledger_id, valuation_cost_type_id,
1423: -- transaction_source_type_id,
1424: event_class_code) IN
1425: (select eh.transaction_id, eh.ledger_id, eh.valuation_cost_type_id,
1433: ;
1434: */
1435:
1436: /* Bug 12647482 */
1437: DELETE FROM gmf_transaction_valuation
1438: WHERE (transaction_id, ledger_id, valuation_cost_type_id, event_class_code)
1439: IN (
1440: select transaction_id, ledger_id, valuation_cost_type_id, event_class_code
1441: from gmf_xla_extract_headers_gt
1452: message => g_log_msg
1453: );
1454: END IF;
1455:
1456: INSERT INTO gmf_transaction_valuation
1457: (
1458: valuation_id
1459: , header_id
1460: , event_id
1500: , program_id
1501: , request_id
1502: )
1503: SELECT
1504: gmf_transaction_valuation_S.nextval
1505: , a.header_id
1506: , a.event_id
1507: , a.ledger_id
1508: , a.legal_entity_id
2470:
2471: --
2472: -- Update transaction valuation table
2473: --
2474: g_log_msg := 'Updating gmf_transaction_valuation table';
2475:
2476: print_debug(g_log_msg);
2477: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2478: THEN
2482: message => g_log_msg
2483: );
2484: END IF;
2485:
2486: UPDATE gmf_transaction_valuation
2487: SET accounted_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
2488: , final_posting_date = DECODE(G_accounting_mode, 'F', sysdate, NULL)
2489: , last_update_date = sysdate
2490: , last_updated_by = g_user_id
2505: and xpae.event_class_code = gxem.event_class_code
2506: )
2507: AND ACCOUNTED_FLAG IS NOT NULL -- B7395353 Rajesh Patangya
2508: ;
2509: g_log_msg := sql%rowcount || ' rows updated in gmf_transaction_valuation table';
2510: print_debug(g_log_msg);
2511: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2512: THEN
2513: FND_LOG.STRING(
2856:
2857: --
2858: -- Update transaction valuation table
2859: --
2860: g_log_msg := 'Updating gmf_transaction_valuation table';
2861:
2862: print_debug(g_log_msg);
2863: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2864: THEN
2868: message => g_log_msg
2869: );
2870: END IF;
2871:
2872: UPDATE gmf_transaction_valuation
2873: SET accounted_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
2874: , final_posting_date = DECODE(G_accounting_mode, 'F', sysdate, NULL)
2875: , last_update_date = sysdate
2876: , last_updated_by = g_user_id
2891: and xpae.event_class_code = gxem.event_class_code
2892: )
2893: AND ACCOUNTED_FLAG IS NOT NULL -- B7395353 Rajesh Patangya
2894: ;
2895: g_log_msg := sql%rowcount || ' rows updated in gmf_transaction_valuation table';
2896:
2897: print_debug(g_log_msg);
2898: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2899: THEN
3301:
3302: --
3303: -- Update transaction valuation table
3304: --
3305: g_log_msg := 'Updating gmf_transaction_valuation table';
3306:
3307: print_debug(g_log_msg);
3308: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3309: THEN
3313: message => g_log_msg
3314: );
3315: END IF;
3316:
3317: UPDATE gmf_transaction_valuation
3318: SET accounted_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
3319: , final_posting_date = DECODE(G_accounting_mode, 'F', sysdate, NULL)
3320: , last_update_date = sysdate
3321: , last_updated_by = g_user_id
3336: and xpae.event_class_code = gxem.event_class_code
3337: )
3338: AND ACCOUNTED_FLAG IS NOT NULL -- B7395353 Rajesh Patangya
3339: ;
3340: g_log_msg := sql%rowcount || ' rows updated in gmf_transaction_valuation table';
3341:
3342: print_debug(g_log_msg);
3343: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3344: THEN
3675:
3676: --
3677: -- Update transaction valuation table
3678: --
3679: g_log_msg := 'Updating gmf_transaction_valuation table';
3680:
3681: print_debug(g_log_msg);
3682: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3683: THEN
3687: message => g_log_msg
3688: );
3689: END IF;
3690:
3691: UPDATE gmf_transaction_valuation
3692: SET accounted_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
3693: , final_posting_date = DECODE(G_accounting_mode, 'F', sysdate, NULL)
3694: , last_update_date = sysdate
3695: , last_updated_by = g_user_id
3710: and xpae.event_class_code = gxem.event_class_code
3711: )
3712: AND ACCOUNTED_FLAG IS NOT NULL -- B7395353 Rajesh Patangya
3713: ;
3714: g_log_msg := sql%rowcount || ' rows updated in gmf_transaction_valuation table';
3715:
3716: print_debug(g_log_msg);
3717: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3718: THEN
3966:
3967: --
3968: -- Update transaction valuation table
3969: --
3970: g_log_msg := 'Updating gmf_transaction_valuation table';
3971:
3972: print_debug(g_log_msg);
3973: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3974: THEN
3978: message => g_log_msg
3979: );
3980: END IF;
3981:
3982: UPDATE gmf_transaction_valuation
3983: SET accounted_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
3984: , final_posting_date = DECODE(G_accounting_mode, 'F', sysdate, NULL)
3985: , last_update_date = sysdate
3986: , last_updated_by = g_user_id
4001: and xpae.event_class_code = gxem.event_class_code
4002: )
4003: AND ACCOUNTED_FLAG IS NOT NULL -- B7395353 Rajesh Patangya
4004: ;
4005: g_log_msg := sql%rowcount || ' rows updated in gmf_transaction_valuation table';
4006:
4007: print_debug(g_log_msg);
4008: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
4009: THEN