DBA Data[Home] [Help]

APPS.GMF_XLA_PKG dependencies on GME_RESOURCE_TXNS

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

3053: --
3054: -- Update resource transaction table
3055: -- Decide what Flag to use when run in Draft Mode.
3056: --
3057: g_log_msg := 'Updating gme_resource_txns table for batch material transactions';
3058:
3059: print_debug(g_log_msg);
3060: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3061: THEN

Line 3069: UPDATE gme_resource_txns

3065: message => g_log_msg
3066: );
3067: END IF;
3068:
3069: UPDATE gme_resource_txns
3070: SET posted_ind = DECODE(G_accounting_mode, 'D', posted_ind, 'F', 1)
3071: , last_update_date = sysdate
3072: , last_updated_by = g_user_id
3073: , last_update_login = g_login_id

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

3086: and xpae.event_class_code = gxem.event_class_code
3087: )
3088: ;
3089:
3090: g_log_msg := sql%rowcount || ' rows updated in gme_resource_txns table';
3091:
3092: print_debug(g_log_msg);
3093: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3094: THEN

Line 4059: -- p_source_id_int_1: gme_resource_txns.poc_trans_id

4055: IF p_event_class_code = 'BATCH_RESOURCE'
4056: THEN
4057: --
4058: -- Should open Resource Transactions window in Batch Steps form
4059: -- p_source_id_int_1: gme_resource_txns.poc_trans_id
4060: -- p_security_id_int_1: organization_id
4061: --
4062:
4063: SELECT a.batch_id,

Line 4074: gme_resource_txns grt

4070: l_resource,
4071: l_batchstep_activity_id,
4072: l_batchstep_resource_id
4073: FROM gme_batch_step_resources a,
4074: gme_resource_txns grt
4075: WHERE grt.poc_trans_id = p_source_id_int_1
4076: AND grt.line_id = a.batchstep_resource_id;
4077:
4078: p_user_interface_type := 'FORM';