DBA Data[Home] [Help]

APPS.GMF_XLA_PKG dependencies on GME_RESOURCE_TXNS

Line 3459: g_log_msg := 'Updating gme_resource_txns table for batch material transactions';

3455: --
3456: -- Update resource transaction table
3457: -- Decide what Flag to use when run in Draft Mode.
3458: --
3459: g_log_msg := 'Updating gme_resource_txns table for batch material transactions';
3460:
3461: print_debug(g_log_msg);
3462: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3463: THEN

Line 3471: UPDATE gme_resource_txns

3467: message => g_log_msg
3468: );
3469: END IF;
3470:
3471: UPDATE gme_resource_txns
3472: SET posted_ind = DECODE(G_accounting_mode, 'D', posted_ind, 'F', 1)
3473: , last_update_date = sysdate
3474: , last_updated_by = g_user_id
3475: , last_update_login = g_login_id

Line 3492: g_log_msg := sql%rowcount || ' rows updated in gme_resource_txns table';

3488: and xpae.event_class_code = gxem.event_class_code
3489: )
3490: ;
3491:
3492: g_log_msg := sql%rowcount || ' rows updated in gme_resource_txns table';
3493:
3494: print_debug(g_log_msg);
3495: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3496: THEN

Line 4492: -- p_source_id_int_1: gme_resource_txns.poc_trans_id

4488: IF p_event_class_code = 'BATCH_RESOURCE'
4489: THEN
4490: --
4491: -- Should open Resource Transactions window in Batch Steps form
4492: -- p_source_id_int_1: gme_resource_txns.poc_trans_id
4493: -- p_security_id_int_1: organization_id
4494: --
4495:
4496: SELECT a.batch_id,

Line 4507: gme_resource_txns grt

4503: l_resource,
4504: l_batchstep_activity_id,
4505: l_batchstep_resource_id
4506: FROM gme_batch_step_resources a,
4507: gme_resource_txns grt
4508: WHERE grt.poc_trans_id = p_source_id_int_1
4509: AND grt.line_id = a.batchstep_resource_id;
4510:
4511: p_user_interface_type := 'FORM';