APPS.MTL_CCEOI_ACTION_PVT dependencies on MTL_CYCLE_COUNT_HEADERS

Line 421: p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS',

417: p_api_version => 0.9,
418: p_interface_rec => p_interface_rec,
419: p_message_name => 'INV_CCEOI_NO_UNSCHD_COUNTS',
420: p_error_column_name => 'UNSCHEDULED_COUNT_ENTRY',
421: p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS',
422: p_flags => '1$2$',
423: x_return_status => x_return_status,
424: x_msg_count => x_msg_count,
425: x_msg_data => x_msg_data);

Line 715: p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS',

711: p_api_version => 0.9,
712: p_interface_rec => p_interface_rec,
713: p_message_name => 'INV_CCEOI_NO_UNSCHD_COUNTS',
714: p_error_column_name => 'UNSCHEDULED_COUNT_ENTRY',
715: p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS',
716: p_flags => '1$2$',
717: x_return_status => x_return_status,
718: x_msg_count => x_msg_count,
719: x_msg_data => x_msg_data);

Line 1141: FROM mtl_cycle_count_headers where

1137:
1138:
1139: select next_user_count_sequence
1140: into MTL_CCEOI_VAR_PVT.G_Seq_No
1141: FROM mtl_cycle_count_headers where
1142: cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID;
1143:
1144:
1145: -- the following piece of code makes sure that count list sequence

Line 1170: update mtl_cycle_count_headers

1166: IF (l_debug = 1) THEN
1167: MDEBUG( 'Create New Sequence ='||to_char(MTL_CCEOI_VAR_PVT.G_Seq_No));
1168: END IF;
1169: --
1170: update mtl_cycle_count_headers
1171: set next_user_count_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No + 1
1172: where cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1173: L_errorcode := 0;
1174: L_return_status := FND_API.G_RET_STS_SUCCESS ;