[Home] [Help]
373: update_extract_lines_table;
374:
375:
376: ---------------------------------------------------------------------
377: -- Now merge rows into gmf_transaction_valuation table.
378: ---------------------------------------------------------------------
379: g_log_msg := 'Calling proc XLA_EVENTS_PKG.merge_into_gtv';
380:
381: print_debug(g_log_msg);
1376: message => g_log_msg
1377: );
1378: END IF;
1379:
1380: delete from gmf_transaction_valuation
1381: where (transaction_id, ledger_id, valuation_cost_type_id,
1382: -- transaction_source_type_id,
1383: event_class_code) IN
1384: (select eh.transaction_id, eh.ledger_id, eh.valuation_cost_type_id,
1403: message => g_log_msg
1404: );
1405: END IF;
1406:
1407: INSERT INTO gmf_transaction_valuation
1408: (
1409: valuation_id
1410: , header_id
1411: , event_id
1451: , program_id
1452: , request_id
1453: )
1454: SELECT
1455: gmf_transaction_valuation_S.nextval
1456: , a.header_id
1457: , a.event_id
1458: , a.ledger_id
1459: , a.legal_entity_id
2242:
2243: --
2244: -- Update transaction valuation table
2245: --
2246: g_log_msg := 'Updating gmf_transaction_valuation table';
2247:
2248: print_debug(g_log_msg);
2249: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2250: THEN
2254: message => g_log_msg
2255: );
2256: END IF;
2257:
2258: UPDATE gmf_transaction_valuation
2259: SET accounted_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
2260: , final_posting_date = DECODE(G_accounting_mode, 'F', sysdate, NULL)
2261: , last_update_date = sysdate
2262: , last_updated_by = g_user_id
2277: and xpae.event_class_code = gxem.event_class_code
2278: )
2279: AND ACCOUNTED_FLAG IS NOT NULL -- B7395353 Rajesh Patangya
2280: ;
2281: g_log_msg := sql%rowcount || ' rows updated in gmf_transaction_valuation table';
2282:
2283: print_debug(g_log_msg);
2284: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2285: THEN
2581:
2582: --
2583: -- Update transaction valuation table
2584: --
2585: g_log_msg := 'Updating gmf_transaction_valuation table';
2586:
2587: print_debug(g_log_msg);
2588: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2589: THEN
2593: message => g_log_msg
2594: );
2595: END IF;
2596:
2597: UPDATE gmf_transaction_valuation
2598: SET accounted_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
2599: , final_posting_date = DECODE(G_accounting_mode, 'F', sysdate, NULL)
2600: , last_update_date = sysdate
2601: , last_updated_by = g_user_id
2616: and xpae.event_class_code = gxem.event_class_code
2617: )
2618: AND ACCOUNTED_FLAG IS NOT NULL -- B7395353 Rajesh Patangya
2619: ;
2620: g_log_msg := sql%rowcount || ' rows updated in gmf_transaction_valuation table';
2621:
2622: print_debug(g_log_msg);
2623: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2624: THEN
2900:
2901: --
2902: -- Update transaction valuation table
2903: --
2904: g_log_msg := 'Updating gmf_transaction_valuation table';
2905:
2906: print_debug(g_log_msg);
2907: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2908: THEN
2912: message => g_log_msg
2913: );
2914: END IF;
2915:
2916: UPDATE gmf_transaction_valuation
2917: SET accounted_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
2918: , final_posting_date = DECODE(G_accounting_mode, 'F', sysdate, NULL)
2919: , last_update_date = sysdate
2920: , last_updated_by = g_user_id
2935: and xpae.event_class_code = gxem.event_class_code
2936: )
2937: AND ACCOUNTED_FLAG IS NOT NULL -- B7395353 Rajesh Patangya
2938: ;
2939: g_log_msg := sql%rowcount || ' rows updated in gmf_transaction_valuation table';
2940:
2941: print_debug(g_log_msg);
2942: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2943: THEN
3273:
3274: --
3275: -- Update transaction valuation table
3276: --
3277: g_log_msg := 'Updating gmf_transaction_valuation table';
3278:
3279: print_debug(g_log_msg);
3280: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3281: THEN
3285: message => g_log_msg
3286: );
3287: END IF;
3288:
3289: UPDATE gmf_transaction_valuation
3290: SET accounted_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
3291: , final_posting_date = DECODE(G_accounting_mode, 'F', sysdate, NULL)
3292: , last_update_date = sysdate
3293: , last_updated_by = g_user_id
3308: and xpae.event_class_code = gxem.event_class_code
3309: )
3310: AND ACCOUNTED_FLAG IS NOT NULL -- B7395353 Rajesh Patangya
3311: ;
3312: g_log_msg := sql%rowcount || ' rows updated in gmf_transaction_valuation table';
3313:
3314: print_debug(g_log_msg);
3315: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3316: THEN
3563:
3564: --
3565: -- Update transaction valuation table
3566: --
3567: g_log_msg := 'Updating gmf_transaction_valuation table';
3568:
3569: print_debug(g_log_msg);
3570: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3571: THEN
3575: message => g_log_msg
3576: );
3577: END IF;
3578:
3579: UPDATE gmf_transaction_valuation
3580: SET accounted_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
3581: , final_posting_date = DECODE(G_accounting_mode, 'F', sysdate, NULL)
3582: , last_update_date = sysdate
3583: , last_updated_by = g_user_id
3598: and xpae.event_class_code = gxem.event_class_code
3599: )
3600: AND ACCOUNTED_FLAG IS NOT NULL -- B7395353 Rajesh Patangya
3601: ;
3602: g_log_msg := sql%rowcount || ' rows updated in gmf_transaction_valuation table';
3603:
3604: print_debug(g_log_msg);
3605: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3606: THEN